Mac brew 安装mysql 报错 ERROR 2002 (HY000): Can't connect to local MySQL server through socket
来源:互联网 发布:sql server 2005 版本 编辑:程序博客网 时间:2024/05/21 06:24
安装mysql 最新版 56
brew install mysql
启动报错
ben:~ soul$ which mysql/usr/local/bin/mysqlben:~ soul$ mysqlERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
解决办法
运行
ben:~ soul$ mysql.server startStarting MySQL. SUCCESS! ben:~ soul$ mysql -uroot -pEnter password: Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 1Server version: 5.6.26 Homebrew
设置 mysql 自启动
设置 mysql root 密码
ben:~ soul$ ls /usr/local/bin | grep mysql --colormsql2mysqlmysqlmysql.servermysql_client_testmysql_client_test_embeddedmysql_configmysql_config_editormysql_convert_table_formatmysql_embeddedmysql_find_rowsmysql_fix_extensionsmysql_install_dbmysql_pluginmysql_secure_installationmysql_setpermissionmysql_tzinfo_to_sqlmysql_upgrademysql_waitpidmysql_zapmysqladminmysqlbinlogmysqlbugmysqlcheckmysqldmysqld_multimysqld_safemysqldumpmysqldumpslowmysqlhotcopymysqlimportmysqlshowmysqlslapmysqltestmysqltest_embeddedben:~ soul$ ben:~ soul$ mysql_secure_installation
关键命令 mysql_secure_installation
(欢迎交流 default.fu@foxmail.com)
0 0
- Mac brew 安装mysql 报错 ERROR 2002 (HY000): Can't connect to local MySQL server through socket
- 【转】运行mysql报错ERROR 2002 (HY000): Can\'t connect to local MySQL server through socket[已解决]
- mac 下的mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock
- Mac下Mysql启动异常["ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.so
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql
- Mysql error 2002 (HY000) : Can't connect to local MySQL server through socket '/tmp/mysql.sock'
- mysql error 2002 (HY000) : Can't connect to local MySQL server through socket '/tmp/mysql.sock'
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/mysql/mysql.sock' (2)
- mac ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
- Ubuntu无法进入mysql,报ERROR 2002 (HY000): Can't connect to local MySQL server through socket …错误
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock'
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock'
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock'
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
- java 类加载机制
- 装饰者模式
- iOS弹幕效果
- Error OK,KO
- Servlet Overview
- Mac brew 安装mysql 报错 ERROR 2002 (HY000): Can't connect to local MySQL server through socket
- spring 中 isolation 和 propagation 详解
- select和epoll解释
- 顺序表基本操作的代码实现:C++实现
- easyui中data-options用法
- Netty学习笔记(一)
- LeetCode Missing Number
- UIScrollView 实践经验
- HttpServletRequest和HttpServletResponse详解