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;

posted @ 2025-06-12 23:39  傲云萧雨  阅读(4)  评论(0)    收藏  举报