Access denied for user 'root'@'localhost' (using password: YES)"
来源:互联网 发布:网站访客qq获取源码 编辑:程序博客网 时间:2024/06/05 15:13
连接MySQL数据库,出现问题:Access denied for user 'root'@'localhost' (using password:YES)。
经查找资料发现是root帐户默认不开放远程访问权限,所以需要修改一下相关权限。
添加新用户即可
新建用户:
CREATE USER
'dog'
@
'localhost'
IDENTIFIED BY
'123456'
;
为用户授权:
格式:
grant 权限 on 数据库.* to 用户名@登录主机 identified by "密码";
示例:
grant all privileges on testDB.* to test@localhost identified by '1234';
然后需要执行刷新权限的命令:
flush privileges;
0 0
- #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)
- 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)
- mysql 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)
- HDU 4431 Mahjong 第37届ACM/ICPC 天津赛区现场赛A题
- HDU 5832 A water problem
- 10017---Why are you living your present job
- set 续4
- JavaScript内置对象——Math对象
- Access denied for user 'root'@'localhost' (using password: YES)"
- 朱刘算法
- 【PAT】1015. Reversible Primes
- css计数器小记
- Java 多线程之线程安全
- Shaders for Game Programmers and Artists(6) - 反射与折射
- Spring容器启动过程
- node.js(express)连接mongoDB入门指导
- 多子目录的makefile编译库模板