I have had a seperate PHP/MySQL and Apache server working fine locally and i read somewhere that its a good idea to have XAMPP locally to test WordPress instead of doing 'live' changes on internet.
Been trying to do this for the last week - started with trying to get XAMPP (not lite) and that has failed but i have been mucking around and have now got it to the stage where i go to
http://localhost/xampp/index.php and it asks for language - i put in english, and then when i go here i get
Congratulations:
You have successfully installed XAMPP on this system!
Now you can start using Apache and Co. You should first try »Status« on the left navigation to make sure everything works fine.
so i check status, and it says all started except MySQL database which is 'deactivated'
The next step in the instructions (http://tamba2.org.uk/wordpress/xampp/) says to go to "After you have clicked your language and entered the program, click phpMyAdmin."
I do this and i get
Error
MySQL said:
#1045 - Access denied for user 'root'@'localhost' (using password: NO)
Connection for controluser as defined in your configuration failed.
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.
In orer to even get this far has been a nightmare, and i think it's because i have a previous install of PHP, MySQL and apache - which i used to test that my PHP scripts were working (these connect to the database and retrieve some info).
I'm not sure how to go further now. I dont want to delete my database - is there any other suggestions ? Is it trying to connect to my existing database? and if so where could i change the login info as its not gonna work with 'root'@'localhost' (using password: NO) as my existing database has a root password. I was under the impression it would create a new database, but i dont know the XAMPP product?
Thanks
Carolyn