PDA

View Full Version : Root Account Has No Privileges in phpMyAdmin



TFizzle
17th September 2007, 11:39 AM
Just installed phpMyAdmin and there is a red x just below the Create DB link. I am logged on in the root account. How can I changed this?

Thanks.

TFizzle
17th September 2007, 11:40 AM
I would like for the root account to have Full Privileges.

markkuk
17th September 2007, 12:24 PM
The MySQL root account has all privileges by default, what did you do to remove root's rights?

TFizzle
17th September 2007, 12:41 PM
I think they were removed by accident.

Zotter
17th September 2007, 03:51 PM
First I'd confirm you have phpMyAdmin's config.inc.php setup correctly.

Can you access MySQL from CLI at all?

http://dev.mysql.com/doc/refman/4.1/en/default-privileges.html

Also, don't confuse MySQL's root account with your Linux root account - they are NOT the same thing.

Could you by chance have put your Linux root account password in phpMyAdmin's config.inc.php?? If so, remove it - leave the password null.
Trying to use a password on a MySQL account that has no password (default install), will cause a fail.



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

TFizzle
17th September 2007, 08:32 PM
Thanks. I am reading over the link. My root account is totally different from my phpMyAdmin account. I good on that one. The problem is that I must have mistakenly removed all privileges from the root account and need to reinstate privileges to the root account. I will read the link and let you know how things go. Thanks again.