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
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