mysql中all privileges包含哪些权限
mysql> grant all privileges on test.* to 'ybb'@'%' identified by 'ybb';mysql> select host,user,password from mysql.user where user='ybb' and host='%';| GRANT ALL PRIVILEGES ON `test`.* TO 'ybb'@'%' |. | GRANT SELECT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER ON `test`.* TO 'ybb'@'%' | 阅读全文