CentOS_mysql8.0

#参考资料

ERROR! The server quit without updating PID file (/usr/local/mysql/data/VM_0_13_centos.pid).

//重启

shutdown -r

Host '58.35.4.90' is not allowed to connect to this MySQL server.

//创建新用户，并授权

create user root2 identified by 'root2';

update user set host='%' where user='root2';

grant all privileges on *.* to 'root2'@'%';

SQLSTATE[HY000] [2054] Server sent charset unknown to the client.

//编码不对

vim /etc/my.cnf

[client]

default-character-set=utf8

[mysql]

default-character-set=utf8

[mysqld]

character-set-server = utf8

The server requested authentication method unknown to the client.

//验证机制不同

vim /etc/my.cnf

[mysqld]

default_authentication_plugin=mysql_native_password

Starting MySQL. ERROR! The server quit without updating PID file (/usr/local/mysql/data/VM_0_13_centos.pid).

//应该是权限问题

chown -R mysql:mysql /usr/local/mysql

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

//创建软连接

ln -s /usr/local/mysql/mysql.sock /tmp/mysql.sock

ERROR! MySQL server PID file could not be found!

//重启失败，关闭进程

killall mysqld