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
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
