在虚拟机上面进入到mysql以后:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
上面这个语句是给用户root密码为123456的用户授权
然后在刷新一下权限,不用重启:
flush privileges;
在虚拟机上面进入到mysql以后:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
上面这个语句是给用户root密码为123456的用户授权
然后在刷新一下权限,不用重启:
flush privileges;