error connecting to mysql

Forum Moderators: open

Message Too Old, No Replies

error connecting to mysql

could not fetch user names

elliotash

8:03 am on Jul 24, 2009 (gmt 0)

Hello webmaster i am having a problem trying to access the 'user administration' in the database to create new users the message is-

could not fetch user names. The following error occurred. Select command denied to user ‘omni@localhost’ for table ‘user’ 1142

please note also that i cannot remember the root user password

is there any work around without having to reinstall, i did not do the original install and i am a newbie

janharders

8:17 am on Jul 24, 2009 (gmt 0)

the user omni does not have sufficient access rights.
you'll need to set a new root password for mysql, I'm afraid, unless you have a user that may access and update the user-table. To do that, you'll need administrative access to the server itself, so you can shut down mysql and start it in safe mode without grant-checks.
use your favorite search engine and look for "mysql forgot root password", there are plenty of howtos out there.

elliotash

8:25 am on Jul 24, 2009 (gmt 0)

i have access to shut down the service, how can i start in safe mode

elliotash

10:00 am on Jul 24, 2009 (gmt 0)

i got a post that helped resolved the issue

[dev.mysql.com...]