1045 - Access denied for user ‘like’@'localhost'(using password:YES)
来源:互联网 发布:php视频直播间开发 编辑:程序博客网 时间:2024/06/05 01:52
安装了数据库mysql 5.1.42 ,然后装了Navicat 8 for MySql图形界面工具,配置连接如下:
总是弹出下面的错误:
1045 - Access denied for user ‘like’@'localhost'(using password:YES)
搜了很多解决方法(其中之一):
在windows下的解决办法如下:
1.net stop mysql 停用服务
2.修改${mysql_home}/MySQL Server 5.1目录下的my.ini文件
[mysqld]下面添加这句:
skip_grant_tables
3.把你的${mysql_home}/bin目录加入path路径里边
4.net start mysql 启动mysql服务
5.mysql -uroot -p
Enter password:root
6.mysql>UPDATE user SET Password=PASSWORD('root') where USER='root';
mysql>FLUSH PRIVILEGES;
mysql>exit
7.删除my.ini中的这句话:skip_grant_tables
net stop mysql
net start mysql
8.可以登录了
mysql -uroot -proot
mysql>
我直接试了第二步,然后保存my.ini,重启Mysql服务,再用刚才配置的Navicat连接,ok
- 1045 - Access denied for user ‘like’@'localhost'(using password:YES)
- 1045 - Access denied for user ‘like’@'localhost'(using password:YES)
- #1045 - Access denied for user 'root'@'localhost' (using password: YES)
- 1045 access denied for user 'root'@'localhost' using password yes
- #1045 - Access denied for user 'root'@'localhost' (using password: YES)
- 1045 access denied for user 'root'@'localhost' using password yes
- 1045 - Access denied for user 'root'@'localhost'(using password:YES)
- 1045 access denied for user 'root'@'localhost' using password yes
- 1045 - Access denied for user ' xxxx '@'localhost' (using password :YES)
- #1045 - Access denied for user 'root'@'localhost' (using password: YES)
- 1045 access denied for user 'root'@'localhost' using password yes
- 1045 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) 1045
- 1045 access denied for user\'root\'@\'localhost\' using password yes
- 1045 access denied for user 'root'@'localhost' using password yes
- 1045 access denied for user ’root’@’localhost’ using password yes
- 1045, "Access denied for user 'root'@'localhost' (using password: YES)"
- 关于淘宝店铺运营的一点思考
- 关于百度“凤巢”的猜想及其它
- Linux下Redis+crontab实现任务队列
- 关于百度快照回档及百度快照消失的一些分析
- PB判断数据窗口数据是否更改及原始值与当前值
- 1045 - Access denied for user ‘like’@'localhost'(using password:YES)
- Effective Objective-C 第二章
- 心里所想,想你所想·
- Oracle 数据导入/导出 命令 cmd
- 采用CAS原理构建单点登录
- 真爱源于平淡
- 关于百度目前对新站的收录
- 关于百度统计 站长不能不知道的4件事
- 关于百度诚信认证