What I startup the mysql , it pop the below error ,

[code]
140530 17:11:47 mysqld_safe Starting mysqld daemon with databases from /data/mysqld/edp
140530 17:11:47 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
140530 17:11:47 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
140530 17:11:47 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
140530 17:11:47 InnoDB: Initializing buffer pool, size = 8.0M
140530 17:11:47 InnoDB: Completed initialization of buffer pool
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
140530 17:11:47 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Page directory corruption: infimum not pointed to
140530 17:11:47 InnoDB: Page dump in ascii and hex (16384 bytes):
[code/]

From another log , there is the below error .

[code]
cat: /log/mysqld/w2/run/mysqld.pid: No such file or directory
New PID:
ERROR: List of process IDs must follow -p.
[code\]

Then I tried the command mysql_upgrade -u root -p --force , it seems normal to do upgrade , however , the error persist , would advise how can I fix the error ? thanks

These seem to be the key lines
If it failed to recover, you'd better hope you have no important data there, or that you do have a backup.
You'll need to re-install the SW and you might(!) be able to recover the DB data ... maybe.

Hi ,

Thanks reply , I tried stop and start the db , it is normal , besides , I checked the plugin tables is exist in the mysql db , would advise what is the possible reason of the error ? thanks

Pretty difficult to tell, but these 2 lines try
Looks like someone pulled the plug ...

thanks reply ,

I tried the command mysql_upgrade , but got the following error , would advise what is wrong ? thanks

#mysql_upgrade -u root -p
Enter password:
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck with default connection arguments
mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect
FATAL ERROR: Upgrade failed

you can share file config in /etc/my.cnf direction.
I will help you.

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

Hi thangict93 ,

Would you help for it ? thanks

Is my question not clear enough ? thanks

my full error log is below , would advise how to fix it ? thanks

mysqld_safe Starting mysqld daemon with databases from /data/mysqld/w2
[Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
[Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
[ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: Initializing buffer pool, size = 8.0M
InnoDB: Completed initialization of buffer pool
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
140618 17:45:00 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Page directory corruption: infimum not pointed to
140618 17:45:00 InnoDB: Page dump in ascii and hex (16384 bytes):

1. restart PC.
or
2.
#ps -ef | grep my
#kill -9 [PID]