解决mac使用homebrew安装MySQL无法登陆问题
如果你电脑是Mac的,使用homebrew安装MySQL是一个非常便捷的方式,但是还是会出现一些问题;
首先保证你已经安装了mysql,如果是通过homebrew安装的,输入mysql.serverstart启动服务
如果在输入
mysql-uroot
出现这个错误ERROR1045(28000):Accessdeniedforuser'zhongchengming'@'localhost'(usingpassword:YES),应该是修改初始密码没有成功
解决步骤
(1)终端输入mysqld_safe--skip-grant-tables显示如下
2017-03-21T11:44:11.6NZmysqld_safeLoggingto'/usr/local/var/mysql/zhongchengmingdeMacBook-Air.local.err'.
2017-03-21T11:44:11.6NZmysqld_safeLoggingto'/usr/local/var/mysql/zhongchengmingdeMacBook-Air.local.err'.
2017-03-21T11:44:11.6NZmysqld_safeAmysqldprocessalreadyexists
(2)再次输入mysql-uroot显示如下
WelcometotheMySQLmonitor. Commandsendwith;or\g.
YourMySQLconnectionidis10
Serverversion:5.7.17Homebrew
Copyright(c)2000,2016,Oracleand/oritsaffiliates.Allrightsreserved.
OracleisaregisteredtrademarkofOracleCorporationand/orits
affiliates.Othernamesmaybetrademarksoftheirrespective
owners.
Type'help;'or'\h'forhelp.Type'\c'toclearthecurrentinputstatement.
mysql>
(3)终端输入usemysql显示如下
Readingtableinformationforcompletionoftableandcolumnnames
Youcanturnoffthisfeaturetogetaquickerstartupwith-A
Databasechanged
mysql>
(4)修改密码UPDATEmysql.userSETauthentication_string=PASSWORD('你的密码')WHEREUser='root';
成功 QueryOK,1rowaffected,1warning(0.05sec)
Rowsmatched:1 Changed:1 Warnings:1
以上所述是小编给大家介绍的解决mac使用homebrew安装MySQL无法登陆问题,希望对大家有所帮助,如果大家有任何疑问请给我留言,小编会及时回复大家的。在此也非常感谢大家对毛票票网站的支持!