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

                ## [Navicat for Mysql連接mysql數據庫時出現 2003-Can't connect to MySql server on 'localhost'(10061)] ## 一、環境:linux服務器下 ## 二、問題:在windows7下使用Navicat for Mysql連接mysql數據庫時出現 2003-Can't connect to MySql server on 'localhost'(10061) ## 三、解決步驟: ### (1)查看哪些端口被打開 netstat -anp ![](https://img.kancloud.cn/ab/c6/abc6cecbf49180273a44e300b48d39aa_771x134.png) 127.0.0.1:3306 -- 指mysql數據庫僅能在本地下訪問; ### (2)我們把127.0.0.1:3306改為0.0.0.0:3306,這樣才能讓所有用戶可以遠程訪問mysql數據庫; 打開`/etc/mysql/mysql.cnf`?找到`bind-address= 127.0.0.1`?把它改成?`bind-address= 0.0.0.0` (mysql5.7.24版本,配置文件目錄是:/etc/mysql/mysql.conf.d/mysqld.cnf) ![](https://img.kancloud.cn/07/74/0774b8bc6138014fcb6f7c43e2697e58_664x106.png) 重啟生效; 命令:service mysql restart ### (3)執行第二步后測試連接mysql,仍然會報錯:“1130 is not allowed to connect to this MySql server”。這是因為沒有開啟權限。 在linux服務器下執行: 1.`mysql -u root -p`回車,輸入密碼回車,登錄; 2.授權遠程用戶登錄   1.對所有?`root`?用戶授權:   GRANT ALL PRIVILEGES ON \*.\* TO 'root'@'%' IDENTIFIED BY 'root用戶密碼' WITH GRANT OPTION;   2.對指定 IP 的?`root`?用戶授權:   GRANT ALL PRIVILEGES ON \*.\* TO root@'指定的IP地址' IDENTIFIED BY 'root用戶密碼' WITH GRANT OPTION;   3.也可以授權指定的表,這就不搞的那么麻煩了,反正本地自己用。 3.重載授權表:`FLUSH PRIVILEGES;` 4.`exit`?退出 Mysql ### (4)測試連接,連接成功。
                  <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>

                              哎呀哎呀视频在线观看