阿里云端安装mysql

首先查看系统版本，是64位的centos7

file /sbin/init

安装指南如下

https://www.cnblogs.com/thinkingandworkinghard/p/6711255.html

我安装成功以后就直接能启动了，只是修改了密码

最后修改密码后登陆mysql的代码不是mysql -u root而是mysql -hlocalhost -uroot -p

百度经验在linux上面登陆和退出mysql

https://jingyan.baidu.com/article/e4511cf37486c12b845eaf1c.html

 

 

想用本机pycharm来远程一下mysql

mysql>show variables;

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executin

然后改密码

mysql>  ALTER USER USER() IDENTIFIED BY '12345678';
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

我的密码不短也包含三种符号啊，干嘛要报错，不过不管它

mysql> set global validate_password_policy=0;
Query OK, 0 rows affected (0.00 sec)

现在的人都很暴力的，直接把判断密码的标准设置为只看长度

再修改一次就成功了

port都是3306

 

https://www.cnblogs.com/ivictor/p/5142809.html

 

转载于:https://www.cnblogs.com/stenci/p/10470562.html