一、登录mysql
登录你的mysql
mysql -hlocalhost -uroot -p
如果出现如下,需配置系统环境PATH,mysql的环境的bin目录(如:C:\Program Files\MySQL\MySQL Server 5.6\bin)
二、执行命令
5.7及以前
#输入你的密码,放开全部 mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'yourpassword' WITH GRANT OPTION; #刷新一下 FLUSH PRIVILEGES;
8.0
-- 创建用户 CREATE USER 'root'@'%' IDENTIFIED BY 'root'; -- 授权 grant all privileges on *.* to 'root'@'%' ;
如果报错:ERROR 1819 (HY000): Your password does not satisfy the current policy requirements;
密码太简单了,可以试试:
CREATE USER 'root'@'%' IDENTIFIED BY 'AN8JvQhKzdgCTTg'; -- 授权 grant all privileges on *.* to 'root'@'%' ;
三、刷新权限
FLUSH PRIVILEGES;