linux下mysql8.0安装问题记录

1，mysqld: [Warning] World-writable config file '/etc/my.cnf' is ignored.

mysql安全机制担心被多用户修改。

解决办法：chmod 644 /etc/my.cnf 

2，[ERROR] [MY-010187] [Server] Could not open file '/data/mysql/mysql-error.log'

临时解决方法：

setenforce 0

3，Can't start server : Bind on unix socket: Address already in use

 systemctl start mysqld.service显示错误：

查看错误日志：

网上查询了资料说是端口被占用

用  ps -af | grep mysq

lsof -i:3306

netstat -na | grep LISTEN

等命令均未找到占用的进程和端口。

后将注意力放在了/etc/my.cnf上.

vim /etc/my.cnf

重新编辑了socket=/tmp/mysql.sock

保存重启，问题解决。

mysql登录：

./mysql -u root -p

use mysql 

mysql> update user set host = '%' where user = 'root'; 
Query OK, 1 row affected (0.28 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> 
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)

mysql> 
mysql> 
mysql> 
mysql> alter user "root"@"%" identified by "wei130132";
Query OK, 0 rows affected (0.01 sec)

mysql> 
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

设置开机自启动：

systemctl enable mysqld.service