mysql编译安装启动报错 ERROR! The server quit without updating PID file (/var/lib/mysql/mysql.pid).

mysql编译安装启动报错

ERROR! The server quit without updating PID file (/var/lib/mysql/mysql.pid).

原因：mysql的/etc/my.cnf 配置文件有suchazz.com" target="_blank" class="yzm-keyword-link">www.suchazz.com" target="_blank" class="yzm-keyword-link">suchazz.com" target="_blank" class="yzm-keyword-link">问题

解决办法：vi /etc/my.cnf

将下列配置复制到配置文件

##数据存储位置，该位置配置与编译安装目录不一致导致描述suchazz.com" target="_blank" class="yzm-keyword-link">www.suchazz.com" target="_blank" class="yzm-keyword-link">suchazz.com" target="_blank" class="yzm-keyword-link">问题

datadir=/usr/local/mysql/data

socket=/usr/local/mysql/mysql.sock

port = 3306

##数据库安装目录，该位置配置与编译安装目录不一致导致描述suchazz.com" target="_blank" class="yzm-keyword-link">www.suchazz.com" target="_blank" class="yzm-keyword-link">suchazz.com" target="_blank" class="yzm-keyword-link">问题

basedir=/usr/local/mysql

character-set-server=utf8

default-storage-engine=InnoDB

max_connections=5120

query_cache_size=0

tmp_table_size=18M

log-error = /usr/local/mysql/mysql-error.log

thread_cache_size=8

myisam_max_sort_file_size=64G

myisam_sort_buffer_size=35M

key_buffer_size=25M

read_buffer_size=64K

read_rnd_buffer_size=256K

sort_buffer_size=256K

innodb_flush_log_at_trx_commit=1

innodb_log_buffer_size=1M

innodb_buffer_pool_size=47M

innodb_log_file_size=24M

innodb_thread_concurrency=8