mysql用户授权

1、创建与删除用户：
CREATE USER 'username'@'host' IDENTIFIED BY 'password';
DROP USER 'username'@'host'  //删除用户

'username':用户名 ('username'+'host'有唯一约束)
'host':指定用户可以在哪台机器上访问，“%”表示任意远程主机
'password':密码

例如：CREATE USER 'cobartest'@'%' IDENTIFIED BY '123456';
      DROP USER 'cobartest'@'%'

2、授权
GRANT privileges ON databasename.tablename TO 'username'@'host'
REVOKE privilege ON databasename.tablename FROM 'username'@'host'; //撤销

privileges：用户权限；ALL代表所以权限
databasename.tablename：数据表，databasename.*表示数据库的所以表，*.*所以数据库的所以表
'username'：用户名
'host':影响机器的ip

例如：GRANT ALL ON cobar_test.* TO 'cobartest'@'%'

MySQL中的操作权限：
ALTER Allows use of ALTER TABLE.
ALTER ROUTINE Alters or drops stored routines.
CREATE Allows use of CREATE TABLE.
CREATE ROUTINE Creates stored routines.
CREATE TEMPORARY TABLE Allows use of CREATE TEMPORARY TABLE.
CREATE USER Allows use of CREATE USER, DROP USER, RENAME USER, and REVOKE ALL PRIVILEGES.
CREATE VIEW Allows use of CREATE VIEW.
DELETE Allows use of DELETE.
DROP Allows use of DROP TABLE.
EXECUTE Allows the user to run stored routines.
FILE Allows use of SELECT... INTO OUTFILE and LOAD DATA INFILE.
INDEX Allows use of CREATE INDEX and DROP INDEX.
INSERT Allows use of INSERT.
LOCK TABLES Allows use of LOCK TABLES on tables for which the user also has SELECT privileges.
PROCESS Allows use of SHOW FULL PROCESSLIST.
RELOAD Allows use of FLUSH.
REPLICATION Allows the user to ask where slave or master
CLIENT servers are.
REPLICATION SLAVE Needed for replication slaves.
SELECT Allows use of SELECT.
SHOW DATABASES Allows use of SHOW DATABASES.
SHOW VIEW Allows use of SHOW CREATE VIEW.
SHUTDOWN Allows use of mysqladmin shutdown.
SUPER Allows use of CHANGE MASTER, KILL, PURGE MASTER LOGS, and SET GLOBAL SQL statements. Allows mysqladmin debug command. Allows one extra connection to

be made if maximum connections are reached.
UPDATE Allows use of UPDATE.
USAGE Allows connection without any specific privileges.