2、mysql -uroot -p，用这条命令登陆时报错信息：
<span style="color: #000000">报错：Enter password: <span style="color: #ff0000">ERROR </span></span><span style="color: #ff0000">1045 (28000): Access denied for user ‘root‘@‘localhost‘ (using password: YES)</span>
3、打开终端输入：sudo mysqld_safe --skip-grant-tables
<span style="color: #000000">输出 Password: Logging to </span>‘/usr/local/mysql/data/localhost.err‘<span style="color: #000000">. </span>2018-10-10T03:21:40.6NZ mysqld_safe Starting mysqld daemon <span style="color: #0000ff">with</span> databases from /usr/local/mysql/data
4、打开一个新的终端，输入：mysql -u root ，会看到以下输出。
Welcome to the MySQL monitor. Commands end <span style="color: #0000ff">with</span><span style="color: #000000"> ; or g. Your MySQL connection id is </span>16<span style="color: #000000"> Server version: </span>5.7.23<span style="color: #000000"> MySQL Community Server (GPL) Copyright (c) </span>2000, 2018, Oracle and/or its affiliates. All rights reserved. <span style="color: #000000"> Oracle is a registered trademark of Oracle Corporation and</span>/or its <span style="color: #000000">affiliates. Other names may be trademarks of their respective owners. Type </span>‘help;‘ or ‘h‘ <span style="color: #0000ff">for</span> help. Type ‘c‘<span style="color: #000000"> to clear the current input statement. mysql</span>>
5、终端输入 use mysql显示如下
Reading table information <span style="color: #0000ff">for</span><span style="color: #000000"> completion of table and column names You can turn off </span><span style="color: #0000ff">this</span> feature to get a quicker startup <span style="color: #0000ff">with</span> -<span style="color: #000000">A Database changed</span>
6、修改密码：UPDATE mysql.user SET authentication_string=PASSWORD(‘你的密码‘) WHERE User=‘root‘;
Query OK, 1 row affected, 1 warning (0.01<span style="color: #000000"> sec) Rows matched: </span>1 Changed: 1 Warnings: 1
十五、mac 中登陆mysql忘记密码解决办法
标签：href host gpl oracle serve nec tab 信息 mys
本文系统来源：https://www.cnblogs.com/feifeifeisir/p/9827716.html
【说明】：本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:254677821)！