Linux安装mysql----------这一篇就够了

aliyun安装mysql(写的有点乱,但是,你的问题,这里都有,有其他问题可以留言)

https://blog.csdn.net/qq_35393693/article/details/79994097

 

遇到问题向下看

 

(第七步:设置允许远程登录

Mysql默认不允许远程登录,我们需要设置下,并且防火墙开放3306端口;)

下面是第七步,一定要注意中英文标点

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '密码';
#记得提交
FLUSH PRIVILEGES;

上面这步有点问题

(1251- Client does not support authentication protocol requested by server; consider upgrading MysQL client)解决:

https://blog.csdn.net/qq_40374604/article/details/84962453

CentOS 配置mysql允许远程登录

https://www.cnblogs.com/me-sa/articles/2080406.html

 

 

centos7-mysql修改密码命令

(vim /etc/my.cnf)

【转载】Centos7.3安装和配置Mysql5.7_mysql

添加(skip-grant-tables)

进入MySQL后的指令


use mysql;

update mysql.user set authentication_string=password("你的密码大写字母和数字尽量多而复杂") where user="root";

flush privileges;

quit;