Mysql 8.0之前的版本:
grant all privileges on *.* to 'root'@'%' identified by '密码' with grant option;
Mysql 8.0以后的版本:
CREATE USER 'root'@'%' IDENTIFIED BY '密码';
GRANT ALL ON *.* TO 'root'@'%';
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '密码';
刷新权限:
FLUSH PRIVILEGES;