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 3011 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
 |
my3157Aug 10, 2018
1
lsof -i :3306
mysql -u root --host 127.0.0.1 -p mysql cli 默认用 sock 连接, 看下配置文件中 sock 文件的位置 |
 |
lkxlazAug 10, 2018 via Android
2
老哥 mysql 服务没起吧。。。
|
 |
reecoAug 10, 2018
3
先 mysql.server start
|
 |
zenxdsAug 10, 2018
4
最早也是用 brew 装 MySQL，各种问题，还是用 docker 启吧
|
 |
AllenqjyAug 10, 2018
5
home brew 装完 mysql 之后需要使用 brew services 启动, brew services run mysql 或 brew services start mysql， 具体命令说明看我博客贴的： https://qiujunya.com/brew-services.html
|
 |
beginorAug 10, 2018 via Android
9
正确的姿势不应该是 `docker pull mysql` 么？
|
 |
ImmortalAug 10, 2018
10
homebrew 装 mariadb 各种奇怪问题
`docker pull mysql` 之后各种安逸 同推荐 docker |
 |
11
看看报错 -> /usr/local/var/mysql/[你的主机名（ hostname ）].err
然后搜索报错 我 brew upgrade 到 8.0 后不能启动的解决办法： https://blog.notzheng.com/p/brew-mysql-cant-start-solve.html |
1 |
TheWalkingDeadAug 10, 2018 via iPhone
12
今天刚装，install 以后要 mysql.server start
|
 |
14
直接 docker 或者 xampp 要不然时间都花在折腾上了
|
 |
witcherhopeAug 11, 2018 via iPhone
15
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 文件 |
 |
kkk330Aug 11, 2018 via iPhone
16
5.7 升级到 8.0 有几个前置操作，官方文档上有，挨个把命令执行一遍即可无缝升级到 8.0
（当时装了 8 想直接起发现挂了，看了看日志把 5.7 装回来，然后按文档一顿操作就 ok 了 |
Select Language