mysql 创建用户远程连接

GRANT ALL PRIVILEGES ON *.* TO ‘myuser‘@‘%‘IDENTIFIED BY ‘mypassword‘ WITH GRANT OPTION; 
  如果是固定ip就这么写
 grant all privileges on *.* to ‘root‘@‘192.168.0.49‘identified by ‘123‘ with grant option;

//推送设置到内存或重启服务器也行
　　mysql>FLUSH PRIVILEGES 

mysql 创建用户远程连接

标签：创建用户   固定   with   pre   use   roo   固定ip   用户   root