error connecting to mysql

could not fetch user names

[elliotash]

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]

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]

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

[elliotash]

i got a post that helped resolved the issue

[dev.mysql.com...]