如果你电脑是Mac的,使用homebrew安装MySQL是一个非常便捷的方式,但是还是会出现一些问题。下面通过本文给大家介绍解决mac使用homebrew安装MySQL无法登陆问题,需要的朋友可以参考下
如果你电脑是Mac的,使用homebrew安装MySQL是一个非常便捷的方式,但是还是会出现一些问题;
首先保证你已经安装了mysql,如果是通过homebrew安装的,输入mysql.server start
启动服务
如果在输入
mysql -u root
出现这个错误ERROR 1045 (28000): Access denied for user 'zhongchengming'@'localhost' (using password: YES),应该是修改初始密码没有成功
解决步骤
(1)终端输入mysqld_safe --skip-grant-tables 显示如下
2017-03-21T11:44:11.6NZ mysqld_safe Logging to '/usr/local/var/mysql/zhongchengmingdeMacBook-Air.local.err'. 2017-03-21T11:44:11.6NZ mysqld_safe Logging to '/usr/local/var/mysql/zhongchengmingdeMacBook-Air.local.err'. 2017-03-21T11:44:11.6NZ mysqld_safe A mysqld process already exists
(2)再次输入mysql -u root显示如下
Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 10 Server version: 5.7.17 Homebrew Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql>
(3)终端输入 use mysql显示如下
Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql>
(4)修改密码UPDATE mysql.user SET authentication_string=PASSWORD('你的密码') WHERE User='root';
成功 Query OK, 1 row affected, 1 warning (0.05 sec)
Rows matched: 1 Changed: 1 Warnings: 1
以上是详解mac使用homebrew安装MySQL无法登陆问题的解决办法的详细内容。更多信息请关注PHP中文网其他相关文章!