Mysql必读linux下 root 登录 MySQL 报错的问题
|
《Mysql必读linux下 root 登录 MySQL 报错的问题》要点： MYSQL实例最近在centOS 7上,通过yum安装了mysql,安装胜利后,使用root登录,出现了如下报错： MYSQL实例
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
MYSQL实例mysql版本为：Ver 14.14 Distrib 5.7.10,for Linux(X86_64) using EditLine wrapper MYSQL实例然而实际上并没有进行过root暗码设置(不知道是不是安装过程有被忽略的地方?). MYSQL实例对此就各种寻找谜底,大致有下面一些情况： MYSQL实例有说root的随机暗码位于/root/.mysql_secret中,但是我根本没有/root/.mysql_secret文件.有文章表示 MYSQL实例
> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
> password: NO) :表示没有生成root的临时密码
>
> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
> password: YES) :表示生成了root的临时密码.
MYSQL实例有些资料说root的默认密码为空,经过确认那是以前的老版本,Mysql 5.6及以后版本出处于平安考虑,root密码已经不为空了. MYSQL实例发生原因： MYSQL实例
Now that the password MySQL had generated is expired,the problem is reduced to getting this password to work again (1) or generate a new one (2). This can be accomplished by running MySQL with the skip-grant-tables option which would make it ignore the access rights:
MYSQL实例解决办法： 代码如下:Stop your MySQL server. Add skip-grant-tables at the end of the [mysqld] section of my.cnf file and save it. Start MySQL server. In terminal,typemysql -u root -pto get into MySQL command prompt. In the command prompt,typeUSE mysql;to get into the mysql database where it keeps database users. Type UPDATE user SET password_expired = 'N' WHERE User = 'root'; to let MySQL know the password is not expired (1) or UPDATE user SET authentication_string = PASSWORD('YourNewPassword'),password_expired = 'N' WHERE User = 'root'; MYSQL实例附上链接：Unable to access MySQL after it automatically generated a temporary password MYSQL实例发布出来,供年夜家参考. 《Mysql必读linux下 root 登录 MySQL 报错的问题》是否对您有启发，欢迎查看更多与《Mysql必读linux下 root 登录 MySQL 报错的问题》相关教程，学精学透。编程之家PHP学院为您提供精彩教程。 （编辑：李大同） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |