mysql设置远程连接
-- 选择MySQL数据库
USE mysql;
-- 查看当前用户的主机和用户名
SELECT host, user FROM user;
-- 修改root用户的认证模式和密码
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
-- 刷新权限
FLUSH PRIVILEGES;
-- 创建远程访问用户admin并设置密码
CREATE USER 'admin'@'%' IDENTIFIED BY '123456';
-- 赋予admin用户所有权限
GRANT ALL ON *.* TO 'admin'@'%';
-- 设置admin用户的认证模式和密码
ALTER USER 'admin'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
-- 刷新权限
FLUSH PRIVILEGES;