Python3.7
pycharm
MySQL 8.0.13
阿里云服务器 windows server 2016
Navicat
一、远程数据库的配置
1、在云服务器系统上配置MySQL数据库
安装方法与本地数据库配置方法相同
配置完毕后登入MySQL数据库,并且修改初始密码
2、修改访问权限
登入数据库后首先输入
use mysql
选择musql数据库
select host,user,authentication_string,plugin from user;
输入上述代码,可看到root用户的访问权限
+-----------+------------------+------------------------------------------------------------------------+-----------------------+
| host | user | authentication_string | plugin |
+-----------+------------------+------------------------------------------------------------------------+-----------------------+
| localhost | root | *FD571203974BA9AFE270FE62151AE967ECA5E0AA | mysql_native_password |
| localhost | mysql.infoschema | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORD