(1) 设置:user = root, password = 5200。运行”cmd”,输入:mysql -u root -p 进入。
(2) 解决:Navicat Premium 12连接MySQL 8.0.15.0 出现错误:Authentication plugin 'caching_sha2_password' cannot be loaded:
#登陆MySQL
mysql -u root -p
#使密码从不失效
ALTER USER 'root'@'localhost' IDENTIFIED BY '5200' PASSWORD EXPIRE NEVER;
#修改加密规则
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '5200';
#刷新权限
FLUSH PRIVILEGES;
#重置下密码
alter user 'root'@'localhost' identified by '5200';
(3) 远程连接访问:(在同一个局域网/网段内)
e.g. MySQL服务主机:IP地址 192.168.1.140,访问主机:IP地址 192.168.1.139
① 在服务主机上:
#创建用户
CREATE USER 'new'@'%' IDENTIFIED BY '1234';
#授予权限
GRANT ALL PRIVILEGES ON *.* TO 'new'@'%' WITH GRANT OPTION;
#修改加密规则
ALTER USER 'new'@'%' IDENTIFIED WITH mysql_native_password BY '1234';
# 刷新权限
FLUSH PRIVILEGES;
② 在访问主机上:(通过Navicat Premium 12连接)
新建MySQL连接:
连接名:new(自定义),主机:192.168.1.140,端口:3306,用户名:new,密码:1234