<ruby id="bdb3f"></ruby>

    <p id="bdb3f"><cite id="bdb3f"></cite></p>

      <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
        <p id="bdb3f"><cite id="bdb3f"></cite></p>

          <pre id="bdb3f"></pre>
          <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

          <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
          <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

          <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                <ruby id="bdb3f"></ruby>

                企業??AI智能體構建引擎,智能編排和調試,一鍵部署,支持知識庫和私有化部署方案 廣告
                #### 授權格式: ~~~ GRANT <privileges> ON <dbName.tableName> ?TO <user> [IDENTIFIED BY "<password>"] [WITH GRANT OPTION]; ~~~ #### 授權參數講解: **privilegesCode**表示授予的權限類型,常用的有以下幾種類型: * all privileges:所有權限。 * select:讀取權限。 * delete:刪除權限。 * update:更新權限。 * create:創建權限。 * drop:刪除數據庫、數據表權限。 **dbName.tableName**表示授予權限的具體庫或表,常用的有以下幾種選項: * ~~~ *.*:授予該數據庫服務器所有數據庫的權限。 ~~~ * dbName.\*:授予dbName數據庫所有表的權限。 * dbName.dbTable:授予數據庫dbName中dbTable表的權限。 `username@host`表示授予的用戶以及允許該用戶登錄的IP地址。其中Host有以下幾種類型: * **localhost:**只允許該用戶在本地登錄,不能遠程登錄。 * **%:**允許在除本機之外的任何一臺機器遠程登錄。 * **192.168.52.32:**具體的IP表示只允許該用戶從特定IP登錄。 **password**指定該用戶登錄時的面。 **flush privileges**表示刷新權限變更。 #### 1、查看所有用戶以及授權主機 ~~~ mysql> select User,Host from mysql.user; +--------+-----------+ | User ? | Host ? ? | +--------+-----------+ | user2 | % ? ? ? ? | | zabbix | % ? ? ? ? | | root ? | localhost | +--------+-----------+ 5 rows in set (0.00 sec) ~~~ #### 2、查看某個用戶的授權情況 ~~~ mysql> show grants for 'root'@'localhost'; +---------------------------------------------------------------------+ | Grants for root@localhost ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? | +---------------------------------------------------------------------+ | GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION | | GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION ? ? ? | +---------------------------------------------------------------------+ 2 rows in set (0.00 sec) ~~~ 或者 ~~~ mysql> show grants for 'zabbix'@'%'; +------------------------------------+ | Grants for zabbix@% ? ? ? ? ? ? ? | +------------------------------------+ | GRANT USAGE ON *.* TO 'zabbix'@'%' | +------------------------------------+ 1 row in set (0.00 sec) ~~~ #### 3、授權 * 授權所有權限 ~~~ GRANT ALL PRIVILEGES ON *.* TO 'user'@'%' IDENTIFIED BY 'passwd' WITH GRANT OPTION; ~~~ * 授權單個gogs庫權限 ~~~ GRANT ALL PRIVILEGES ON gogs.* TO 'user2'@'%' IDENTIFIED BY 'passwd2'; ~~~ * 授權單個user表權限 ~~~ GRANT ALL PRIVILEGES ON gogs.user TO 'user2'@'%' IDENTIFIED BY 'passwd2' WITH GRANT OPTION; ~~~ * 單獨授權增刪改查權限,而不是所有權限 ~~~ grant select, insert, update, delete on gogs.* to user@'%'; ~~~ * 授權某個固定主機權限 ~~~ grant select, insert, update, delete on gogs.* to user@'172.16.3.200'; ~~~ #### 4、取消授權 ~~~ revoke ALL PRIVILEGES ON *.* from 'user'@'%'; flush privileges; ~~~ #### 5、刪除用戶 ~~~ drop user user@"%"; ~~~
                  <ruby id="bdb3f"></ruby>

                  <p id="bdb3f"><cite id="bdb3f"></cite></p>

                    <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
                      <p id="bdb3f"><cite id="bdb3f"></cite></p>

                        <pre id="bdb3f"></pre>
                        <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

                        <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
                        <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

                        <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                              <ruby id="bdb3f"></ruby>

                              哎呀哎呀视频在线观看