赋予其他用户远程连接自己数据库的权限
window+R,打开命令行窗口,连接mysql
mysql -uroot -p123456
执行命令:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
刷新:
flush privileges;
可以进行测试了
window+R,打开命令行窗口,连接mysql
mysql -uroot -p123456
执行命令:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
刷新:
flush privileges;
可以进行测试了