mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
来源:互联网 发布:腾讯 大数据 排行 编辑:程序博客网 时间:2024/04/30 10:33
现象:提示禁止访问
limin@liminpc:~$ mysql -uroot -p
**Enter password:
ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)**
解决方法:
1)安全模式启动
limin@liminpc:/etc/mysql/conf.d$ cd /usr/local/mysql/bin
limin@liminpc:/usr/local/mysql/bin$ sudo ./mysqld_safe –user=mysql –skip-grant-tables –skip-networking &
2)重新登陆,无需输入密码
limin@liminpc:/usr/local/mysql/bin$ mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.25-enterprise-commercial-advanced MySQL Enterprise Server - Advanced Edition (Commercial)
Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.
3)修改密码
mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
mysql> update user set Password=PASSWORD(‘password’) where user=’root’;
4)重启msyql
sudo /etc/init.d/msyql restart
- mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) 解决办法
- mysql报错:ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- mysql登录出现:ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- MySQL ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- mysql 错误解决 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- mysql出现:ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) 错误
- MySql 出现ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES).问题解决方案
- MySql数据库链接问题ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- Ubuntu下MySQL的“ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)”
- MySQL ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- MySQL登录出现ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- linux 下mysql 报 ERROR 1045 (28000): Access denied for user '-root'@'localhost' (using password: YES)
- linux安装MySQL出现ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- MySql数据库链接问题ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- MySQL ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)解决办法
- free(p)后指针问题
- Kidding_wjj
- 8086汇编指令速查手册
- Binary Search Tree analog
- [学习笔记—Objective-C]《Objective-C 程序设计 第6版》第三章 类,对象和方法
- mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- rails 4 中 因为secret key 引起在production环境下无法访问 应用的解决办法
- 欢迎使用CSDN-markdown编辑器
- 贪心算法的实际应用
- 给定区间[-2的31次方, 2的31次方]内的3个整数A、B和C,请判断A+B是否大于C。
- 汇编指令的英文全称
- 验证HTTP Referer字段
- php正则表达式—贪婪模式(.*或.+)与懒惰模式(.*?或.+?)的应用
- unity开发相关环境(vs、MonoDevelop)windows平台编码问题