MySql添加全权限帐号

mysql -uroot -pword;   // 管理员帐号登陆，root帐号，word密码

mysql> GRANT ALL ON *.* TO 'user1'@localhost IDENTIFIED BY 'password'; //user1帐号，password密码