ubuntu下mysql5.7的'Access denied for user 'root'@'localhost' (using password: YES)'错误
来源:互联网 发布:中超数据库 2017 门将 编辑:程序博客网 时间:2024/06/05 06:24
我的环境是utuntu 16.0.4 下apt-get安装mysql,登陆无法登陆,报错信息这样描述:在用命令(sudo apt-get install mysql-server mysql-client)安装完.mysql服务即开始运行了.此时需要修改root密码,但经常会出现这么一种情况.'Access denied for user 'root'@'localhost' (using password: YES)' 或者其他致使无法登录mysql的情况。
解决方法:
1.打开/etc/mysql/debian.cnf文件,里面存储了相关的密码,我的文件信息如下
sudo vi /etc/mysql/debian.cnf
# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host = localhost
user = debian-sys-maint
password = 6x1XG2B5p75WtFV2
socket = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host = localhost
user = debian-sys-maint
password = 6x1XG2B5p75WtFV2
socket = /var/run/mysqld/mysqld.sock
basedir = /usr
在[client]段有user=以及password=这两行,这就是通过apt-get安装mysql,系统给我们设置的mysql登录名和密码
2. 输入命令:
mysql -udebian-sys-maint -p
debian-sys- maint即debian.cnf中user=后面的内容.回车后会提示输入密码,此时把password=后面的内容复制粘贴后回车即可进行mysql 控制台
3.进入控制台后.按以下步骤进行:
use mysqlupdate mysql.user set authentication_string=PASSWORD('password') where User='root';
FLUSH PRIVILEGES;
此时可以输入quit;退出后用root帐号登录,也可以继续其他操作.
- ubuntu下mysql5.7的'Access denied for user 'root'@'localhost' (using password: YES)'错误
- Ubuntu mysql 的Access denied for user 'root'@'localhost' (using password: YES错误解决方法
- Ubuntu下MySQL的“ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)”
- 解决ubuntu下mysql的'Access denied for user 'root'@'localhost' (using password: YES)'
- linux下连接windows mysql的错误:Access denied for user 'root'@'localhost' (using password: YES)
- win7下mysql5.6遇到Access denied for user 'root'@'localhost'(using password :NO/YES)
- mac下安装mysql5.7.18,连接出现Access denied for user 'root'@'localhost' (using password: YES)
- mac下安装mysql5.7.18,连接出现Access denied for user 'root'@'localhost' (using password: YES)
- java连接mysql5.7报错Access denied for user 'root'@'localhost' (using password: YES)解决
- MYSQL5.7:Access denied for user 'root'@'localhost' (using password:YES)解决方法
- java连接mysql5.7报错Access denied for user 'root'@'localhost' (using password: YES)解决
- Mysql-(Mysql5.7及以上版本)Access denied for user 'root'@'localhost' (using password:YES) 解决方案
- Windows系统下MySQL数据库出现Access denied for user 'root'@'localhost' (using password:YES) 错误
- 解决mysql的错误-access denied for user 'root'@'localhost'(using password:YES) for MACOS
- mysql中Access denied for user 'root'@'localhost' (using password:YES) 错误的解决方法
- MySql错误1045 Access denied for user 'root'@'localhost' (using password:YES) windows下的解决方案(忘记密码)
- mac下的error: 'Access denied for user 'root'@'localhost' (using password: YES)'
- Linux下连接Mysql出现:Access denied for user 'root'@'localhost' (using password:YES)的解决方法
- Android 设置adjustResize失效
- 在Python中实现PageFactory模式
- 安装cocoapods时候出现错误如下: sudo gem install cocoapods ERROR: While executing gem … (OpenSSL::SSL::SSLErro
- 使用Kotlin配合RxJava网络请求
- 白话经典算法系列之十六 “基数排序”之数组中缺失的数字
- ubuntu下mysql5.7的'Access denied for user 'root'@'localhost' (using password: YES)'错误
- 安卓apk反编译
- Kotlin入门(11)江湖绝技之特殊函数
- FZU 2150Fire Game
- 向您的项目添加 C 和 C++ 代码
- vector
- atan和atan2
- Java File类
- 续写异常-(几个程序)