《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全面培養人才。
