当前位置:首页 > 操作系统 > MacOs

Mac brew 安装mysql 报错 ERROR 2002 (HY000): Can't connect to local MySQL server through socket

mysql

启动报错

<code>ben:~ soul$ which mysql
/usr/<span class="hljs-keyword">local</span>/bin/mysql
ben:~ soul$ mysql
ERROR <span class="hljs-number">2002</span> (HY000): Can‘t connect <span class="hljs-keyword">to</span> <span class="hljs-keyword">local</span> MySQL server <span class="hljs-keyword">through</span> socket ‘/tmp/mysql.sock‘ (<span class="hljs-number">2</span>)</code>

解决办法

运行

<code>ben:~ soul$ mysql.server start
Starting MySQL
. SUCCESS! 
ben:~ soul$ mysql -uroot -p
Enter password: 
Welcome <span class="hljs-keyword">to</span> <span class="hljs-keyword">the</span> MySQL monitor.  Commands <span class="hljs-keyword">end</span> <span class="hljs-keyword">with</span> ; <span class="hljs-keyword">or</span> g.
Your MySQL connection <span class="hljs-property">id</span> <span class="hljs-keyword">is</span> <span class="hljs-number">1</span>
Server <span class="hljs-property">version</span>: <span class="hljs-number">5.6</span><span class="hljs-number">.26</span> Homebrew</code>

设置 mysql 自启动

设置 mysql root 密码

<code><span class="hljs-label">ben:</span>~ soul$ ls /usr/local/bin | grep mysql --color
msql2mysql
mysql
mysql<span class="hljs-preprocessor">.server</span>
mysql_client_test
mysql_client_test_embedded
mysql_config
mysql_config_editor
mysql_convert_table_format
mysql_embedded
mysql_find_rows
mysql_fix_extensions
mysql_install_db
mysql_plugin
mysql_secure_installation
mysql_setpermission
mysql_tzinfo_to_sql
mysql_upgrade
mysql_waitpid
mysql_zap
mysqladmin
mysqlbinlog
mysqlbug
mysqlcheck
mysqld
mysqld_multi
mysqld_safe
mysqldump
mysqldumpslow
mysqlhotcopy
mysqlimport
mysqlshow
mysqlslap
mysqltest
mysqltest_embedded
<span class="hljs-label">ben:</span>~ soul$ 
<span class="hljs-label">ben:</span>~ soul$ mysql_secure_installation</code>

关键命令 mysql_secure_installation

(欢迎交流 default.fu@foxmail.com)

版权声明:本文为博主原创文章,未经博主允许不得转载。

Mac brew 安装mysql 报错 ERROR 2002 (HY000): Can't connect to local MySQL server through socket

标签:brew   mysql   安装   

本文系统来源:http://blog.csdn.net/default7/article/details/48105807


【说明】本文章由站长整理发布,文章内容不代表本站观点,如文中有侵权行为,请与本站客服联系(QQ:254677821)!

相关教程推荐

其他课程推荐