centos7 上安装mysql5.7后登录报错ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using pas
来源:互联网 发布:075566858233淘宝诈骗 编辑:程序博客网 时间:2024/06/07 06:26
安装完mysql后会有个临时密码去日志查看,但是查看登录修改密后还是不行
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password:yes)
于是
1,停止mysql服务
systemctl stop mysqld.service
2,修改配置文件无密码登录
vi /etc/my.cnf
在最尾部加上
skip-grant-tables保存
3,启动mysql
systemctl start mysqld.service
4,登录musql
mysql -u root此处注意不要加-p
5,修改密码,mysql5.7用此语法
use mysql ;
update mysql.user set authentication_string=password('123456') where user='root' ;
6,回到第二步骤去掉加上的
skip-grant-tables
保存 重启mysql就ok了
#########################################################################
其实默认安装完了mysql后或在日志中生成一个默认的密码 /var/log/mysqld.log 中
拿到默认密码后登录mysql 进行密码重新设置
set password=password('you password');
如果密码级别与默认的级别要求不符时候会报
Your password does not satisfy the current policy requirements此时需要修改级别与最小的默认密码位数
set global validate_password_policy=0;set global validate_password_length=4;然后在进行设置密码就好了
###################
远程连接时1130错误
mysql;use mysql; mysql;select 'host' from user where user='root'; mysql;update user set host = '%' where user ='root'; mysql;flush privileges; mysql;select 'host' from user where user='root';
阅读全文
0 0
- centos7 上安装mysql5.7后登录报错ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using pas
- mysql安装在centos7报错ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- mysql安装在centos7报错ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- mysql安装在centos7报错ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- ubuntu 16.04安装mysql5.7.17后,登录时出现ERROR 1045 (28000): Access denied for user 'root'@'localhost' 问题解决!
- CentOS 命令登录MySQL时,报错 ERROR 1045 (28000): Access denied for user root@localhost (using password: NO)
- linux下登录mysql报错“ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO“)
- 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: NO)
- mysql 安装后报 ERROR 1045 (28000): Access denied for user 'root'@'localhost'
- java连接mysql5.7报错Access denied for user 'root'@'localhost' (using password: YES)解决
- java连接mysql5.7报错Access denied for user 'root'@'localhost' (using password: YES)解决
- Mac安装MySQL5.7.19 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- mysql报ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password)错误或者远程用户不能登录
- centos7 mariadb ERROR 1045 (28000): Access denied for user root@localhost (using password: NO)
- Ubuntu9.10安装MySQL后登陆报错,Mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost'
- mysql登录出现:ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- 解决MySQL登录ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using passwor)问题
- RCNN学习笔记(7):You Only Look Once(YOLO):Unified, Real-Time Object Detection
- 转载
- JVM--从volatile深入理解Java内存模型
- 1025. 反转链表 (25)
- 第七篇:JAVA常用类之String
- centos7 上安装mysql5.7后登录报错ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using pas
- Gym 101341D Jumps 数论|签到
- 九度oj-1161:Repeater
- 练习题1
- Life and death
- leetcode编程中数组题目
- RCNN学习笔记(8):OverFeat:Integrated Recognition, Localization and Detection using Convolutional Network
- sizeof(i++)是多少?
- SQL 数据库优化 索引,SQL索引优化-技巧