-
编辑 删除
MySQL忘记root密码，解决办法
1、启动MySQL[root@localhost ~]# mysqld_safe --skip-grant-tables & 2、登录MySQL[root@localhost ~]# mysql -uroot -pEnter password: Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 1Server version: 5.5.25a-log Source distribution...
-
编辑 删除
mysql主从复制丛库IO进程问题
配置mysql主从复制，启动slave进程后查看slave状态是IO进程报错：Last_IO_Error: Fatal error: The slave I/O thread stops because master and slave have equal MySQL server ids; these ids must be different for replication to work (or the --replicate-same-server-id option must be used on slave but this does...
-
编辑 删除
ERROR 1201 (HY000): Could not initialize master info structure; .....
配置mysql主从复制，start slave是报错：ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in the MySQL error log原因：之前做过主从复制解决办法：mysql> stop slave;Query OK, 0 rows affected, 1 warning (0.00 sec)mysql> reset slave;Query OK, 0 rows a...
