管理服务状态
查看 mysql 安装状态
select version();
+-----------+
| version() |
+-----------+
| 8.0.21 |
+-----------+
1 row in set (0.00 sec)
启动服务
可以使用 brew
~ % brew services start mysql
Service `mysql` already started, use `brew services restart mysql` to restart.
~ % brew services restart mysql
也可以使用 sudo
~ % sudo mysql.server start
Starting MySQL
SUCCESS!
但是直接使用 start 会报错
mysql.server start
Starting MySQL
./usr/local/mysql/bin/mysqld_safe: line 653: /usr/local/mysql/data/eva.err: No such file or directory
Logging to '/usr/local/mysql/data/eva.err'.
/usr/local/mysql/bin/mysqld_safe: line 144: /usr/local/mysql/data/eva.err: No such file or directory
/usr/local/mysql/bin/mysqld_safe: line 199: /usr/local/mysql/data/eva.err: No such file or directory
/usr/local/mysql/bin/mysqld_safe: line 916: /usr/local/mysql/data/eva.err: No such file or directory
/usr/local/mysql/bin/mysqld_safe: line 144: /usr/local/mysql/data/eva.err: No such file or directory
ERROR! The server quit without updating PID file (/usr/local/mysql/data/eva.pid).
检查mysql服务状态
先退出mysql命令行,输入命令
$ sudo mysql.server status
Password:
SUCCESS! MySQL running (43260)
显示如上结果说明mysql服务是正常的
重启服务
sudo mysql.server restart
Shutting down MySQL
.. SUCCESS!
Starting MySQL
.2020-08-16T15:19:36.6NZ mysqld_safe A mysqld process with pid=44026 is already running. Aborting!!
SUCCESS!
停止服务
sudo mysql.