背景主数据库已有数据主数据库从数据版本需一致从数据库可ping通主数据库，主数据库无需ping通从数据库（主从备份，从数据库作为备份数据库）主从数据库需开启binlog（全量导入时可暂时关闭增加速度）步骤查看数据库版本mysql> select version();查看是否开启binlogmysql> show variables like 'log_bin';主数据库配置my....
报错内容Slave_SQL_Running 显示Yes正常Slave_IO_Running 一直显示Connecting而不是Yes错误信息显示如下：Slave_IO_Running: Connecting error connecting to master - retry-time: 60 retries: 4 message: Can't connect to MySQL serve...
https://blog.csdn.net/tianshuhao521/article/details/93854326 https://blog.csdn.net/qq_18671415/article/details/105053732
create table tmptable select * from myview
创建用户CREATE USER 'zhangsan'@'%' IDENTIFIED BY zhangsan123';授权所有用户GRANT ALL PRIVILEGES ON *.* TO 'zhangsan'@'%' WITH GRANT OPTION;连接报错解决方法ALTER USER 'zhangsan'@'%' IDENTIFIED WITH mysql_native_passwo...
https://www.cnblogs.com/zipxzf/p/10718544.html常见问题错误：软件包：akonadi-mysql-1.9.2-4.el7.x86_64 (@anaconda)https://blog.csdn.net/weixin_30768661/article/details/97648823
mysql8.0想要设置忽略大小写，必须在装完数据库初始化之前设置才可以，否则设置后会报错。如果数据库在使用过程中要改成忽略大小写，步骤如下：首先停掉数据库，并备份数据systemctl stop mysqld mysqldump -uroot -p --all-databases > sqlfile.sql设置数据库忽略大小写，并删除之前所有数据vi /etc/my.cnf[mysq...
https://www.cnblogs.com/xie97/p/12092254.html
