can someone please help me with this phpMyAdmin error??

Problems with the Windows version of XAMPP, questions, comments, and anything related.

can someone please help me with this phpMyAdmin error??

Postby webmonkey8 » 12. December 2009 00:01

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!
webmonkey8
 
Posts: 2
Joined: 20. October 2009 18:05

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

Postby Izzy » 12. December 2009 02:53

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.
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06

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

Postby webmonkey8 » 14. December 2009 22:25

Thank you very much.
webmonkey8
 
Posts: 2
Joined: 20. October 2009 18:05


Return to XAMPP for Windows

Who is online

Users browsing this forum: Onion and 205 guests