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

                ThinkChat2.0新版上線,更智能更精彩,支持會話、畫圖、視頻、閱讀、搜索等,送10W Token,即刻開啟你的AI之旅 廣告
                查看用戶列表 ``` select host,user from mysql.user; ``` 刪除用戶 ``` delete from user where user='jiangguowu' and host='%'; ``` 刷新權限 ``` flush privileges; ``` 主服務器數據庫打開二進制日志 ``` log-bin=mysql-bin ``` 創建用戶 create user jiangguowu@'%' identified by 'jiangguowu'; 賦予復制權限 grant replication slave on *.* to jiangguowu@'%' identified by 'jiangguowu'; GRANT ALL PRIVILEGES ON \*.\* TO 'root'@'%' IDENTIFIED BY '123456' grant all privileges on *.* to 'jiangguowu'@'%' identified by 'jiangguowu'; 刷新權限 flush privileges; 從服務器數據庫 修改server-id 日志可以不用打開 如果是說雙主備份(主主) 可以打開 查看狀態 show master status\G; 停止復制從庫線程 stop slave; 設置復制二進制文件的權限及位置 change master to master_host='192.168.31.111', master_user='jiangguowu', master_password='jiangguowu', master_log_file='mysql-bin.000007', master_log_pos=1005; 開啟復制線程 start slave; 在主庫中創建數據表; 創建數據庫 create database art; 使用數據庫 use art; 創建數據表 create table person(id int not null primary key,name varchar(20) not null); 查看數據表 show tables; 在從庫中查看是否也會創建表 如果創建了 則mysql主從復制算是基本搭建完成 show tables; 在主庫中測試curd,在從庫中查看是否一致 查詢 select * from person; 插入 insert into person(id,name) values(1,'張三'),(2,'李四'); 修改 update person set name='王五' where id = 1; 刪除 delete from person where id =2; 測試完成 主從搭建成功咯~ 取消從數據庫 ``` stop slave reset slave change master to master_host=' '; ```
                  <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>

                              哎呀哎呀视频在线观看