MySQL添加用户

shell> mysql -u root -p1234 mysql
mysql> insert into user(Host,User,Password) values ('localhost','_backmysql','databse');
添加一个来自本机的mysql 用户_backmysql,口令为：1234

#mysql –u root –p
mysql>;GRANT FILE ON *.* TO backup@192.168.1.200 IDENTIFIED BY ‘1234’;
mysql>;\exit
开放一个账号backup密码1234给来自IP:192.168.1.200有档案处理的权限

格式：grant 权限 on 数据库名.表名 用户@登录主机 identified by "用户密码";
mysql>;grant select,update,insert,delete on *.* to identified by "1234";