导读:mysql 运行报错: ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock&...
mysql 运行报错: ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’
最终方案(来自大佬的教学):
首先创建以下目录,可以先看一下自己有没有该目录,有的话,说明和我出现的问题不安全一致
mkdir /usr/local/mysql/data \
/usr/local/mysql/var \
/usr/local/mysql/var/lib \
/usr/local/mysql/var/log \
/usr/local/mysql/var/run
第二步:看着像是初始化的一个操作
/usr/local/mysql/bin/mysqld --initialize --datadir=/usr/local/mysql/data
第三步:
在/etc下创建my.cnf文件,内容如下:
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
[mysqld]
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
datadir=/usr/local/mysql/data
# socket=/usr/local/mysql/var/lib/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
log_error=/usr/local/mysql/var/log/mysqld.log
pid_file=/usr/local/mysql/var/run/mysqld.pid
最后一步:猜测是将mysqld设置为后台运行
/usr/local/mysql/bin/mysqld --daemonize