![](https://img-blog.csdnimg.cn/20201014180756922.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
MYSQL
杨宇sss
虚拟,现实的结合
展开
-
mysqld_multiwarning: Falling back to the standard locale (“C“).
mysql多实例mysqld_multi启动报错warning: Falling back to the standard locale ("C").[root@master ~]# /etc/init.d/mysqld_multi start 1-3perl: warning: Setting locale failed.perl: warning: Please check that your locale settings: LANGUAGE = (unset), ...原创 2021-05-10 12:06:55 · 261 阅读 · 0 评论 -
mysql mysqld_multi多实例实现主从库
上述网址实现mysqld_multi多实例/etc/init.d/mysqld_multi start 1-3/etc/init.d/mysqld_multi restart 1-3/etc/init.d/mysqld_multi stop 1-3连接实例ysql多实例:[root@localhost ~]# mysql -u root -p123456 -S /tmp/mysql3306.sock[root@localhost ~]# mysql -u root -p1..原创 2020-11-30 19:27:03 · 142 阅读 · 0 评论 -
mysql master-slaveOperation CREATE USER failed for ‘slave_yy‘@‘192.168.2.%‘
出现Slave SQL for channel '': Error 'Operation CREATE USER failed for 'msg_mycat'@'192.168.2.%'' on query. Default database: ''. Query: 'CREATE USER 'msg_mycat'@'192.168.2.%' IDENTIFIED WITH 'mysql_native_password' AS '*6BB4837EB74329105EE4568DDA7DC67ED2CA2A原创 2020-11-30 19:16:16 · 886 阅读 · 0 评论 -
mysql中show master status,输出结果为空
mysql没有开启日志在mysql 配置文件中[mysqld]下添加:log-bin=mysql-binlog-bin配置项表示binlog的base name,产生的日志文件名称类似,mysql-bin.00001,mysql-bin.00002,mysql-bin.00003。保存,重启mysql服务。报错Operation CREATE USER failed for 'slave'@'127.0.0.1'mysql> drop user 'slave'@'12.原创 2020-10-09 18:28:20 · 879 阅读 · 0 评论