MySQL 5.7的角色功能：

創(chuàng)新互聯(lián)主要從事成都網(wǎng)站建設(shè)、網(wǎng)站建設(shè)、網(wǎng)頁(yè)設(shè)計(jì)、企業(yè)做網(wǎng)站、公司建網(wǎng)站等業(yè)務(wù)。立足成都服務(wù)東烏珠穆沁,十年網(wǎng)站建設(shè)經(jīng)驗(yàn),價(jià)格優(yōu)惠、服務(wù)專業(yè),歡迎來(lái)電咨詢建站服務(wù):18980820575

創(chuàng)建用戶并授予用戶角色功能：

mysql> create user 'junior'@'127.0.0.1' identified by '123';

Query OK, 0 rows affected (0.01 sec)

mysql> create user 'tom'@'127.0.0.1' identified by '123';

Query OK, 0 rows affected (0.00 sec)

mysql> create user 'jim'@'127.0.0.1' identified by '123';

Query OK, 0 rows affected (0.01 sec)

mysql> grant proxy on 'junior'@'127.0.0.1' to 'tom'@'127.0.0.1';

Query OK, 0 rows affected (0.01 sec)

mysql> grant proxy on 'junior'@'127.0.0.1' to 'jim'@'127.0.0.1';

Query OK, 0 rows affected (0.00 sec)

mysql> grant select on *.* to 'junior'@'127.0.0.1';

Query OK, 0 rows affected (0.00 sec)

mysql> show grants for 'junior'@'127.0.0.1';

+---------------------------------------------+

| Grants for junior@127.0.0.1                 |

+---------------------------------------------+

| GRANT SELECT ON *.* TO 'junior'@'127.0.0.1' |

+---------------------------------------------+

1 row in set (0.00 sec)

mysql> show grants for 'jim'@'127.0.0.1';

+----------------------------------------------------------+

| Grants for jim@127.0.0.1                                 |

+----------------------------------------------------------+

| GRANT USAGE ON *.* TO 'jim'@'127.0.0.1'                  |

| GRANT PROXY ON 'junior'@'127.0.0.1' TO 'jim'@'127.0.0.1' |

+----------------------------------------------------------+

2 rows in set (0.00 sec)

mysql> show grants for 'tom'@'127.0.0.1';

+----------------------------------------------------------+

| Grants for tom@127.0.0.1                                 |

+----------------------------------------------------------+

| GRANT USAGE ON *.* TO 'tom'@'127.0.0.1'                  |

| GRANT PROXY ON 'junior'@'127.0.0.1' TO 'tom'@'127.0.0.1' |

+----------------------------------------------------------+

2 rows in set (0.00 sec)

mysql> use mysql;

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

mysql> select * from proxies_priv;

+-----------+------+--------------+--------------+------------+----------------------+---------------------+

| Host      | User | Proxied_host | Proxied_user | With_grant | Grantor              | Timestamp           |

+-----------+------+--------------+--------------+------------+----------------------+---------------------+

| localhost | root |              |              |          1 | boot@connecting host | 0000-00-00 00:00:00 |

| 127.0.0.1 | tom  | 127.0.0.1    | junior       |          0 | root@localhost       | 0000-00-00 00:00:00 |

| 127.0.0.1 | jim  | 127.0.0.1    | junior       |          0 | root@localhost       | 0000-00-00 00:00:00 |

+-----------+------+--------------+--------------+------------+----------------------+---------------------+

3 rows in set (0.00 sec)

網(wǎng)頁(yè)標(biāo)題：MySQL5.7的角色功能
URL地址：http://jinyejixie.com/article38/pdchsp.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供商城網(wǎng)站、品牌網(wǎng)站建設(shè)、服務(wù)器托管、品牌網(wǎng)站設(shè)計(jì)、移動(dòng)網(wǎng)站建設(shè)、定制網(wǎng)站

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來(lái)源： 創(chuàng)新互聯(lián)