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

                合規國際互聯網加速 OSASE為企業客戶提供高速穩定SD-WAN國際加速解決方案。 廣告
                centos7安裝MySQL8步驟如下: **1. 官網下載對應的MySQL8** https://downloads.mysql.com/archives/community/ ![](https://img.kancloud.cn/b3/f1/b3f1a9c8a689d0f367e4e2deffbde175_1822x571.png) **2. 卸載centos7自帶的mariadb數據庫** ```shell (1)查看是否存在mariadb # rpm -qa | grep mariadb mariadb-libs-5.5.35-3.el7.x86_64 (2)卸載mariadb # rpm -e mariadb-libs-5.5.35-3.el7.x86_64 --nodeps ``` **3. 上傳到Linux上并解壓** ```shell # tar -xvf mysql-8.0.18-1.el7.x86_64.rpm-bundle.tar -C mysql8/ --解壓完成后有如下文件 -rw-r--r--. 1 7155 31415 40104640 Sep 23 2019 mysql-community-client-8.0.18-1.el7.x86_64.rpm -rw-r--r--. 1 7155 31415 611436 Sep 23 2019 mysql-community-common-8.0.18-1.el7.x86_64.rpm -rw-r--r--. 1 7155 31415 6915400 Sep 23 2019 mysql-community-devel-8.0.18-1.el7.x86_64.rpm -rw-r--r--. 1 7155 31415 23683600 Sep 23 2019 mysql-community-embedded-compat-8.0.18-1.el7.x86_64.rpm -rw-r--r--. 1 7155 31415 3877664 Sep 23 2019 mysql-community-libs-8.0.18-1.el7.x86_64.rpm -rw-r--r--. 1 7155 31415 1363968 Sep 23 2019 mysql-community-libs-compat-8.0.18-1.el7.x86_64.rpm -rw-r--r--. 1 7155 31415 450282440 Sep 23 2019 mysql-community-server-8.0.18-1.el7.x86_64.rpm -rw-r--r--. 1 7155 31415 158001648 Sep 23 2019 mysql-community-test-8.0.18-1.el7.x86_64.rpm ``` **4. 安裝MySQL8** ```shell --下面這4個文件是必須安裝的,其他是可選的 # rpm -ivh mysql-community-common-8.0.18-1.el7.x86_64.rpm --nodeps --force # rpm -ivh mysql-community-libs-8.0.18-1.el7.x86_64.rpm --nodeps --force # rpm -ivh mysql-community-client-8.0.18-1.el7.x86_64.rpm --nodeps --force # rpm -ivh mysql-community-server-8.0.18-1.el7.x86_64.rpm --nodeps --force --查看已安裝資源 # rpm -qa | grep mysql mysql-community-libs-8.0.18-1.el7.x86_64 mysql-community-server-8.0.18-1.el7.x86_64 mysql-community-common-8.0.18-1.el7.x86_64 mysql-community-client-8.0.18-1.el7.x86_64 ``` **5. MySQL初始化** ```shell (1)初始化 # mysqld --initialize (2)賦予mysql操作 /var/lib/mysql 目錄的權限 --MySQL8核心配置文件默認在 /etc/my.cnf,默認數據存儲在 /var/lib/mysql # chown mysql:mysql -R /var/lib/mysql (3)啟動MySQL # systemctl start mysqld (4)查看MySQL是否已經啟動 # systemctl status mysqld mysqld.service - MySQL Server Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled) Active: activating (start) since Wed 2021-09-29 17:06:36 CST; 1min 44s ago (5)設置MySQL開機自啟 # systemctl enable mysqld ``` **6. 設置數據庫密碼** ```shell (1)查看初始密碼 # cat /var/log/mysqld.log | grep password ... for root@localhost: M&npo4JrX9g!(類似這個就是初始密碼) (2)登錄mysql # mysql -u root -p (3)設置mysql登錄密碼 mysql> alter USER 'root'@'localhost' IDENTIFIED BY '你的密碼'; (4)退出mysql mysql> exit; (5)重啟mysql # systemctl restart mysqld ``` **7. 允許遠程訪問** ``` (1)允許所有主機遠程訪問數據庫 mysql> use mysql; --root為用戶,%表示允許所有的主機遠程訪問root用戶這個數據庫 mysql> create user 'root'@'%' identified with mysql_native_password by 'abc@hPMq'; mysql> grant all privileges on *.* to 'root'@'%' with grant option; (2)更改加密規則 --mysql8之前加密規則為:mysql_native_password --mysql8之后默認加密規則為:caching_sha2_password --所以第三方工具訪問mysql8要么升級工具的mysql驅動包,要么使用mysql_native_password加密規則 mysql> alter user 'root'@'%' identified with mysql_native_password by 'abc@hPMq'; (3)刷新一下 mysql> flush privileges; ``` **8. 關閉防火墻** ```shell (1)查看防火墻是否開啟,runing為開啟 # firewall-cmd --state running (2)關閉防火墻 # systemctl stop firewalld.service (3)禁止防火墻開機自啟 # systemctl disable firewalld.service (4)關閉selinux # vim /etc/selinux/config --將SELINUX=enforcing 改為 SELINUX=disabled SELINUX=disabled ``` **9. 我使用SQLyog成功訪問到了數據庫** ![](https://img.kancloud.cn/7e/03/7e03f17943e69b75105a4edf5c5edce9_1334x550.png) **10. 安裝完畢!**
                  <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>

                              哎呀哎呀视频在线观看