Cant change mysql password

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

Cant change mysql password

Postby zakkemakke » 11. August 2009 18:21


i know its been posted, and ive used search but it does not list my problem

i used Method 2

Well, there is still another possibility to set the root password. Start PHPMyAdmin with, open the database "mysql" (never delete this!) and use the table "user". Create here a new user or e.g. simply change the password of "root." MySQL restart! After that, do not forget to change the password in the "xampp/phpmyadmin/" for PHPMyAdmin.

i go to http://localhost/phpmyadmin -> mysql -> user
but then i see 4 users

"localhost" "pma"

ive tryed to edit them but nothing works
and i changed C:\xampp\phpMyAdmin\

$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';


$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'janvier';

and still it wont let me go to the login nor make it run

can anyone help me plz ?

Posts: 1
Joined: 11. August 2009 18:16

Re: Cant change mysql password

Postby Izzy » 12. August 2009 16:09

Return your to it's default settings.

Next try running C:\xampp\mysql\resetroot.bat which should delete any password you may have set and then see if you can access phpMyAdmin again without a password for user root.

If you can access now, then the best place to set the root user password for both mysql/phpmyadmin is in the Security page of the XAMPP Welcome Page (Apache Admin... button in the XCP).
Posts: 3344
Joined: 25. April 2006 17:06

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 54 guests