1丛肮、添加用戶(3步操作)
create user "username"@"host" identified by "password";
- username： 用戶名
- host: 指定host呈野，% 代表任何主機(jī)均能遠(yuǎn)程訪問敏储， localhost代表只能本地登錄塑崖，
92.168.0.100代表只能再指定的主機(jī)上登錄- password: 用戶密碼
grant all privileges on database_name.table_name to username;
- all privileges: 代表所有權(quán)限洗显，可以指定某一個(gè)權(quán)限爬橡，
- database_name.table_name: 指定數(shù)據(jù)庫和指定表忘闻，
database_name.*代表指定庫中所有的表,*.*代表所有的庫和表- username: 給該用戶賦予權(quán)限
- 如下demo:
grant create,select,insert,update,delete,drop on test_db.test_table to bingo
向bingo用戶賦予對(duì)test_db庫中的test_table表create等權(quán)限
flush privileges;
刷新權(quán)限莉擒， 之前賦予的權(quán)限才能生效
create user "bingo"@"%" identified by "12345";
grant all privileges on *.* to bingo;
flush privileges;
效果如下：
mysql> create user "bingo"@"%" identified by "12345";
Query OK, 0 rows affected (0.00 sec)
mysql> grant all privileges on *.* to bingo;
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> select user, host from mysql.user;
+------------------+-----------+
| user | host |
+------------------+-----------+
| bingo | % |
| debian-sys-maint | localhost |
| mysql.session | localhost |
| mysql.sys | localhost |
| root | localhost |
+------------------+-----------+
5 rows in set (0.00 sec)
2酿炸、刪除用戶
drop user "username"@"host";
mysql> select user, host from mysql.user;
+------------------+-----------+
| user | host |
+------------------+-----------+
| bingo | % |
| bingo1 | % |
| debian-sys-maint | localhost |
| mysql.session | localhost |
| mysql.sys | localhost |
| root | localhost |
+------------------+-----------+
6 rows in set (0.00 sec)
mysql> drop user "bingo1"@"%";
Query OK, 0 rows affected (0.00 sec)
mysql> select user, host from mysql.user;
+------------------+-----------+
| user | host |
+------------------+-----------+
| bingo | % |
| debian-sys-maint | localhost |
| mysql.session | localhost |
| mysql.sys | localhost |
| root | localhost |
+------------------+-----------+
5 rows in set (0.00 sec)
3、修改用戶相關(guān)
修改用戶名： rename user "bingo"@"%" to "bingo1"@"%";
修改密碼：set password for "bingo1"@"%" = password("123456")
??????????????????alter user "root"@"%" identified by "root1";(針對(duì)8.0以上版本)
??????????????????mysqladmin -uroot -proot password root1(或者使用mysqladmin)
撤銷用戶權(quán)限：revoke all privileges on *.* from "bingo1"@"%";
查看用戶權(quán)限：show grants for "bingo1"@"%";
mysql> show grants for "bingo1"@"%";
+------------------------------------+
| Grants for bingo1@% |
+------------------------------------+
| GRANT USAGE ON *.* TO 'bingo1'@'%' |
+------------------------------------+
1 row in set (0.00 sec)
