mac 安装 mysql 与常用命令

blairchen

Publish：Dec 3, 2017

介绍 Mac 安装 Mysql 与 mysql 在 mac 在的命令

1. brew install

1	brew install mysql

在mac下使用 brew 安装 mysql，之前没有使用过，今天启动的时候发现启动不了

1
2
3

# /usr/local/bin [9:31:54]
➜ mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

1 2	➜ brew info mysql mysql: stable 8.0.12 (bottled)

2. 启动mysql

1	➜ mysql.server start

3. 设置密码

1	mysql_secure_installation

4. 进入mysql

1	mysql -u root -p

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.01 sec)

mysql>

5. 常用命令

$ mysql.server start
$ mysql.server restart
$ mysql.server stop
$ mysql.server status
$ mysql -u root -p

Reference

mac用brew安装mysql,设置初始密码

updated on：Jun 28, 2021

mysql

杨帅完美发音班(1)

把发音练好的方法就是重复, 语言学习的本质就是模仿 but you’re old… 0 ~ 6 years 可以通过耳朵识别 140 个不同的音, 也可以马上模仿 6 岁之后，这种能力逐渐下降…...

Neural Networks and Deep Learning (week1) - Introduction to Deep Learning

Introduction to Deep Learning What is a Neural Network ? Why is Deep Learning taking off ? 1....

Comments

Load Disqus

mac 安装 mysql 与 常用命令