注意,新版的mysql数据库下的user表中已经没有Password字段了, 而是将加密后的用户密码存储于authentication_string字段
create user username;
update user set authentication_string=password("pwd") where user="username";
grant all on dbname.* to 'username'@'%';
注意,新版的mysql数据库下的user表中已经没有Password字段了, 而是将加密后的用户密码存储于authentication_string字段
create user username;
update user set authentication_string=password("pwd") where user="username";
grant all on dbname.* to 'username'@'%';