mysql 添加用户，并对数据库授权

use mysql;

insert into user(host, user,password) values('%','myusername',password('myusername'));

create database `mydatabase`;

grant all privileges on `mydatabase`.* to myusername@'%';

delete from user where host='localhost' and user='myusername';

flush privileges;