Apache Friends Support Forum

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

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).