会报错的写法:之前版本是没问题的,但是8.0mysql会报语法错误
创建用户、设置密码并且赋权
grant all privileges on . to ‘myuser’@’%’ identified by ‘mypassword’ with grant option;
mysql8.0中必须分开,先创建用户、再给用户赋值
CREATE USER ‘myuser’@’%’ IDENTIFIED BY ‘mypassword’;
grant all privileges on . to ‘myuser’@’%’ ;
FLUSH PRIVILEGES;