Mysql复制错误error_code: 1045 Access denied for user
来源:互联网 发布:linux 打包一个文件夹 编辑:程序博客网 时间:2024/06/04 19:57
尝试配置mysql复制的时候使用show slave status\G出现下面的错误:
[ERROR] Slave I/O: Master commandCOM_REGISTER_SLAVE failed:Accessdenied for user 'replica'@'12.34.56.78' (using password: YES) (Errno: 1045), Error_code:1597
[ERROR]Slave I/O thread couldn't register on master
看这个错误是因为权限不够被拒绝,查了一下文档还需要在master上对复制账号增加下面的权限:
#(master server) add grant to replica user to connect from the new slave server
mysql>grant replication slave on *.* to 'replica'@'new_slave_name_or_ip' identifiedby 'password';
运行之后复制可以正常工作,可以看到
Slave_IO_Running=Yes
Slave_SQL_Running=Yes
创建表测试数据也复制正常,第一次配置mysql复制发帖纪念一下。
0 0
- Mysql复制错误error_code: 1045 Access denied for user
- mysql Access denied for user 错误处理
- MySql access denied for user错误
- windonws8 下 phpmyadmin 1045错误:mysql Access denied for user
- mysql 1045 access denied for user 解决方法
- mysql 1045 access denied for user 解决方法
- mysql 1045 access denied for user 'root'@'
- Access denied for user错误
- Mysql错误: Access denied for user ''@'localhost' to database 'mysql'
- MySQL提示Access denied for user 'ODBC'@'localhost'错误
- mysql Access denied for user root@localhost错误解决方法总结
- MySQL WINDOWS-XP错误: Access denied for user 'root'@'localhost'
- mysql Access denied for user root@localhost错误解决方法总结
- 链接mysql密码错误的异常 Access denied for user
- mysql Access denied for user root@localhost错误解决方法总结
- mysql Access denied for user root@localhost错误解决方法总结
- mysql Access denied for user root@localhost错误解决方法总结
- mysql Access denied for user root@localhost错误
- 黑马程序员 ---- static 类变量
- 城市山洪灾害多目标评估国内外研究现状
- Google Code Jam 2014 预赛 Problem B. Cookie Clicker Alpha
- 删除CVS版本控制
- 历史在重演:从KHTML到WebKit,再到Blink
- Mysql复制错误error_code: 1045 Access denied for user
- Jquery 跳出循环
- 改变自己的133种方法
- libgdx input分析
- c语言中读取命令行参数
- 新xcode的literal syntax是什么
- iOS开发- UICollectionView详解+实例
- 动态链表队列--内存溢出异常-和边界溢出
- SharePoint 沙盒解决方案部署无法启动计算机服务SPUserCodeV4