Cannot log in to my phpMyAdmin when changed password
Posted: 14. April 2016 08:30
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
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