sql server安装教程:https://mp.weixin.qq.com/s/I6tS1hQzOOJYj5Cf2Wfraw
连接mysql出现错误:SQL Error (2013): Lost connection to MySQL server at ‘waiting for initial communication packet’, system error: 0
解决办法:打开my.ini,找到[mysqld]项,在其后加入一句:skip-name-resolve,保存,重启mysql服务即可
如果忘记密码:
添加登录跳过权限检查配置
修改my.cnf,在mysqld配置节点添加skip-grant-tables配置
[mysqld]
skip-grant-tables
https://segmentfault.com/a/1190000010867488
https://www.cnblogs.com/zgx/archive/2011/09/13/2174823.html
mysql> CHANGE MASTER TO
-> MASTER_HOST=‘192.168.239.133’,
-> MASTER_USER=‘test’,
-> MASTER_PASSWORD=‘123456’,
-> MASTER_LOG_FILE=‘mysql-bin.000002’,
-> MASTER_LOG_POS=120;
mysql主从复制
最新推荐文章于 2024-07-04 19:28:13 发布