I installed XAMPP and set a password and username for MySQL. The service is running, but the following problems are occuring:
1. When trying one of the XAMPP demos, a CD Collection, I get an error:
"Warning: mysql_connect() [function.mysql-connect]: Access denied for user '*****'@'localhost' (using password: YES) in C:\Program Files\xampp\htdocs\xampp\cds.php on line 65
Could not connect to database!
Is MySQL running or did you change the password?"
I changed the password initially for security reasons, as advised. I also restarted MySQL from the XAMPP Control Panel. Or do you need to reboot?
It picks up the username and password in the MySQL admin screen, and I've entered the details into the file cds.php as mentioned above, but it still fails.
2. Going into phpMyAdmin, it gives this error:
"phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server.
Cannot connect: invalid settings."
But I have followed the instructions and entered the username and password in the file config.inc.php.
The only thing I'm not sure about is the setting for auth_type - should I use http, config or cookie? I have set it to config as that requires a password. (It was set to http but that didn't work at all.)
Also, in the MySQL admin screen, I'm not seeing many details shown - nothing for a database or table rows is listed. Do I need to set up a database first, before running any demos? If so, how? I couldn't see any options for doing this anywhere.
I assume I need phpMyAdmin but I can't get it to work!
Also it says under MyODBC "Not Found. Driver 3.51". Am I missing an important file?
Please help this MySQL newbie any way you can...