#创建账户
create user 'root'@'%' identified by 'root';
#赋予权限
grant all privileges on *.* to 'root'@'%' with grant option;
#刷新
flush privileges;
#密码设置
set password for 'root'@'localhost'=password('root');
#创建账户
create user 'root'@'%' identified by 'root';
#赋予权限
grant all privileges on *.* to 'root'@'%' with grant option;
#刷新
flush privileges;
#密码设置
set password for 'root'@'localhost'=password('root');