宝塔面板mysql数据库无法启动的解决方法。

今天真的是遇到的大麻烦了。本来想在服务器上再搭建一个网站的，结果不知道弄了哪里，导致了mysql数据库直接无法启动了。网上找遍了所有方法都没有解决。最后还是在一个博客上找到的解决方法。于是记录一下，方便下次遇到这个问题的时候不用折腾这么久。

语句如下：

我当时就用了这一条语句就OK了，之后还翻过别的资料，有些人还说要做下面这些东西，我也没认真看，先都copy一份吧，下次出问题再回头来翻这里看看：

首先、检查宝塔面板MySQL无法启动（自动停止）出错原因：

wget -O sql-repair.sh http://download.bt.cn/install/sql-repair.sh && sh sql-repair.sh

然后、宝塔面板 /etc/my.cnf 的设置内容（MySQL 5.6 my.cnf 的设置内容）：

[client]

#password = your_password

port = 3306

socket = /tmp/mysql.sock

[mysqld]

port = 3306

socket = /tmp/mysql.sock

datadir = /www/server/data

default_storage_engine = MyISAM

#skip-external-locking

#loose-skip-innodb

key_buffer_size = 8M

max_allowed_packet = 1M

table_open_cache = 32

sort_buffer_size = 256K

net_buffer_length = 4K

read_buffer_size = 128K

read_rnd_buffer_size = 256K

myisam_sort_buffer_size = 4M

thread_cache_size = 4

query_cache_size = 4M

tmp_table_size = 8M

sql-mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTIO

#skip-networking

#skip-name-resolve

max_connections = 500

max_connect_errors = 100

open_files_limit = 65535

log-bin=mysql-bin

binlog_format=mixed

server-id = 1

expire_logs_days = 10

default_storage_engine = InnoDB

innodb_data_home_dir = /www/server/data

innodb_data_file_path = ibdata1:10M:autoextend

innodb_log_group_home_dir = /www/server/data

innodb_buffer_pool_size = 16M

innodb_additional_mem_pool_size = 2M

innodb_log_file_size = 5M

innodb_log_buffer_size = 8M

innodb_flush_log_at_trx_commit = 1

innodb_lock_wait_timeout = 50

[mysqldump]

quick

max_allowed_packet = 16M

[mysql]

no-auto-rehash

[myisamchk]

key_buffer_size = 20M

sort_buffer_size = 20M

read_buffer = 2M

write_buffer = 2M

[mysqlhotcopy]

interactive-timeout

最后、用下面的命令代码生效一下：

/www/server/mysql/scripts/mysql_install_db --defaults-file=/www/server/mysql/my.cnf --basedir=/www/server/mysql --datadir=/www/server/data/ --user=mysql

一共也就两条语句。
原文链接：https://blog.csdn.net/stinkstone/article/details/108879923