Page 1 of 1

can someone please help me with this phpMyAdmin error??

PostPosted: 12. December 2009 00:01
by webmonkey8
Hello,

in PHPmyAdmin, I accidentally deleted the users:

"Any" and "pma" which were already there from the default installation of xampp.

Now in PHPmyAdmin, I'm receiving an error message:

Error
SQL Query
SELECT 'db_name',
"comment"
FROM
`phpmyadmin`.`pma_column_info`
WHERE `column_name` = '(db_comment)'

MySQL said:

#1142 - SELECT command denied to user ''@'localhost' for table 'pma_column_info'


Can someone please help me?
Thanks in advance!

Re: can someone please help me with this phpMyAdmin error??

PostPosted: 12. December 2009 02:53
by Izzy
Can you still access phpMyAdmin and create new users?

If so then under the Privileges menu simply Add new user, the pma user for localhost with no password and only grant limited Global access - Process, Reload and Shutdown - Click on Go.

The Any user you deleted is not a requirement so can be ignored if you wish but the pma user is required as you have found out.

The alternative is to uninstall XAMPP using either of the recommended methods and then do a fresh install.

Re: can someone please help me with this phpMyAdmin error??

PostPosted: 14. December 2009 22:25
by webmonkey8
Thank you very much.