1.创建远程用户
CREATE USER 'user'@'%' IDENTIFIED BY 'password';
2.授root权限
GRANT ALL privileges ON *.* TO 'user'@'%';
3.刷新权限
flush privileges;
4.设置root密码
set password for username@localhost = password('password');
1.创建远程用户
CREATE USER 'user'@'%' IDENTIFIED BY 'password';
2.授root权限
GRANT ALL privileges ON *.* TO 'user'@'%';
3.刷新权限
flush privileges;
4.设置root密码
set password for username@localhost = password('password');
本文标题:MySQL
本文链接:https://www.haomeiwen.com/subject/tpsevxtx.html
网友评论