启动报错
<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)!