Hi all.
I got a problem wich eludes me, i have tried to come up with solutions and failed. Thatīs why i turn to you.
Anyway to make a long story short, i installed a webserver (Aprelium Abyss Webserver) and PHP 5.2.5 wich run excelent and fine.
The problem started when i wanted MySQL database integration.
I installed MySQL 5.0.45 for windows on the same machine as the webserver. I got MySQL configured and changed the "root" users password. So far so good.
Now i can not figure out why i can connect to the MySQL server with SQLyog using the "root" user and his password and work with databases and tables just fine, but not via PHP with the standard MySQL connection proceedures with connecting with login credentials and choosing a database. and then when i run SQL query this is whats comes out:
Code:
Could not perform MySQL query: Access denied for user 'ODBC'@'localhost' (using password: NO)
as it been a while since i worked with a server "at home" i thought that it was permission related so with the "root" user logged in to SQLyog i created a regular user named "mysite" and gave it limited permissions so it could read and list and manipulate tables to some degree. but that donīt seem to have worked either.
It may be a simple overlook on my part. i have checked that the extensions for php_mysql.dll gets loaded and are in the right location.
Would be much aprechiated for help in this mather.
Is there any other info you need i will suply it when asked.
/EyeDentify
Edit: Problem solved.
Seems i wasenīt using my brain and a simple typo did hinder me from connecting. so while i get my foot out of my mouth i wish you all a nice weekend.