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

                ??一站式輕松地調用各大LLM模型接口,支持GPT4、智譜、豆包、星火、月之暗面及文生圖、文生視頻 廣告
                ## 1.前提 * 此安裝方法的前提是,鏈接互聯網 ## 2.安裝mysql * 更新源 ``` sudo apt-get update ``` * 安裝MySQL-client-core-5.6 ``` sudo apt-get install MySQL-client-core-5.6 ``` * 安裝mysql-client-5.6 ``` sudo apt-get install mysql-client-5.6 ``` * 安裝mysql-server-5.6 ``` sudo apt-get install mysql-server-5.6 ``` ## 3.檢查mysql狀態 > 執行完成上面的命令之后,正常情況mysql服務會自啟動 * 檢查mysql的啟動狀態 ``` ## 查看進程 ps -ef | grep mysql ## 查看端口監聽 netstat -tap | grep mysql ``` * 鏈接mysql進行狀態檢查 ``` mysql -h localhost -u root -p Enter password: mysql> status; -------------- mysql Ver 14.14 Distrib 5.6.33, for debian-linux-gnu (x86_64) using EditLine wrapper Connection id: 37 Current database: Current user: root@localhost SSL: Not in use Current pager: stdout Using outfile: '' Using delimiter: ; Server version: 5.6.33-0ubuntu0.14.04.1 (Ubuntu) Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: latin1 Db characterset: latin1 Client characterset: utf8 Conn. characterset: utf8 UNIX socket: /var/run/mysqld/mysqld.sock Uptime: 25 min 27 sec Threads: 1 Questions: 115 Slow queries: 0 Opens: 87 Flush tables: 1 Open tables: 80 Queries per second avg: 0.075 -------------- ``` ## 4.修改必要的配置 sudo vim /etc/mysql/my.cnf * 修改遠程訪問 ``` # 為了可以遠程訪問,將[mysqld]下面的這行注釋掉 # Instead of skip-networking the default is now to listen only on # localhost which is more compatible and is not less secure. # bind-address = 127.0.0.1 ``` * 修改字符編碼,在client,mysqld,mysql配置段,分別追加如下編碼信息 ``` [client] default-character-set = utf8 [mysqld] character-set-server=utf8 lower_case_table_names = 1 [mysql] default-character-set=utf8 ``` 再次查看status,變為utf8編碼 ``` Server characterset: utf8 Db characterset: utf8 Client characterset: utf8 Conn. characterset: utf8 ``` * 新建數據庫和用戶 ``` create database `devicedb` default character set utf8 collate utf8_general_ci; CREATE USER 'device'@'%' IDENTIFIED BY '4rfv$RFV'; GRANT ALL ON devicedb.* TO 'device'@'%' IDENTIFIED BY '4rfv$RFV'; //只有執行了這一句才可以登陸 FLUSH PRIVILEGES; ``` ## 5.卸載舊版本 ``` #停止mysql的服務 sudo service mysql stop #刪除mysql的數據文件(必要的情況下) sudo rm /var/lib/mysql/ -R #刪除mqsql的配置文件 sudo rm /etc/mysql/ -R #刪除mysql軟件 sudo apt-get autoremove mysql* --purge ```
                  <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>

                              哎呀哎呀视频在线观看