CODEWITHSUNDEEP
mysqlxampp
debonator
debonator

Reputation: 85

Lost Global Privileges on root@localhost in PHPMyAdmin (XAMPP)

Hi all and please help

I have been running XAMPP and PHPMyAdmin for a number of years on my PC. Both have served me well.

This morning I got an warning message basically saying give root a password because it was not secure. I did (or thought I had), but as a result Now all I can view is a database called information_schema.

I initially panicked, but then found that all my other test sites are working ok and I can still access them via their own username and password.

Therefore my question is: Please could anyone tell me how I can grant Global Privileges back on root@localhost? I have tried a number of things all morning but I get greeted either with a Syntax problem or a 1045 error message, saying Access Denied.

I welcome any help or advice. On the bright side, I have a password for root now!

Upvotes: 0

Views: 1362

Answers (2)

debonator
debonator

Reputation: 85

Ok. Sorted. In my case, I discovered that I had another global login and from the User list, I was able to grant global privileges for the root login once again

Upvotes: 0

RiggsFolly
RiggsFolly

Reputation: 94682

When you change the password on the root userid from within phpMyAdmin, you then have to put that password into the phpMyAdmin config.

So edit \xampp\phpmyadmin\config.inc.php

Find this line

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

and add the password to it

$cfg['Servers'][$i]['password'] = 'NEW_PASSWORD';

Upvotes: 1

Related Questions