阿里云（二）Ubuntu系统下mysql安装

一、ssh登录阿里云服务器，查看是否安装了mysql。（除非之前安装过，一般没有安装）

root@iZwz96t1p8ke0a4l01771vZ:~# sudo netstat -tap | grep mysql

root@iZwz96t1p8ke0a4l01771vZ:~# 

出现以上情况，则表明没有安装数据库

二、安装mysql数据库。

1、输入下面指令，进行安装。

root@iZwz96t1p8ke0a4l01771vZ:~# sudo apt-get install mysql-server mysql-client

2、安装过程出现下面界面，进行设置密码即可。

3、安装完成，测试。

root@iZwz96t1p8ke0a4l01771vZ:~# mysql --version

mysql  Ver 14.14 Distrib 5.7.17, for Linux (x86_64) using  EditLine wrapper

三、数据操作指令。

1、mysql打开状态。

root@iZwz96t1p8ke0a4l01771vZ:~# service mysql status

● mysql.service - MySQL Community Server

   Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)

   Active: active (running) since Sat 2017-04-08 11:52:20 CST; 5min ago

 Main PID: 24520 (mysqld)

   CGroup: /system.slice/mysql.service

           └─24520 /usr/sbin/mysqld

Apr 08 11:52:18 iZwz96t1p8ke0a4l01771vZ systemd[1]: Starting MySQL Community Server...

Apr 08 11:52:20 iZwz96t1p8ke0a4l01771vZ systemd[1]: Started MySQL Community Server.

2、打开/关闭数据库。

root@iZwz96t1p8ke0a4l01771vZ:~# service mysql stop

root@iZwz96t1p8ke0a4l01771vZ:~# service mysql status

● mysql.service - MySQL Community Server

   Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)

   Active: inactive (dead) since Sat 2017-04-08 11:59:30 CST; 12s ago

 Main PID: 24520 (code=exited, status=0/SUCCESS)

Apr 08 11:52:18 iZwz96t1p8ke0a4l01771vZ systemd[1]: Starting MySQL Community Server...

Apr 08 11:52:20 iZwz96t1p8ke0a4l01771vZ systemd[1]: Started MySQL Community Server.

Apr 08 11:58:55 iZwz96t1p8ke0a4l01771vZ systemd[1]: Started MySQL Community Server.

Apr 08 11:59:29 iZwz96t1p8ke0a4l01771vZ systemd[1]: Stopping MySQL Community Server...

Apr 08 11:59:30 iZwz96t1p8ke0a4l01771vZ systemd[1]: Stopped MySQL Community Server.

root@iZwz96t1p8ke0a4l01771vZ:~# service mysql start

root@iZwz96t1p8ke0a4l01771vZ:~# service mysql status

● mysql.service - MySQL Community Server

   Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)

   Active: active (running) since Sat 2017-04-08 12:00:17 CST; 8s ago

  Process: 24689 ExecStartPost=/usr/share/mysql/mysql-systemd-start post (code=exited, status=0/SUCCESS)

  Process: 24680 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)

 Main PID: 24688 (mysqld)

   CGroup: /system.slice/mysql.service

           └─24688 /usr/sbin/mysqld

Apr 08 12:00:16 iZwz96t1p8ke0a4l01771vZ systemd[1]: Starting MySQL Community Server...

Apr 08 12:00:17 iZwz96t1p8ke0a4l01771vZ systemd[1]: Started MySQL Community Server.