MySQL Forums
Forum List  »  Newbie

MYSQL Grant Problems
Posted by: Angela Rock
Date: November 29, 2004 09:08AM

I have a dedicated server with over 75 accounts on it. The OS, including mysql, was recently reloaded, and since the reload we cannot get mysql to function normally. I have had 3 different sys admins work on this and nobody can seem to get it fixed.

The problem is with grants.

Apparently the only way to run mysql now is with --skip-grant-tables which of course is a security threat however without this parameter mysql will not start at all.

In addition, even with running it that way, every so often (15-20 times daily), all user databases just stop being able to connect. They lose their privileges. The only way to correct it and restore their access is to restart mysql.

Automated backups do not work either. This is an example of the output:

Grabbing mysql dbs...Done
Grabbing mysql privs...DBD::mysql::st execute failed: There is no
such grant defined for user 'xxx' on host 'localhost' at
/usr/local/cpanel/Cpanel/Mysql.pm line 328.
DBD::mysql::st fetchrow_arrayref failed: fetch() without execute() at
/usr/local/cpanel/Cpanel/Mysql.pm line 329.
DBD::mysql::st execute failed: There is no such grant defined for
user 'xxx' on host 'localhost' at
/usr/local/cpanel/Cpanel/Mysql.pm line 328.
DBD::mysql::st fetchrow_arrayref failed: fetch() without execute() at
/usr/local/cpanel/Cpanel/Mysql.pm line 329.
Done

All users do have grants defined. They just get "lost".

Again, after 3 different admins and countless hours of time this is still not resolved. It's imperative that I get it fixed, as the 100% functionality of mysql is necessary to my business.

Thank you in advance to anyone who can offer advice.

Options: ReplyQuote


Subject
Written By
Posted
MYSQL Grant Problems
November 29, 2004 09:08AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.