未经允许
*Navicat**远程链接mysql-8数据库具体操作方案*
*一：本地链接*
*二：公有云链接*
*备注：此文档是以root用户演示。项目最好用其他用户*
*具体步骤：*
*公有云链接*
*1.登录mysql数据库* *mysql -uroot -pXXX*
创建普通用户并授权
*2. 查看*
执行：show databases;
use mysql
SELECT Host, User, plugin from user
*3.修改root或者普通用户的加密方式*
执行修改命令根据你需要访问的host进行修改 (当前模拟是更改了所有加密)
ALTER USER 'root'@'localhost' IDENTIFIED BY 'XXXX' PASSWORD EXPIRE NEVER;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'XXXX';
FLUSH PRIVILEGES;
ALTER USER 'root'@'192.168.0.0' IDENTIFIED BY 'XXXX' PASSWORD EXPIRE NEVER;
ALTER USER 'root'@'192.168.0.0' IDENTIFIED WITH mysql_native_password BY 'XXXX';
FLUSH PRIVILEGES;
ALTER USER 'root'@'127.0.0.1' IDENTIFIED BY 'XXXX' PASSWORD EXPIRE NEVER;
ALTER USER 'root'@'127.0.0.1' IDENTIFIED WITH mysql_native_password BY 'XXXX';
FLUSH PRIVILEGES;
ALTER USER 'root'@'%' IDENTIFIED BY 'XXXX' PASSWORD EXPIRE NEVER;
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'XXXX';
FLUSH PRIVILEGES;
如图：
*4.打通隧道(检查是否链接成功--公网默认是8066)*
*5.通过远程工具链接*
*本地链接*
*1.登录mysql数据库* *mysql -uroot -pXXX*
*2.查看*
执行：show databases;
use mysql
SELECT Host, User, plugin from user;
*3.修改root或者普通用户的加密方式*
执行修改命令根据你需要访问的host进行修改 (当前模拟是更改了所有加密)
ALTER USER 'root'@'localhost' IDENTIFIED BY 'XXXX' PASSWORD EXPIRE NEVER;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'XXXX';
FLUSH PRIVILEGES;
ALTER USER 'root'@'192.168.0.0' IDENTIFIED BY 'XXXX' PASSWORD EXPIRE NEVER;
ALTER USER 'root'@'192.168.0.0' IDENTIFIED WITH mysql_native_password BY 'XXXX';
FLUSH PRIVILEGES;
ALTER USER 'root'@'127.0.0.1' IDENTIFIED BY 'XXXX' PASSWORD EXPIRE NEVER;
ALTER USER 'root'@'127.0.0.1' IDENTIFIED WITH mysql_native_password BY 'XXXX';
FLUSH PRIVILEGES;
ALTER USER 'root'@'%' IDENTIFIED BY 'XXXX' PASSWORD EXPIRE NEVER;
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'XXXX';
FLUSH PRIVILEGES;
*4.打通隧道(本地打通隧道端口可以自定义 只要不冲突就可以)*
*5.登录本地安装的mysql客户端验证(客户端根据自己喜好放)*
*6.查看本地是否链接成功*
*7.通过远程工具链接*
*此模拟公有云 本地都正常链接*
