<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智能體構建引擎,智能編排和調試,一鍵部署,支持知識庫和私有化部署方案 廣告
                MariaDB數據庫管理系統是MySQL的一個分支,主要由開源社區在維護,采用GPL授權許可。 ## MariaDB服務 查詢MariaDB ``` yum info mariadb yum info mariadb-server ``` 安裝和配置MariaDB服務 ``` yum install mariadb-server -y systemctl start mariadb systemctl enable mariadb systemctl status mariadb mysql_secure_installation # Follow the instruction ... ... ``` 查詢socket statistics狀態(TCP 3306) ``` ss -antp | grep mysqld ``` 配置防火墻例外 ``` firewall-cmd --permanent --add-service=mysql firewall-cmd --reload firewall-cmd --list-services ``` ## 數據庫維護 基本操作 ``` mysql -u root -p create database myDB; show databases; grant all privileges on myDB.* to myDBowener@'%' identified by '123.com'; grant select on myDB.* to myDBread@'%' identified by '123.com'; flush privileges; show grants for myDBread; ``` 備份數據庫 ``` mkdir /backup mysqldump -uroot -p123.com myDB | gzip > /backup/myDB.sql.gz ls /backup ``` 恢復數據庫 ``` cd /backup gunzip myDB.sql.gz ls cat myDB.sql | mysql -uroot -p123.com myDB ``` 備份數據庫腳本 ``` #/bin/bash sub_folder=$(date +%Y%m%d) cd /backup mkdir $sub_folder backup_file=/backup/$sub_folder/myDB.sql.gz mysqldump -uroot -p123.com myDB | gzip > $backup_file ``` MariaDB 10.1數據庫連結問題(高版本) Host is not allowed to connect to this MariaDB server ``` UPDATE mysql.user SET plugin = 'mysql_native_password' WHERE user = 'root' AND host = 'localhost'; ```
                  <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>

                              哎呀哎呀视频在线观看