MySQL - Ubuntu 14.04.1 install MySQL 5.7.17

2019独角兽企业重金招聘Python工程师标准>>>

下载：

https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-server_5.7.17-1ubuntu14.04_amd64.deb-bundle.tar

解压：

root@iZwz90ee27lf9oez3h8yyuZ:/usr/local/mysql5.7# tar xvf mysql-server_5.7.17-1ubuntu14.04_amd64.deb-bundle.tar 
mysql-client_5.7.17-1ubuntu14.04_amd64.deb
mysql-community-server_5.7.17-1ubuntu14.04_amd64.deb
libmysqlclient20_5.7.17-1ubuntu14.04_amd64.deb
mysql-common_5.7.17-1ubuntu14.04_amd64.deb
mysql-community-test_5.7.17-1ubuntu14.04_amd64.deb
mysql-community-client_5.7.17-1ubuntu14.04_amd64.deb
mysql-server_5.7.17-1ubuntu14.04_amd64.deb
mysql-community-source_5.7.17-1ubuntu14.04_amd64.deb
libmysqlclient-dev_5.7.17-1ubuntu14.04_amd64.deb
mysql-community_5.7.17-1ubuntu14.04_amd64.changes
mysql-testsuite_5.7.17-1ubuntu14.04_amd64.deb
libmysqld-dev_5.7.17-1ubuntu14.04_amd64.deb

说明：

Ubuntu软件包格式为deb，安装方法如下：

sudo dpkg -i package.deb

dpkg的详细使用方法，网上有很多，下面简单列了几个：

dpkg -i package.deb	安装包
dpkg -r package	删除包
dpkg -P package	删除包（包括配置文件）
dpkg -L package	列出与该包关联的文件
dpkg -l package	显示该包的版本
dpkg –unpack package.deb	解开 deb 包的内容
dpkg -S keyword	搜索所属的包内容
dpkg -l	列出当前已安装的包
dpkg -c package.deb	列出 deb 包的内容
dpkg –configure package	配置包

安装：

安装顺序：
1.mysql-common_5.7.11-1ubuntu14.04_amd64.deb
2.libmysqlclient20_5.7.11-1ubuntu14.04_amd64.deb
3.libmysqlclient-dev_5.7.11-1ubuntu14.04_amd64.deb
4.libmysqld-dev_5.7.11-1ubuntu14.04_amd64.deb
@安装一个依赖包叫libaio1，命令为sudo apt-get intall libaio1

5.mysql-community-client_5.7.11-1ubuntu14.04_amd64.deb
6.mysql-client_5.7.11-1ubuntu14.04_amd64.deb
7.mysql-community-source_5.7.11-1ubuntu14.04_amd64.deb

@再安装一个依赖包叫libmecab2，命令为sudo apt-get intall libmecab2
8.mysql-community-server_5.7.11-1ubuntu14.04_amd64.deb
		如果没有安装libmecab2依赖，会产生软件依赖问题 ：
		mysql-community-server depends on apparmor; however: 
			Package apparmor is not installed. 
		mysql-community-server depends on libmecab2 (>= 0.996-1.2ubuntu1); however: 
			Package libmecab2 is not installed. 
安装过程中需要设置数据库密码。
安装完毕。输入Mysql -uroot-p可以登陆数据库了。

日志：

root@iZwz90ee27lf9oez3h8yyuZ:/usr/local/mysql5.7# dpkg -i mysql-common_5.7.17-1ubuntu14.04_amd64.deb 
Selecting previously unselected package mysql-common.
(Reading database ... 99419 files and directories currently installed.)
Preparing to unpack mysql-common_5.7.17-1ubuntu14.04_amd64.deb ...
Unpacking mysql-common (5.7.17-1ubuntu14.04) ...
Setting up mysql-common (5.7.17-1ubuntu14.04) ...
update-alternatives: using /etc/mysql/my.cnf.fallback to provide /etc/mysql/my.cnf (my.cnf) in auto mode

root@iZwz90ee27lf9oez3h8yyuZ:/usr/local/mysql5.7# dpkg -i libmysqlclient20_5.7.17-1ubuntu14.04_amd64.deb 
Selecting previously unselected package libmysqlclient20:amd64.
(Reading database ... 99434 files and directories currently installed.)
Preparing to unpack libmysqlclient20_5.7.17-1ubuntu14.04_amd64.deb ...
Unpacking libmysqlclient20:amd64 (5.7.17-1ubuntu14.04) ...
Setting up libmysqlclient20:amd64 (5.7.17-1ubuntu14.04) ...
Processing triggers for libc-bin (2.19-0ubuntu6.9) ...

root@iZwz90ee27lf9oez3h8yyuZ:/usr/local/mysql5.7# dpkg -i libmysqlclient-dev_5.7.17-1ubuntu14.04_amd64.deb 
Selecting previously unselected package libmysqlclient-dev.
(Reading database ... 99442 files and directories currently installed.)
Preparing to unpack libmysqlclient-dev_5.7.17-1ubuntu14.04_amd64.deb ...
Unpacking libmysqlclient-dev (5.7.17-1ubuntu14.04) ...
Setting up libmysqlclient-dev (5.7.17-1ubuntu14.04) ...
Processing triggers for man-db (2.6.7.1-1ubuntu1) ...

root@iZwz90ee27lf9oez3h8yyuZ:/usr/local/mysql5.7# dpkg -i libmysqld-dev_5.7.17-1ubuntu14.04_amd64.deb 
Selecting previously unselected package libmysqld-dev.
(Reading database ... 99563 files and directories currently installed.)
Preparing to unpack libmysqld-dev_5.7.17-1ubuntu14.04_amd64.deb ...
Unpacking libmysqld-dev (5.7.17-1ubuntu14.04) ...
Setting up libmysqld-dev (5.7.17-1ubuntu14.04) ...

root@iZwz90ee27lf9oez3h8yyuZ:/usr/local/mysql5.7# dpkg -i mysql-community-client_5.7.17-1ubuntu14.04_amd64.deb 
Selecting previously unselected package mysql-community-client.
(Reading database ... 99571 files and directories currently installed.)
Preparing to unpack mysql-community-client_5.7.17-1ubuntu14.04_amd64.deb ...
Unpacking mysql-community-client (5.7.17-1ubuntu14.04) ...
Setting up mysql-community-client (5.7.17-1ubuntu14.04) ...
Processing triggers for man-db (2.6.7.1-1ubuntu1) ...

root@iZwz90ee27lf9oez3h8yyuZ:/usr/local/mysql5.7# dpkg -i mysql-client_5.7.17-1ubuntu14.04_amd64.deb 
Selecting previously unselected package mysql-client.
(Reading database ... 99628 files and directories currently installed.)
Preparing to unpack mysql-client_5.7.17-1ubuntu14.04_amd64.deb ...
Unpacking mysql-client (5.7.17-1ubuntu14.04) ...
Setting up mysql-client (5.7.17-1ubuntu14.04) ...

当我执行下面命令时，出现配置：

dpkg -i mysql-community-server_5.7.17-1ubuntu14.04_amd64.deb

Package configuration


 鈹屸攢鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹Configuring mysql-community-server 鈹溾攢鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€ 鈹[111C鈹

 鈹Data directory found when no MySQL server package is installed                                                鈹

 鈹[111C鈹

 鈹A data directory '/var/lib/mysql' is present on this system when no MySQL server package is currently         鈹

 鈹installed on the system. The directory may be under control of server package received from third-party       鈹

 鈹vendors. It may also be an unclaimed data directory from previous removal of mysql packages.                  鈹

 鈹[111C鈹

 鈹It is highly recommended to take data backup. If you have not done so, now would be the time to take backup   鈹

n鈹in another shell. Once completed, press 'Ok' to continue.鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹鈹

€鈹[111C鈹

e鈹[52C<Ok>                                       鈹[31;2H鈹[111C 鈹

e鈹[111C鈹

y鈹斺攢鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹

ecommended to take data backup. If you have not done so, now would be the time to take backup   鈹[37;2H鈹
 shell. Once completed, press 'Ok' to continue.                                                     鈹[38
鈹[39;2H鈹[52C<Ok>                                                       鈹[40;2H鈹[111C鈹[41;2H鈹斺攢鈹€
€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹
鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€
€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹€鈹[39;56H           
                                                                                                         
                                                                                                      

输入一个'ok'后，需要输入root用户的密码，然后重复密码：

输入正确后：

root@iZwz90ee27lf9oez3h8yyuZ:/usr/local/mysql5.7# which mysql
/usr/bin/mysql

root@iZwz90ee27lf9oez3h8yyuZ:/usr/local/mysql5.7# dpkg -i mysql-server_5.7.17-1ubuntu14.04_amd64.deb 
Selecting previously unselected package mysql-server.
(Reading database ... 99794 files and directories currently installed.)
Preparing to unpack mysql-server_5.7.17-1ubuntu14.04_amd64.deb ...
Unpacking mysql-server (5.7.17-1ubuntu14.04) ...
Setting up mysql-server (5.7.17-1ubuntu14.04) ...

恭喜finish it
此时mysql已经作为系统服务了：

启动：/etc/init.d/mysql start

完成后的数据目录位置：
data directory : /var/lib/mysql

完成后的配置文件目录位置：
/etc/mysql

 

默认配置

root@iZwz90ee27lf9oez3h8yyuZ:~# cd /etc/mysql
root@iZwz90ee27lf9oez3h8yyuZ:/etc/mysql# ls -R
.:
conf.d  my.cnf  my.cnf.fallback  mysql.cnf  mysql.conf.d

./conf.d:
mysql.cnf

./mysql.conf.d:
mysqld.cnf

 

 

 

 

 

 

 

 

参考：

http://jingyan.baidu.com/article/4f7d5712d5f8181a2019270e.html ubuntu14.04上安装Mysql-5.7.11

http://www.cnblogs.com/jxldjsn/p/5679729.html ubuntu14.04上安装Mysql-5.7.11

https://www.2goo.info/article/detail/941 Ubuntu 通过 Deb 安装 MySQL 5.7

http://blog.csdn.net/haohao_g/article/details/50509072 Ubuntu 14.04 下安装mysql 5.7.10

 

转载于:https://my.oschina.net/anxiaole/blog/820531