想myuser使用mypassword从任何主机连接到mysql服务器
1.授权语句
GRANT ALL PRIVILEGES ON . TO ‘myuser’@’%’ IDENTIFIED BY ‘mypassword’ WITH GRANT OPTION;
2.使修改生效
FLUSH PRIVILEGES;
想myuser使用mypassword从任何主机连接到mysql服务器
1.授权语句
GRANT ALL PRIVILEGES ON . TO ‘myuser’@’%’ IDENTIFIED BY ‘mypassword’ WITH GRANT OPTION;
2.使修改生效
FLUSH PRIVILEGES;