linux cetos7安装mysql

转载
https://blog.csdn.net/qq_45938544/article/details/139599165

 

坑点：

查看mysql状态，有的是mysqld，有的是mysql

systemctl restart mysqld

systemctl restart mysql

 

远程连不上，打开防火墙开放3306端口，然后创个远程用户专门用来连接。

CREATE USER 'root2'@'%' IDENTIFIED BY 'Nbcb,111';
GRANT ALL PRIVILEGES ON *.* TO 'root2'@'%' WITH GRANT OPTION;

FLUSH PRIVILEGES;