mysql服务启动 停止 重启_MySQL 安装 & MySQL 服务启动、停止、重启

1 下载 MySQL

下载即可

或者官网，选择下载平台。

选择下载平台

2 安装 MySQL

打开安装包，按照提示安装即可，最关键的一步，就是设置root密码

建立 数据库连接 的时候要用。

设置 root 密码

3 使用 MySQL

3.1 启动 / 停止 / 重启 MySQL 服务

命令

# 启动 MySQL 服务

sudo /usr/local/MySQL/support-files/mysql.server start

# 停止 MySQL 服务

sudo /usr/local/mysql/support-files/mysql.server stop

# 重启 MySQL 服务

sudo /usr/local/mysql/support-files/mysql.server restart

MySQL配置界面

MySQL配置界面

也可以手动 启动 / 停止 MySQL服务

启动 / 停止 MySQL服务

启动 MySQL，报错

jake@Jake:~/Documents/demo$ sudo /usr/local/MySQL/support-files/mysql.server start

Password:

Starting MySQL

.Logging to '/usr/local/mysql/data/Jake.local.err'.

.................................................................................................... ERROR! The server quit without updating PID file (/usr/local/mysql/data/Jake.local.pid).

解决

那是因为 MySQL 已经启动，停止MySQL服务，再次使用启动命令

或者直接使用即可

jake@Jake:/usr/local/mysql/bin$ sudo /usr/local/MySQL/support-files/mysql.server start

Password:

Starting MySQL

. SUCCESS!

使用 MySQL

切换目录到 /usr/local/mysql/bin ，输入下面命令

# 和 127.0.0.1 发生关系

jake@Jake:/usr/local/mysql/bin$ mysql -uroot -h 127.0.0.1 -p

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 15

Server version: 8.0.13 MySQL Community Server - GPL

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

mysql 命令

mysql> SHOW DATABASES;

+--------------------+

| Database |

+--------------------+

| information_schema |

| mysql |

| performance_schema |

| sys |

+--------------------+

4 rows in set (0.00 sec)

验证安装成功

jake@Jake:/usr/local/mysql/bin$ mysqladmin --version

mysqladmin Ver 8.0.13 for macos10.14 on x86_64 (MySQL Community Server - GPL)