mysql 用户 权限

1、创建用户：

     首先 进入mysql 用户库当中

       mysql> insert into mysql.user(Host,User,Password) values("localhost","test",password("1234"));

 

2、添加权限 grant all on *.* to 'aaa'@'%' identified by '密码' with grant option ;
flush privileges;

/usr/local/mysql/bin/mysql -uroot -p${MySQLPassword} -e "grant all on \`${MySQLDBNamePrefix}${ServerID}\`.* to '${AppDBUserPrefix}${ServerID}'@'127.0.0.1' identified by '${AppDBPassPrefix}${ServerID}';"