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

Hi

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 http://127.0.0.1/phpmyadmin, 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/config.inc.php" for PHPMyAdmin.


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

"localhost"
"127.0.0.1"
"localhost"
"localhost" "pma"

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

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

to

$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 ?

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

Re: Cant change mysql password

Postby Izzy » 12. August 2009 16:09

Return your config.inc.php 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).
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 49 guests