مشکل Mysql در cpanel

[sojodyan]

سلام دوستان لطفا فوری کمک کنید

وقتی از پنل وب میخوام mysql رو ریستارت کنم این خطا رو میده :

Waiting for “mysql” to restart ……………………………………………………………………………………………………………………waiting for “mysql” to initialize …………………………………finished.

The service “mysql” failed to start with the message: mysql is not running
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!

Startup Log:
     Starting MySQL. ERROR! The server quit without updating PID file (/var/lib/mysql/server_ip_address.pid).

Log Messages:
     141220 13:46:30 mysqld_safe mysqld from pid file /var/lib/mysql/server_ip_address.pid ended
     /usr/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
     141220 13:46:30 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
     141220 13:44:27 mysqld_safe mysqld from pid file /var/lib/mysql/server_ip_address.pid ended
     /usr/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
     141220 13:44:27 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
     141220 13:40:30 mysqld_safe mysqld from pid file /var/lib/mysql/server_ip_address.pid ended
     /usr/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
     141220 13:40:29 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
     141220 13:39:54 mysqld_safe mysqld from pid file /var/lib/mysql/server_ip_address.pid ended
     /usr/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
     141220 13:39:54 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
     141220 13:39:31 mysqld_safe mysqld from pid file /var/lib/mysql/server_ip_address.pid ended
     /usr/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
     141220 13:39:31 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
     141220 13:39:17 mysqld_safe mysqld from pid file /var/lib/mysql/server_ip_address.pid ended
     /usr/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
     141220 13:39:17 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
     141220 13:35:06 mysqld_safe mysqld from pid file /var/lib/mysql/server_ip_address.pid ended
     /usr/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
     141220 13:35:05 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
     141220 13:33:43 mysqld_safe mysqld from pid file /var/lib/mysql/server_ip_address.pid ended

mysql has failed. Please contact your system administrator if the service does not automagically recover.

[secureconfig]

سلام.

نتیجه ی دستور زیر را قرار دهید :

tail -30 /var/lib/mysql/`hostname`.err

[sojodyan]

سلام.

نتیجه ی دستور زیر را قرار دهید :

tail -30 /var/lib/mysql/`hostname`.err

همینه دی
ه برادر :

141220 13:44:27 mysqld_safe mysqld from pid file /var/lib/mysql/server_ip_address.pid ended
141220 13:46:30 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
141220 13:46:30 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
141220 13:46:30 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
141220 13:46:30 InnoDB: The InnoDB memory heap is disabled
141220 13:46:30 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141220 13:46:30 InnoDB: Compressed tables use zlib 1.2.3
141220 13:46:30 InnoDB: Using Linux native AIO
141220 13:46:30 InnoDB: Initializing buffer pool, size = 128.0M
141220 13:46:30 InnoDB: Completed initialization of buffer pool
141220 13:46:30  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
141220 13:46:30 mysqld_safe mysqld from pid file /var/lib/mysql/server_ip_address.pid ended
141220 13:56:18 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
141220 13:56:18 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
141220 13:56:18 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
141220 13:56:18 InnoDB: The InnoDB memory heap is disabled
141220 13:56:18 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141220 13:56:18 InnoDB: Compressed tables use zlib 1.2.3
141220 13:56:18 InnoDB: Using Linux native AIO
141220 13:56:18 InnoDB: Initializing buffer pool, size = 128.0M
141220 13:56:18 InnoDB: Completed initialization of buffer pool
141220 13:56:18  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
141220 13:56:18 mysqld_safe mysqld from pid file /var/lib/mysql/server_ip_address.pid ended
141220 13:59:11 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
141220 13:59:11 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
141220 13:59:11 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
141220 13:59:11 InnoDB: The InnoDB memory heap is disabled
141220 13:59:11 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141220 13:59:11 InnoDB: Compressed tables use zlib 1.2.3
141220 13:59:11 InnoDB: Using Linux native AIO
141220 13:59:11 InnoDB: Initializing buffer pool, size = 128.0M
141220 13:59:11 InnoDB: Completed initialization of buffer pool
141220 13:59:11  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
141220 13:59:11 mysqld_safe mysqld from pid file /var/lib/mysql/server_ip_address.pid ended
141220 13:59:41 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
141220 13:59:41 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
141220 13:59:41 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
141220 13:59:41 InnoDB: The InnoDB memory heap is disabled
141220 13:59:41 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141220 13:59:41 InnoDB: Compressed tables use zlib 1.2.3
141220 13:59:41 InnoDB: Using Linux native AIO
141220 13:59:41 InnoDB: Initializing buffer pool, size = 128.0M
141220 13:59:41 InnoDB: Completed initialization of buffer pool
141220 13:59:41  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to

[---]

سلام مازیار عزیز

chown -R mysql:mysql /var/lib/mysql

[j4b3r]

سلام
در موراد خطا با mysql همیشه اولا این کارها رو انجام بدید:
1. فضای هارد را چک کنید که پارتیشنی پرنشده باشه
2. فایل my.cnf رو تغییر نام دهید و مجدد ری استارت کنید
اگر مشکل یاقی مانده بود یراغ مراحل بعدی برید.
الان شما دو مورد را انجام بدید.

[pentester]

سلام
منم همین مشکل رو دارم !!!



root@server [~]# service mysql start
Starting MySQL..The server quit without updating PID file (/var/lib/mysql/server.domain.com.pid). [FAILED]
root@server [~]#

چجور باید لاگ ها رو حذف کنم ؟؟ :دی

مسیر لاگ ها رو و نحوه حذف کردنشون رو اگه بگید ممنون میشم

[shahab-f]

javaneboy
اد کنید دسترسی بدید مشکلتون رو بررسی و رفع کنم

[---]

مشکل این دوستمون رو بنده حل کردم سلوشنش رو براتون گذاشتم ...
گروه پوشه ی مای اسکیو ال چیزی غیر از mysql بود ...

[pentester]

javaneboy
اد کنید دسترسی بدید مشکلتون رو بررسی و رفع کنم

سلام
پیغام خصوصی دادم صندوق پیام هاتون پر بوود

ایمیل بدید ارسال کنم

- - - Updated - - -

- - - Updated - - -

دوستان مشکل من حل شد

هارد سرور پر شده بود و فایل mysqld.sock پاک شده بود