背景:部署项目配置环境,对应的MySQL版本为5.7.20,安装教程如下:
1.在Mysql官网上下载Ubuntu Linux专用的Mysql。因为Ubuntu的版本为14.04.5,我这里下载的是:mysql-server_5.7.20-1ubuntu14.04_amd64.deb-bundle.tar。
2.打开终端,输入命令,下载MySQL DEB Bundle tar文件:
wget https://downloads.mysql.com/archives/get/p/23/file/mysql-server_5.7.20-1ubuntu14.04_amd64.deb-bundle.tar
3.下载完成后,复制到/usr/local/src目录下:
sudo cp mysql-server_5.7.20-1ubuntu14.04_amd64.deb-bundle.tar /usr/local/src
4.进入该目录下:
cd /usr/local/usr
5.赋予tar文件可执行权限:
sudo chmod +x mysql-server_5.7.20-1ubuntu14.04_amd64.deb-bundle.tar
6.解压该tar文件,解压后一共11个文件:
sudo tar -xvf mysql-server_5.7.20-1ubuntu14.04_amd64.deb-bundle.tar
mysql-community-source_5.7.20-1ubuntu14.04_amd64.deb
mysql-client_5.7.20-1ubuntu14.04_amd64.deb
mysql-common_5.7.20-1ubuntu14.04_amd64.deb
libmysqlclient-dev_5.7.20-1ubuntu14.04_amd64.deb
mysql-server_5.7.20-1ubuntu14.04_amd64.deb
mysql-community-server_5.7.20-1ubuntu14.04_amd64.deb
libmysqlclient20_5.7.20-1ubuntu14.04_amd64.deb
mysql-testsuite_5.7.20-1ubuntu14.04_amd64.deb
mysql-community-test_5.7.20-1ubuntu14.04_amd64.deb
mysql-community-client_5.7.20-1ubuntu14.04_amd64.deb
libmysqld-dev_5.7.20-1ubuntu14.04_amd64.deb
7. 按以下次序依次执行:
sudo dpkg -i mysql-common_5.7.20-1ubuntu14.04_amd64.deb
sudo dpkg-preconfigure mysql-community-server_5.7.20-1ubuntu14.04_amd64.deb
上面这一步需要设置root密码。
设置后,继续执行:
sudo dpkg -i libmysqlclient20_5.7.20-1ubuntu14.04_amd64.deb
sudo dpkg -i libmysqlclient-dev_5.7.20-1ubuntu14.04_amd64.deb
sudo dpkg -i libmysqld-dev_5.7.20-1ubuntu14.04_amd64.deb
sudo dpkg -i mysql-community-client_5.7.20-1ubuntu14.04_amd64.deb
正在选中未选择的软件包 mysql-community-client。
(正在读取数据库 ... 系统当前共安装有 59254 个文件和目录。)
正准备解包 mysql-community-client_5.7.20-1ubuntu14.04_amd64.deb ...
正在解包 mysql-community-client (5.7.20-1ubuntu14.04) ...
dpkg: 依赖关系问题使得 mysql-community-client 的配置工作不能继续:
mysql-community-client 依赖于 libaio1 (>= 0.3.93);然而:
未安装软件包 libaio1。
dpkg: 处理软件包 mysql-community-client (--install)时出错:
依赖关系问题 - 仍未被配置
正在处理用于 man-db (2.6.7.1-1ubuntu1) 的触发器 ...
在处理时有错误发生:
mysql-community-client
安装依赖 libaio1:
sudo apt-get -f install libaio1
重新执行:
sudo dpkg -i mysql-community-client_5.7.20-1ubuntu14.04_amd64.deb
继续执行:
sudo dpkg -i mysql-client_5.7.20-1ubuntu14.04_amd64.deb
sudo dpkg -i mysql-common_5.7.20-1ubuntu14.04_amd64.deb
sudo dpkg -i mysql-community-server_5.7.20-1ubuntu14.04_amd64.deb
正在选中未选择的软件包 mysql-community-server。
(正在读取数据库 ... 系统当前共安装有 59324 个文件和目录。)
正准备解包 mysql-community-server_5.7.20-1ubuntu14.04_amd64.deb ...
正在解包 mysql-community-server (5.7.20-1ubuntu14.04) ...
dpkg: 依赖关系问题使得 mysql-community-server 的配置工作不能继续:
mysql-community-server 依赖于 libmecab2 (>= 0.996-1.1);然而:
未安装软件包 libmecab2。
dpkg: 处理软件包 mysql-community-server (--install)时出错:
依赖关系问题 - 仍未被配置
正在处理用于 man-db (2.6.7.1-1ubuntu1) 的触发器 ...
正在处理用于 ureadahead (0.100.0-16) 的触发器 ...
ureadahead will be reprofiled on next reboot
在处理时有错误发生:
mysql-community-server
上边这一步报错,需安装依赖libmecab2:
sudo apt-get -f install libmecab2
重新执行:
sudo dpkg -i mysql-community-server_5.7.20-1ubuntu14.04_amd64.deb
继续执行:
sudo dpkg -i mysql-server_5.7.20-1ubuntu14.04_amd64.deb
8.登录MySQL:
mysql -u root -p
9.输入密码,登录成功:
mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
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> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed