mysql -u root -p
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)
› MySQL 5.5 Community Server
› MySQL 5.6 Community Server
› Percona Configuration Wizard
› XtraBackup 搭建主从复制
Great Sites on MySQL
› Percona
› MySQL Performance Blog
› Severalnines
推荐管理工具
› Sequel Pro
› phpMyAdmin
推荐书目
› MySQL Cookbook
MySQL 相关项目
› MariaDB
› Drizzle
参考文档
› http://mysql-python.sourceforge.net/MySQLdb.html
MySQL 相关项目
› MariaDB
› Drizzle
参考文档
› http://mysql-python.sourceforge.net/MySQLdb.html
This topic created in 2970 days ago, the information mentioned may be changed or developed.
Supplement 1 · Aug 10, 2018
mysql.server start 也有问题
mysql.server start
Starting MySQL
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/my_macbookpro_name.local.pid).
brew services restart 又没问题
Stopping `mysql`... (might take a while)
==> Successfully stopped `mysql` (label: homebrew.mxcl.mysql)
==> Successfully started `mysql` (label: homebrew.mxcl.mysql)
mysql.server start
Starting MySQL
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/my_macbookpro_name.local.pid).
brew services restart 又没问题
Stopping `mysql`... (might take a while)
==> Successfully stopped `mysql` (label: homebrew.mxcl.mysql)
==> Successfully started `mysql` (label: homebrew.mxcl.mysql)
Supplement 2 · Aug 10, 2018
很久以前装过 dmg 包；后来又改用 homebrew ......
Supplement 3 · Aug 10, 2018
原因已经找到 mysql 5.7 升级到 8.0 的时候，如果没正确退出就会出现这种情况
https://blog.notzheng.com/p/brew-mysql-cant-start-solve.html
https://blog.notzheng.com/p/brew-mysql-cant-start-solve.html
 |
1
my3157 Aug 10, 2018
lsof -i :3306
mysql -u root --host 127.0.0.1 -p mysql cli 默认用 sock 连接, 看下配置文件中 sock 文件的位置 |
 |
2
lkxlaz Aug 10, 2018 via Android
老哥 mysql 服务没起吧。。。
|
 |
3
reeco Aug 10, 2018
先 mysql.server start
|
 |
4
zenxds Aug 10, 2018
最早也是用 brew 装 MySQL，各种问题，还是用 docker 启吧
|
 |
5
Allenqjy Aug 10, 2018
home brew 装完 mysql 之后需要使用 brew services 启动, brew services run mysql 或 brew services start mysql， 具体命令说明看我博客贴的： https://qiujunya.com/brew-services.html
|
 |
9
beginor Aug 10, 2018 via Android
正确的姿势不应该是 `docker pull mysql` 么？
|
 |
10
Immortal Aug 10, 2018
homebrew 装 mariadb 各种奇怪问题
`docker pull mysql` 之后各种安逸 同推荐 docker |
 |
11
mmnsghgn Aug 10, 2018  1
看看报错 -> /usr/local/var/mysql/[你的主机名（ hostname ）].err
然后搜索报错 我 brew upgrade 到 8.0 后不能启动的解决办法： https://blog.notzheng.com/p/brew-mysql-cant-start-solve.html |
 |
12
TheWalkingDead Aug 10, 2018 via iPhone
今天刚装，install 以后要 mysql.server start
|
 |
14
qfdk PRO 直接 docker 或者 xampp 要不然时间都花在折腾上了
|
 |
15
witcherhope Aug 11, 2018 via iPhone
1. 移除所有版本 mysql
brew uninstall --force mysql 2. 重命名 mysql 目录 mv /usr/local/var/mysql /usr/local/var/old.mysql 3. 安装最新版 mysql brew install mysql 4. MySQL Secure Install : /usr/local/bin/mysql_secure_installation 5. 移除 old 文件 |
 |
16
kkk330 Aug 11, 2018 via iPhone
5.7 升级到 8.0 有几个前置操作，官方文档上有，挨个把命令执行一遍即可无缝升级到 8.0
（当时装了 8 想直接起发现挂了，看了看日志把 5.7 装回来，然后按文档一顿操作就 ok 了 |
Select Language