XAMPP Error when i open PHPmyadmin

Question

I got this when I open phpmyadmin

You are connected as 'root' with no password, which corresponds to the default MySQL privileged account. Your MySQL server is running with this default, is open to intrusion, and you really should fix this security hole by setting a password for user 'root'.

How can I fix this?

@RaomB Hi, i think this is what you are looking for https://stackoverflow.com/a/12224464/7794860 — Long Kim, May 23 '17 at 04:45
@AhmedGinani check the image even when i change it , it give me the same error, and i reload the privilege and it give me the same error. should i copy the generated one or the password i write ? — RaomB, May 23 '17 at 04:58

score 1 · Answer 1 · answered May 23 '17 at 04:46

1

Open phpmyadmin

Users Accounts > Select user "root" > Edit Privileges > Change password

answered May 23 '17 at 04:46

Ahmed Ginani

6,522
2
15
33

check the image even when i change it , it give me thesame error, and reload the privilege. should i copy the generated one or the password i write ? – RaomB May 23 '17 at 04:57

score 0 · Answer 2 · answered May 23 '17 at 04:49

0

Run localhost->How-To Guides-> click on 'Reset the MySQL/MariaDB Root Password' -> Follow the steps

answered May 23 '17 at 04:49

Oops

1,373
3
16
46

please click edit privileges corresponding to root with password column 'YES' and then set the password. – Oops May 23 '17 at 05:11

score 0 · Answer 3 · answered May 23 '17 at 05:20

0

open phpmyadmin

Fire an update query

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPass');

Hope it helps!

answered May 23 '17 at 05:20

Shashank Shah

2,077
4
22
46

how can i fire i cant access any thing – RaomB May 23 '17 at 05:25
okay, not even phpmyadmin ? with username root with blank password ? – Shashank Shah May 23 '17 at 05:26
if you are having error :- can not connect : Invalid settings than you should locate your config.inc.php and comment it out controlhost,controlport,controluser and controlpassword. – Shashank Shah May 23 '17 at 05:48
c:\xamp\phpmyadmin.In that folder config.inc.php file would be present. – Shashank Shah May 23 '17 at 05:52

XAMPP Error when i open PHPmyadmin

3 Answers3