《Mysql必读解决mac使用homebrew安装MySQL无法登陆问题》要点：
本文介绍了Mysql必读解决mac使用homebrew安装MySQL无法登陆问题，希望对您有用。如果有疑问，可以联系我们。
MYSQL必读如果你电脑是Mac的,使用homebrew安装MySQL是一个非常便捷的方式,但是还是会出现一些问题；
MYSQL必读首先保证你已经安装了mysql,如果是通过homebrew安装的,输入mysql.server start 启动服务
MYSQL必读如果在输入
MYSQL必读
mysql -u root
MYSQL必读出现这个错误ERROR 1045 (28000): Access denied for user 'zhongchengming'@'localhost' (using password: YES),应该是修改初始暗码没有成功
MYSQL必读办理步骤
MYSQL必读(1)终端输入mysqld_safe --skip-grant-tables 显示如下
MYSQL必读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
MYSQL必读 (2)再次输入mysql -u root显示如下
MYSQL必读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>
MYSQL必读 (3)终端输入 use mysql显示如下
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>
MYSQL必读(4)修改暗码UPDATE mysql.user SET authentication_string=PASSWORD('你的暗码') WHERE User='root';
MYSQL必读 成功 Query OK, 1 row affected, 1 warning (0.05 sec)
MYSQL必读 Rows matched: 1 Changed: 1 Warnings: 1
MYSQL必读以上所述是小编给大家介绍的办理mac使用homebrew安装MySQL无法登陆问题,希望对大家有所帮助,如果大家有任何疑问请给我留言,小编会及时回复大家的.在此也非常感谢大家对维易PHP网站的支持!
维易PHP培训学院每天发布《Mysql必读解决mac使用homebrew安装MySQL无法登陆问题》等实战技能，PHP、MYSQL、LINUX、APP、JS,CSS全面培养人才。
