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忘记密码解决办法
标签：com ant may 时报 ring form rpo pre copy
本文系统来源：https://www.cnblogs.com/haiyan123/p/9765447.html
【说明】：本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:254677821)！