mysql连接时没有 mysql.sock

### 遇到的问题，mysql连接时没有 mysql.sock

[root@test bin]# mysql -uroot -p
Enter password: 
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

进入 mysql 文件夹

cd /root/mysql-8.0.14-linux-glibc2.12-x86_64/bin

修改 my.conf 
vi /root/mysql-8.0.14-linux-glibc2.12-x86_64/my.cnf

[mysqld]
max_allowed_packet = 32M
character-set-server = utf8
key_buffer_size = 128M
innodb_buffer_pool_size = 4096M
tmp_table_size = 1024M
max_connections=3000
max_user_connections=3000
lower_case_table_names=1
socket=/var/lib/mysql/mysql.sock
user=root # 以 root 身份启动
symbolic-links=0
lower_case_table_names = 1

[mysql_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[client]
port=3306
socket=/var/lib/mysql/mysql.sock

以 root 身份启动
mysqld --user=root  --lower-case-table-names=1 &