docker pull mysql:5.7 sudo docker run --name mysql-master4 -p 3328:3306 -v /home/tom/0903/master:/etc/mysql/mysql.conf.d -e MYSQL_ROOT_PASSWORD=123456 -d mysql:5.7 sudo docker run --name mysql-slave1 -p 3329:3306 -v /home/tom/0903/slave1:/etc/mysql/mysql.conf.d -e MYSQL_ROOT_PASSWORD=123456 -d mysql:5.7 //进入mysql容器 docker exec -it mysql-master /bin/bash //登陆mysql mysql -u root -p123456 //修改root可以通过任何客户端连接 ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456'; //退出 exit //重启mysql docker restart mysql-master change master to master_host='192.168.145.130', master_port=3328, master_user='root', master_password='123456', master_log_file='mysql-bin.000003', master_log_pos=154; //启动从库引擎 start slave; show slave status G; //config [mysqld] port=3306 pid-file =/var/run/mysqld/mysqld.pid socket =/var/run/mysqld/mysqld.sock basedir=/usr/local/mysql datadir =/usr/local/mysql/data max_connections=200 max_connect_errors=10 character-set-server = UTF8MB4 default-storage-engine=INNODB #从库用MyISAM default_authentication_plugin=mysql_native_password symbolic-links=0 log-bin=mysql-bin server-id=2 [mysql] default-character-set=utf8mb4 [client] port=3306 default-character-set=utf8mb4
//进入docker中的mysql
docker exec -it mysql01 /bin/bash #执行docker容器的mysql,这里容器名是mysql01
之后就可以进入MySQL容器,mysql也可以用了
mysql -u root -p #进入容器名为mysql01的mysql
//创建表 create table 'Student'('name' varchar(30),'age' bigint(20) );