Forum Moderators: coopster
Having trawled around quite alot over the last few days trying to figure this one out, I thought I better ask :)
Ok here's the setup :-
WinMe machine as server, with Apache 2 installed and working PHP4 installed and working ( had PHP 5.05 installed and working, but i couldnt get the mysql extensions to load - phpinfo() didnt list mysql :(, so i installed PHP4, which now lists mysql when i run phpinfo). MYSQL 4.1 installed and working. I dont know the console commands too well, but i know its working ok, cos I have used a few simple DOS prompt commands to check its alive and I can connect to the database using MyODBC frontend/driver 3.51 and also using Navicat 2004.
When i try to connect to the database via PHPmyadmin from another network PC I have an error:
#1045 - Access denied for user 'user'@'localhost' (using password: YES)
I have played around alot with different settings in the config.inc.php file.... nothing seems to work.
This almost appears to be a simple login problem ( probably is too), but I can access the database locally from the Winme machine with the username and password that wont work over the network!
I have tried not using 'localhost' as the host name but the IP address of the Winme PC but I get this error:
#1130 - Host 'MYSERVERNAME' is not allowed to connect to this MySQL server
Any ideas?
You are probably running into a known issue with Connecting to mySQL 4.1.1 [webmasterworld.com]. As far as PHP5, you just didn't have your configuration quite right. There is a thread in our PHP Forum Library that describes some steps on troubleshooting your PHP/MySQL setup.
Ok I have tried a slightly different tac to try and solve this one and still have some problems.
Thinking I could have a problem free install using a third party installer I decided to use XAMPP. I installed XAMPP and basicaly ended up in the same place as before, whereby APACHE 2, PHP5.05 MYsql 4.1 all worked ok - acces was available to the mysql database via Navicat.
As soon as I tried to access the database with PHPmyadmin I was getting the old mysql extension problem. Like it couldnt find php_mysql.php
The oddest thing was that when I ran phpinfo() mysqli was listed ..... ( first time for me ) which sounds like a step forward, however the phpmyadmin error listed mysql as the extension it couldn't load....
Confusing!
Changes to the config.inc.php and php.ini listed in the XAMPP docs had no effect after editing/restarting the Apache server. I need to recheck manually which path the ACTUAL files are being read from, but I sort of expected the XAMPP install to sort this all out.
This maybe a simple path/directory issue, but i somehow doubt it given that i have seen the mysql extension loading problems before when i attempted to install the WAMP software manually. I spent a long time messing around with the paths and locations of libmysql.dll and php_mysql and php_mysqli to no avail.
I have seen other people with the load mysql extensions on other forums, but nobody seems to have a straight forward answer to this problem with phpmyadmin.
Just hope someone here knows :D
Thanks in advance
