Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
3.6k views
in Technique[技术] by (71.8m points)

mysql奇怪问题:无法登录

Ubuntu 18.04 + mysql 5.7

root登录phpmyadmin后再导入一个40多MB的sql数据文件,结果由于服务器太慢,503超时了,然后重新打开phpmyadmin居然无法用root登录了!

默认的debian-sys-maint还是能登录,root死活不能登录,密码就是123456不可错呀~~,看了mysql数据表也没过期呀!

然后在mysql下似乎无法更改root密码(debian-sys-maint登录后修改),phpmyadmin似乎能修改,但是新密码还是无法登录!

怎么回事?有遇到过吗


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

debian-sys-maint用户如果能登录,不妨登录进去,执行select host,user,authentication_string from mysql.user;,贴出来看下


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...