ubuntu 16.0.4安装MySQL5.7

zi663227

　　系统版本
　　root@sishen:~# uname -a
Linux sishen 4.10.0-35-generic #39~16.04.1-Ubuntu SMP Wed Sep 13 09:02:42 UTC 2017 x86_64 x86_64 x86_64 GNU/Linux
　　以下是通过APT的安装方式
　　官方参考文档
　　https://dev.mysql.com/doc/mysql-apt-repo-quick-guide/en/
　　下载MySQL官方提供的deb包：
　　https://repo.mysql.com//mysql-apt-config_0.8.8-1_all.deb
　　在终端执行：
　　root@sishen:~# dpkg -i mysql-apt-config_0.8.8-1_all.deb ，回车之后会弹出如下窗口：

　　然后使用方向键选择OK，回车即可。
　　root@sishen:~# apt-get update
　　安装
　　root@sishen:~# apt-get install –y mysql-server
　　查看状态
　　root@sishen:~# service mysql status
● mysql.service - MySQL Community Server
    Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: en
    Active: active (running) since 一 2017-11-06 11:05:17 CST; 25s ago
  Main PID: 46339 (mysqld)
    CGroup: /system.slice/mysql.service
            └─46339 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysql
　　11月 06 11:05:16 sishen systemd[1]: Starting MySQL Community Server...
11月 06 11:05:17 sishen systemd[1]: Started MySQL Community Server.
　　root@sishen:~# netstat -tap | grep mysql
tcp        0      0 localhost:mysql         *:*                     LISTEN      47316/mysqld
　　使用root登录mysql,注意：我的root账户密码是123456，
　　root@sishen:~# mysql -uroot -p123456
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.7.20 MySQL Community Server (GPL)
　　Copyright (c) 2000, 2017, 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> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.00 sec)
　　mysql> \q
Bye

　　mysql的管理员密码文件存放位置
　　/etc/mysql/debian.cnf
　　如果是以普通用户登录mysql，则需要创建mysql的普通用户
　　创建普通用户时，密码要求太高了，简单的都不行，最后一条命令成功了。
　　mysql> create user 'sishen'@'%' identified by '123qwe';
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
mysql> create user 'sishen'@'%' identified by '12345Qwer';
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
mysql> create user 'sishen'@'%' identified by '123456';
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
mysql> create user 'sishen'@'%' identified by 'SiShen@123';
Query OK, 0 rows affected (0.01 sec)
　　mysql> grant all privileges on *.* to 'sishen'@'%' identified by 'SiShen@123';
Query OK, 0 rows affected, 1 warning (0.00 sec)
　　mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
　　测试
　　root@sishen:~# mysql -usishen -pSiShen@123
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.7.20 MySQL Community Server (GPL)
　　Copyright (c) 2000, 2017, 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> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.00 sec)
　　mysql> \q
Bye
　　到此安装结束。