Xibo

cannot access mysql admin page

Asked by barberj66

I have installed xampp and xibo etc and have it all set up ok and working. Now when I click on the admin button on xampp for mysql it says
#1045 - Access denied for user 'root'@'localhost' (using password: NO)
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.

I set a password when I originally set the server up but it doesn't give me an option to enter one. Any ideas on whats gone wrong? I've never used xampp/mysql or any other applications related to these so I'm at a total loss.

I did try to enter a password in the config file in xampp\phpmyadmin\config.inc but it would not let me save the changes to the file and said access denied
Thanks

Question information

Language:
English Edit question
Status:
Solved
For:
Xibo Edit question
Assignee:
No assignee Edit question
Solved by:
Alex Harrington
Solved:
Last query:
Last reply:
Revision history for this message
Alex Harrington (alexharrington) said : 		#1

If you follow the guide in the wiki we get you to change the MySQL admin password and that causes you to be locked out of MySQLAdmin as the default assumes there is no password set on the account - which is horribly insecure.

I don't know why it won't let you change the defaults in config.inc - that's what you need to do.

I'd suggest speaking to the people who do XAMPP and seeing if they know. But first perhaps check that the file isn't read only or something silly like that.

Alex

Revision history for this message
Best Alex Harrington (alexharrington) said : 		#2

http://www.apachefriends.org/en/faq-xampp-windows.html#password1

Implies you should be able to edit that file. There's also method 1 which apparently will fix your mysqladmin password too. I've not tested it though as it's not something I use (and it's not our software!)

Alex

Revision history for this message
barberj66 (jamesbarber) said : 		#3

Thanks Alex Harrington, that solved my question.