<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>

                ThinkChat2.0新版上線,更智能更精彩,支持會話、畫圖、視頻、閱讀、搜索等,送10W Token,即刻開啟你的AI之旅 廣告
                ### **?一.創建子賬號** 創建一個用戶名為test,密碼為123456的子賬號。 命令: ~~~ CREATE USER 'test'@'localhost' IDENTIFIED BY '123456'; #這種創建方式只能本地登錄 CREATE USER 'test'@'%' IDENTIFIED BY '123456'; #這種創建方式可以遠程登錄,即別的地方可以登錄 ~~~ ![](https://img.kancloud.cn/05/a8/05a8ccc215fa2ff489e316d3d8041a41_1143x233.png) ### **?二. 給子賬號添加權限** 添加權限第1步: "localhost"表示對本地主機授權,此時使用子賬號本地登錄擁有testDemo的操作權限,遠程登錄依然沒有testDemo的操作權限。 all privileges表示所有操作權限,也可以填寫部分權限,比如把all privileges改為create,update,delete,select等。 命令: ~~~ //賦予test子賬號對testDemo數據庫所有操作權限 grant all privileges on testDemo.* to "test"@"localhost" identified by "123456"; //如果不想賦予所有權限 //賦予test子賬號對testDemo數據庫select,update權限 grant select,update on testDemo.* to "test"@"localhost" identified by "123456"; //注意:mysql8.0之后賦予權限命令有變化,如下 grant all privileges on testDemo.* to 'test'@'localhost';//賦予權限后要刷新系統權限表,使配置生效 flush privileges; ~~~ ![](https://img.kancloud.cn/36/bd/36bd5bdf5e920cb8c8416a3b6e513611_961x171.png) 備注:也可能不是localhost表示本地,要去mysql.user表中查看(想了解更多mysql.user表的介紹,可以訪問: mysql.user表權限字段說明全介紹\_世俗的大尾巴也熊的博客-CSDN博客。 查詢語句為: ~~~ select host,user,grant_priv,Super_priv from mysql.user; ~~~ 添加權限第2步: “%” 表示對所有非本地主機授權,不包括localhost。此時使用子賬號遠程登錄對testDemo數據庫才有操作權限。 命令: ~~~ grant all privileges on testDemo.* to "test"@"%" identified by "123456"; flush privileges; #刷新系統權限表 ~~~ ![](https://img.kancloud.cn/dd/0d/dd0d559ea488cbac3c10d0eda002ec56_903x174.png)
                  <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>

                              哎呀哎呀视频在线观看