zhangenter的专栏

LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE ‘file_name’[REPLACE | IGNORE]INTO TABLE tbl_name[PARTITION (partition_name,…)][CHARACTER SET charset_name][{FIELDS | COLUMNS}[TERMINATED BY ...

拉取镜像docker pull phpmyadmin/phpmyadmin运行docker单个mysql主机docker run --name myadmin -d -e PMA_HOST=dbhost -p 8080:80 phpmyadmin/phpmyadmin多个mysql主机docker run --name myadmin -d -e PMA_HOSTS=dbhost1...

centoswget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpmyum -y install mysql57-community-release-el7-10.noarch.rpmyum -y install mysql-community-server修改默认编码charac...

假设：Mysql主数据库的ip：192.168.0.21 端口：3307Mysql从数据库的ip：192.168.0.22 端口：3312一、主服务器数据库操作1.主数据库192.168.0.21停止写操作，如果这个数据库本身就是一个从数据库，那么stop slave;命令进行同步的停止。2.主数据库192.168.0.21必须是开启binlog的，开启状态下执行show master ...

主库设置[mysqld]server_id=1port=3306进入主库命令GRANT REPLICATION SLAVE ON *.* TO 'sync_user'@'10.0.0.1' IDENTIFIED BY 'your_password';从库设置[mysqld]server_id=2port = 3306pid-file = /var/run/mysqld/my...

初始化mysql目录：mysqld --initialize --user=mysql --datadir=/data/msql报错：mysqld: Can't create directory '/data/msql' (Errcode: 13 - Permission denied)ubuntu看下apparmor是不是限制MySQL默认数据目录是/var/lib/mysql，其...