مشکل ران نشدن دیتابیس در سرور
من یک سری دستورات می زنم که جوابشون اینها هستن
tail -30 /*/mysql/`hostname`.err
کد:
2016-11-06 19:50:03 10491 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-11-06 19:50:03 10491 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-11-06 19:50:03 10491 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-11-06 19:50:03 10491 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-11-06 19:50:03 10491 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-11-06 19:50:03 10491 [Note] Shutting down plugin 'INNODB_METRICS'
2016-11-06 19:50:03 10491 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2016-11-06 19:50:03 10491 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2016-11-06 19:50:03 10491 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-11-06 19:50:03 10491 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2016-11-06 19:50:03 10491 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-11-06 19:50:03 10491 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2016-11-06 19:50:03 10491 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-11-06 19:50:03 10491 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-11-06 19:50:03 10491 [Note] Shutting down plugin 'INNODB_CMP'
2016-11-06 19:50:03 10491 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-11-06 19:50:03 10491 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-11-06 19:50:03 10491 [Note] Shutting down plugin 'INNODB_TRX'
2016-11-06 19:50:03 10491 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-11-06 19:50:03 10491 [Note] Shutting down plugin 'CSV'
2016-11-06 19:50:03 10491 [Note] Shutting down plugin 'MEMORY'
2016-11-06 19:50:03 10491 [Note] Shutting down plugin 'MRG_MYISAM'
2016-11-06 19:50:03 10491 [Note] Shutting down plugin 'MyISAM'
2016-11-06 19:50:03 10491 [Note] Shutting down plugin 'sha256_password'
2016-11-06 19:50:03 10491 [Note] Shutting down plugin 'mysql_old_password'
2016-11-06 19:50:03 10491 [Note] Shutting down plugin 'mysql_native_password'
2016-11-06 19:50:03 10491 [Note] Shutting down plugin 'binlog'
2016-11-06 19:50:03 10491 [Note] /usr/sbin/mysqld: Shutdown complete
161106 20:02:04 mysqld_safe mysqld from pid file /*/mysql/server.goweb.com ended
service mysqld restart
کد:
ERROR! MySQL server PID file could not be found!
Starting MySQL.. ERROR! The server quit without updating PID file (/*/mysql/server.goweb.com.pid).
mysql -uroot -p
کد:
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/usr/bin/mysqld_safe --user=mysql
کد:
161106 19:58:43 mysqld_safe Logging to '/*/mysql/server.goweb.com.err'.
161106 19:58:43 mysqld_safe Starting mysqld daemon with databases from /*/mysql
161106 19:58:44 mysqld_safe mysqld from pid file /*/mysql/server.goweb.com.pid ended
نمی دونم چرا دیتابیس ران نمیشه
پاسخ : مشکل ران نشدن دیتابیس در سرور
درود
دوست عزیز مشکل شما از PID SOCKET سرویس mysql هستش که اجرا نمیگردد
یکبار سرویس مذکورر را kill نمایید و مجددا start کنید شاید مشکلتون حل نشد
اگر نشد نیازمند بررسی تخصصی تر دارد که باید به root سرور دسترسی داشت که میتوانید مایل بودید از طریق سایت با ما در تماس باشید تا خدمتتون بررسی و حل گردد
