Cannot log in to my phpMyAdmin when changed password

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Cannot log in to my phpMyAdmin when changed password

Postby baxtex » 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
baxtex
 
Posts: 1
Joined: 14. April 2016 08:27
XAMPP version: 3.2.2
Operating System: Windows 10

Re: Cannot log in to my phpMyAdmin when changed password

Postby Altrea » 14. April 2016 15:48

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
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11933
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: Cannot log in to my phpMyAdmin when changed password

Postby casaroc » 29. April 2016 11:09

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
casaroc
 
Posts: 6
Joined: 26. February 2013 17:36
Operating System: Vista


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 200 guests