<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智能體構建引擎,智能編排和調試,一鍵部署,支持知識庫和私有化部署方案 廣告
                (1)TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 解決方法:在 vi /etc/my.cnf 文件中加上 : explicit_defaults_for_timestamp=true 。保存后再次啟動就可以了。 (2)windows下啟動多個mysql服務 1、下載mysql免安裝版,在D,E盤分別復制一份解壓 2、進入解壓的mysql目錄,自己下載的MySQL-server-5.5,進入MySQL-server-5.5目錄,打開my.ini配置文件,在配置文件中找到如下配置項進行更改: D 盤下的MySQL-server: [client] port=3306 The TCP/IP Port the MySQL Server will listen on port=3306 #Path to installation directory. All paths are usually resolved relative to this. basedir="D:\MySQL-Server-5.5" #Path to the database root datadir="D:\MySQL-Server-5.5\data" E 盤下的MySQL-server: [client] port=3307 The TCP/IP Port the MySQL Server will listen on port=3307 #Path to installation directory. All paths are usually resolved relative to this. basedir="E:\MySQL-Server-5.5" #Path to the database root datadir="E:\MySQL-Server-5.5\data" (port端口默認為3306,可以保持一個mysql服務為默認端口,如 D 盤中的 mysql 配置文件中port 配置項不進行修改,只修改 E 盤中的 port 配置(但 basedir 和 datadir這兩項都必須修改成相應目錄下的路徑,如:D 盤修改為:basedir="D:\MySQL-Server-5.5"和datadir="D:\MySQL-Server-5.5\data") 3、打開 cmd 命令界面,分別使用命令進入對應mysql目錄, 如進入 D:\MySQL-server-5.5\bin 輸入命令: mysqld -install mysql3307 --defaults-file="F:\mysql3307\my.ini" 提示:Service successfully installed. 表示服務已經安裝成功 如進入 E:\MySQL-server-5.5\bin 目錄,輸入命令: mysqld -install mysql3307 --defaults-file="D:\SOFT_PHP_PACKAGE\mysql3307\my.ini" 提示:Service successfully installed. 表示服務已經安裝成功 4、打開“運行” 輸入“regedit” 打開注冊表,依次展開HKEY_LOCAL_MACHINE--->SYSTEM--->CurrentControlSet--->services,找到上面安裝的MySQL 和 MySQL2 服務,修改參數 ImagePath值, MySQL修改為:D:\MySQL-Server-5.5\bin\mysqld --defaults-file=D:\MySQL-Server-5.5\my.ini MySQL MySQL2修改為:E:\MySQL-Server-5.5\bin\mysqld --defaults-file=E:\MySQL-Server-5.5\my.ini MySQL2 5、啟動服務,可以在 cmd 界面輸入命令:net start MySQL 來啟動 MySQL 服務,也可以在 “運行” 里面輸入 “services.msc” 打開服務面板,找到 MySQL 右擊啟動 6,此時登入MySQL是會報錯 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) 嘗試修改root用戶密碼 打開my.ini,找到[mysqld],在下面添加 skip-grant-tables 此時使用root賬號,密碼處按回車即可登錄 然后修改密碼: UPDATE user SET Password=PASSWORD('123456') where USER='root'; mysql> FLUSH PRIVILEGES; 或者進入 E:\MySQL-server-5.5\bin 目錄 執行mysqladmin -u root password 123456 (3) Change Master to Master_host='localhost', Master_port=3306, Master_user='root', Master_Password='123456';
                  <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>

                              哎呀哎呀视频在线观看