请教军哥大佬，服务器宕机一次后重启就无法启动mysql

蓝色枫

1. Stoping LNMP...
   
2. Stoping nginx...  done
   
3. ERROR! MySQL server PID file could not be found!
   
4. Gracefully shutting down php-fpm . done
   
5. Starting LNMP...
   
6. Starting nginx...  done
   
7. Starting MySQL. ERROR! The server quit without updating PID file (/usr/local/mysql/var/elogrewf.com.pid).
   
8. Starting php-fpm  done
   

复制代码

/usr/local/mysql/var/elogrewf.com.err的内容：

1. 220509 14:35:43 [Note] Plugin 'FEDERATED' is disabled.
   
2. 220509 14:35:43 [Note] Plugin 'InnoDB' is disabled.
   
3. /usr/local/mysql/bin/mysqld: Can't find file: 'plugin' (errno: 2)
   
4. 220509 14:35:43 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
   
5. 220509 14:35:43 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
   
6. 220509 14:35:43 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
   
7. 220509 14:35:43 [Note] Server socket created on IP: '0.0.0.0'.
   
8. 220509 14:35:43 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
   

复制代码

my.cnf配置，都是默认安装的配置，印象中是没改过

1. [client]
   
2. #password        = your_password
   
3. port                = 3306
   
4. socket                = /tmp/mysql.sock
   
5. 
   
6. [mysqld]
   
7. port                = 3306
   
8. socket                = /tmp/mysql.sock
   
9. datadir = /usr/local/mysql/var
   
10. default_storage_engine = MyISAM
    
11. loose-skip-innodb
    
12. skip-external-locking
    
13. key_buffer_size = 256M
    
14. max_allowed_packet = 1M
    
15. table_open_cache = 1024
    
16. sort_buffer_size = 4M
    
17. net_buffer_length = 8K
    
18. read_buffer_size = 4M
    
19. read_rnd_buffer_size = 512K
    
20. myisam_sort_buffer_size = 64M
    
21. thread_cache_size = 128
    
22. query_cache_size = 128M
    
23. tmp_table_size = 128M
    
24. 
    
25. #skip-networking
    
26. max_connections = 500
    
27. max_connect_errors = 100
    
28. open_files_limit = 65535
    
29. 
    
30. log-bin=mysql-bin
    
31. binlog_format=mixed
    
32. server-id        = 1
    
33. expire_logs_days = 10
    
34. 
    
35. #innodb_file_per_table = 1
    
36. #innodb_data_home_dir = /usr/local/mysql/var
    
37. #innodb_data_file_path = ibdata1:10M:autoextend
    
38. #innodb_log_group_home_dir = /usr/local/mysql/var
    
39. #innodb_buffer_pool_size = 16M
    
40. #innodb_additional_mem_pool_size = 2M
    
41. #innodb_log_file_size = 5M
    
42. #innodb_log_buffer_size = 8M
    
43. #innodb_flush_log_at_trx_commit = 1
    
44. #innodb_lock_wait_timeout = 50
    
45. 
    
46. [mysqldump]
    
47. quick
    
48. max_allowed_packet = 16M
    
49. 
    
50. [mysql]
    
51. no-auto-rehash
    
52. 
    
53. [myisamchk]
    
54. key_buffer_size = 256M
    
55. sort_buffer_size = 4M
    
56. read_buffer = 2M
    
57. write_buffer = 2M
    
58. 
    
59. [mysqlhotcopy]
    
60. interactive-timeout

复制代码

求教军哥大佬，查了大半天百度谷歌都没解决才来打扰军哥大佬的，谢谢

licess

大概率是你误删了mysql数据库目录下的文件
先！！！备份 /usr/local/mysql/var 目录！！！，再进行下面操作试试
你没有说明mysql具体版本
MySQL 5.5/5.6
/usr/local/mysql/scripts/mysql_install_db --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql
MySQL 5.7及更高版本：
/usr/local/mysql/bin/mysqld --initialize-insecure --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql

/etc/init.d/mysql start
/usr/local/mysql/bin/mysqladmin -u root password 要设置的密码

正常情况下应该就能恢复了

蓝色枫

licess 发表于 2022-5-9 19:55
大概率是你误删了mysql数据库目录下的文件
先！！！备份 /usr/local/mysql/var 目录！！！，再进行下面操作 ...

非常感谢军哥大佬，可能是服务器不正常关机啥的导致的，已经卸载lnmp重装，保存留着下次用，这个服务器遇到两三次了。。。再次感谢

海豚V靓仔

licess 发表于 2022-5-9 19:55
大概率是你误删了mysql数据库目录下的文件
先！！！备份 /usr/local/mysql/var 目录！！！，再进行下面操作 ...

找了百度、狗哥半天没解决才来问，想着他辛苦回答了，却不想他重装解决了，哈哈！