MySQL远程连接提示Accesss denied for user 'root'@'此处为你自己的ip'(using password:YES)
来源:互联网 发布:大数据修炼系统txt 编辑:程序博客网 时间:2024/06/06 10:53
昨天在服务器上配置了一个数据库,可是不论如何也连不上,数据库权限也开了,服务器防火墙也关了,但就是连不上,报如下错误,如图
今天终于找到解决办法了不能连接主要是因为数据库的用户名是root,所以会被拒绝连接解决办法就是新建一个用户,比如TestUser然后再给TestUser授权远程访问,即:mysql>GRANT ALL PRIVILEGES ON *.* TO 'TestUser'@'%' IDENTIFIED BY '此处为TestUser的密码’' WITH GRANT OPTION;
即可远程连接数据库
阅读全文
0 0
- MySQL远程连接提示Accesss denied for user 'root'@'此处为你自己的ip'(using password:YES)
- windows XP中,mysql连接时提示:1045 access denied for user 'root'@'localhost' using password yes 的解决方法
- 解决Navicat连接的时候出现了1045 -Access denied for user'root'@'ip'(using password :yes)--mysql
- Access denied for user 'root '@'连接的ip'(using password:YES)
- MySQL的时候提示Access denied for user 'root'@'localhost' (using password: YES)
- mysql 提示 access denied for user 'root'@'localhost'(using password:YES) 的解决方法
- 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)的解决方法
- 解决用Mysql 使用navicate远程连接数据库出现1045 access denied for user 'root'@'localhost' using password yes
- 解决用远程连接mysql数据库出现1045 access denied for user 'root'@'localhost' using password yes
- root用户连接mysql数据库出错 1045 access denied for user 'root'@'localhost' using password yes
- mysql Access denied for user 'root'@'localhost' (using password: YES)
- mysql Access denied for user 'root'@'localhost' (using password: YES)
- MySql Access denied for user 'root'@'localhost' (using password: YES)
- mysql Access denied for user 'root'@'%' (using password: YES)
- mysql access denied for user'root'@'localhost' using password yes
- mysql Access denied for user 'root'@'localhost' (using password: YES)
- 字符串替换
- Spanned及CharSequence
- c# Console.WriteLine() Console.ReadLine()
- aop源码解析二:postProcessBeforeInstantiation
- hibernate的get,load,persist方法比较(二)
- MySQL远程连接提示Accesss denied for user 'root'@'此处为你自己的ip'(using password:YES)
- 数据结构-排序
- makefile入门
- word2016与mathtype6.9的兼容
- dd iso
- 单例
- 递归经典算法 汉诺塔问题
- ceil函数
- 实体类和JSON对象之间相互转化