MySQL常用命令

创建用户

1
create user username identified by 'password';

授权

1
2
grant all privileges on dbname.* to username@'%' identified by 'password';
flush privileges;