mysql 添加用户

GRANT Select, Insert, Update, Delete, Index, Alter, Create, Drop, References ON test.* TO 'peter'@'%' IDENTIFIED BY '111111'

 UPDATE  user SET Password = OLD_PASSWORD('111111')
 WHERE   User = 'peter';

FLUSH PRIVILEGES