Bug #32024 [ERROR] Fatal error: Can't open and lock privileges tables: Table 'user' is mark

• Submitted: 1 Nov 2007 10:23
• Modified: 1 Nov 2007 11:55
• Reporter: MySQL Fan
• Status: Not a Bug
• Category: MySQL Server: Errors
• Severity: S1 (Critical)
• Version: 4.1.22
• OS: MacOS
• CPU Architecture: Any

[1 Nov 2007 10:23] MySQL Fan

Description:
I was working on my PHP/MySQL project and just wanted to refresh the
webpage to regenerate data when all of a sudden the web page displays
the following message:
Warning: mysql_connect() [function.mysql-connect]: Can't connect to
local MySQL server through socket '/var/mysql/mysql.sock' (2) in [path]
on line 9
Can't connect to local MySQL server through socket
'/var/mysql/mysql.sock' (2)

When checking the log I discovered the following message:

"[ERROR] Fatal error: Can't open and lock privileges tables: Table
'user' is marked as crashed and should be repaired"

I can't even connect to MySQL anymore!

I have never seen this message before. Any suggestion/feedback on what
this means.

Thank you

How to repeat:
Cannot be repeated since one cannot log in MySQL

[1 Nov 2007 11:55] Hartmut Holzgraefe

We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.