Access denied for user 'root '@'连接的ip'(using password:YES)
来源:互联网 发布:呼死你在淘宝上叫什么 编辑:程序博客网 时间:2024/06/05 21:16
今天使用远程连接连接刚刚配好的MariaDB的时候发生了这个问题Access denied for user ‘root ‘@’连接的ip’(using password:YES)
但是到主机上使用密码连接的时候又能登录,但是那边又包密码错误。
解决方法:在要连接的主机上使用密码登陆
进入之后使用下面的命令登录
MariaDB [(none)]> use mysql;Reading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -ADatabase changedMariaDB [mysql]> select user,password,host from user;
查看你的用户密码是否一致
一开始上下localhost和%的密码不一致
所有造成无法远程连接
使用下面的命令
MariaDB [mysql]> update user set password=password('设置密码') where host='%';MariaDB [mysql]> update user set password=password('设置密码') where host='localhost';
然后就能正常登录了
0 0
- Access denied for user 'root '@'连接的ip'(using password:YES)
- 连接数据库失败:Access denied for user 'root'@'(ip地址)' (using password: YES)
- Access denied for user 'root'@'hadoop1master' (using password: YES)
- 解决Navicat连接的时候出现了1045 -Access denied for user'root'@'ip'(using password :yes)--mysql
- linux下连接windows mysql的错误:Access denied for user 'root'@'localhost' (using password: YES)
- 连接mysql的时候报错Access denied for user: 'root@127.0.0.1' (Using password: YES)
- Linux下连接Mysql出现:Access denied for user 'root'@'localhost' (using password:YES)的解决方法
- #1045 - Access denied for user 'root'@'localhost' (using password: YES)
- Access denied for user 'root'@'localhost' (using password: YES) 问题解决
- 解决'Access denied for user 'root'@'localhost' (using password: YES)'
- access denied for user 'root'@'localhost' using password yes
- access denied for user 'root'@'localhost' using password yes
- 1045 access denied for user 'root'@'localhost' using password yes
- Access denied for user 'root'@'localhost' (using password: YES)解决办法
- Access denied for user: 'root@localhost' (Using password: YES)
- Access denied for user 'root'@'localhost' (using password: YES)
- Access denied for user 'root'@'localhost' (using password:YES) 解决方案
- mysql Access denied for user 'root'@'localhost' (using password: YES)
- tcp状态
- Javascript模块化编程(一):模块的写法
- 检查字符串是否存在字符变位
- PHP打印输出数组内容及结构函数print_r与var_dump
- 32岁,重回研发,不为别的,给自己过去一个交待!
- Access denied for user 'root '@'连接的ip'(using password:YES)
- 安装完Hadoop之后,命令行输入hadoop却找不到命令的解决方法
- WCF实现http访问地址后面带参数访问方式
- ACdream1415--最短路,桥
- 程序执行流程
- Java中Vector与ArrayList的区别详解
- C语言之预编译指令
- Spring-----Spring整合Struts2实例
- 设置随机颜色