Re: Automatic reply: "access denied" to non-root@localhost & null-string user in USER_PRIVILEGES

2013-01-03 Thread Shawn Green
Hello Round, On 12/27/2012 5:34 AM, Round Square wrote: On 12/26/2012 01:25 PM, Igor Shevtsov wrote: You mysql.user table might be corrupted. If you have access to it as a root user, try check table mysql.user, and repair table mysql.user if table corruption was detected. Alternatively, shut d

Re: Automatic reply: "access denied" to non-root@localhost & null-string user in USER_PRIVILEGES

2012-12-27 Thread Round Square
On 12/26/2012 01:25 PM, Igor Shevtsov wrote: > You mysql.user table might be corrupted. > If you have access to it as a root user, try check table mysql.user, and > repair table mysql.user if table corruption was detected. > Alternatively, shut down mysql server, cd /var/lib/mysql/mysql (to your

Re: "access denied" to non-root@localhost & null-string user in USER_PRIVILEGES

2012-12-26 Thread Igor Shevtsov
You mysql.user table might be corrupted. If you have access to it as a root user, try check table mysql.user, and repair table mysql.user if table corruption was detected. Alternatively, shut down mysql server, cd /var/lib/mysql/mysql (to your $datadir/mysql directory) and run mysqlcheck -r mys

"access denied" to non-root@localhost & null-string user in USER_PRIVILEGES

2012-12-26 Thread Round Square
Hi all: Suddenly, after a long, functioning run of the mysql server, all the non-root accounts went bad, with: Access denied for user 'non_root_user'@'localhost' (using password: YES) Authenticating with "non_root_u...@server.ip.address" still works ( the bind-address in my.cnf is