Page 1 of 1

Cannot log in to my phpMyAdmin when changed password

PostPosted: 14. April 2016 08:30
by baxtex
So I just set a database with XAMPP and it works fine, except when I try to change the password. I have tried changing it with this command: mysqladmin --user=root --password="" password "123"

Now the passsword should be 123 for the root user. Now when I try to enter the web server hosting the client to use with the database, I get an error:
MySQL said: Documentation Cannot connect: invalid settings.

This seems fine with me, I haven't specified any password. Then I open the my.ini file and change the password to 123 and remove the hashtag so it looks like this: password = 123

But I still can't log in.

I have looked at these suggestions but they don't work for me:

http://stackoverflow.com/questions/17759776/how-to-get-login-option-for-phpmyadmin-in-xampp
http://stackoverflow.com/questions/36598725/cannot-log-in-to-my-phpmyadmin-when-changed-password

Re: Cannot log in to my phpMyAdmin when changed password

PostPosted: 14. April 2016 15:48
by Altrea
This guide is for setting the password for the user root but can easily be adapted to any other user:
[Q&A]Setting MySQL root password

Re: Cannot log in to my phpMyAdmin when changed password

PostPosted: 29. April 2016 11:09
by casaroc
Excellent advice! Locked out of PHPAdmin after changing password, now I'm back in touch. One thing - the config file you have to amend " cookies" to is in the Apache config menu on XAMPP not the SQL, However, if you seek, you shall find!!
Many tanks
Steve Green :D