源码网商城,靠谱的源码在线交易网站 我的订单 购物车 帮助

源码网商城

解决mac使用homebrew安装MySQL无法登陆问题

  • 时间:2022-06-07 11:55 编辑: 来源: 阅读:
  • 扫一扫,手机访问
摘要:解决mac使用homebrew安装MySQL无法登陆问题
如果你电脑是Mac的,使用homebrew安装MySQL是一个非常便捷的方式,但是还是会出现一些问题; 首先保证你已经安装了mysql,如果是通过homebrew安装的,输入[code]mysql.server start [/code]启动服务 如果在输入
mysql -u root
出现这个错误ERROR 1045 (28000): Access denied for user [url=]'zhongchengming'@'localhost'[/url] (using password: YES),应该是修改初始密码没有成功 [b]解决步骤[/b] (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)修改密码[code]UPDATE mysql.user SET authentication_string=PASSWORD('你的密码') WHERE User='root';[/code]   成功  Query OK, 1 row affected, 1 warning (0.05 sec)   Rows matched: 1  Changed: 1  Warnings: 1 以上所述是小编给大家介绍的解决mac使用homebrew安装MySQL无法登陆问题,希望对大家有所帮助,如果大家有任何疑问请给我留言,小编会及时回复大家的。在此也非常感谢大家对编程素材网网站的支持!
  • 全部评论(0)
联系客服
客服电话:
400-000-3129
微信版

扫一扫进微信版
返回顶部