视频1 视频21 视频41 视频61 视频文章1 视频文章21 视频文章41 视频文章61 推荐1 推荐3 推荐5 推荐7 推荐9 推荐11 推荐13 推荐15 推荐17 推荐19 推荐21 推荐23 推荐25 推荐27 推荐29 推荐31 推荐33 推荐35 推荐37 推荐39 推荐41 推荐43 推荐45 推荐47 推荐49 关键词1 关键词101 关键词201 关键词301 关键词401 关键词501 关键词601 关键词701 关键词801 关键词901 关键词1001 关键词1101 关键词1201 关键词1301 关键词1401 关键词1501 关键词1601 关键词1701 关键词1801 关键词1901 视频扩展1 视频扩展6 视频扩展11 视频扩展16 文章1 文章201 文章401 文章601 文章801 文章1001 资讯1 资讯501 资讯1001 资讯1501 标签1 标签501 标签1001 关键词1 关键词501 关键词1001 关键词1501 专题2001
mysql5.7.17安装配置方法图文教程(ubuntu16.04)
2020-11-09 20:40:25 责编:小采
文档


在MySQL官网上下载最新版的Ubuntu Linux专用的MySQL。我这里下载的是:

mysql-server_5.7.17-1ubuntu16.04_amd.deb-bundle.tar

也可从以下mirrors下载:

http://mirrors.sohu.com/mysql/MySQL-5.7/

解压文件 命令为:

代码如下:root@ubuntu:/fly/mysql# tar -xvf ../mysql-server_5.7.17-1ubuntu16.04_amd.deb-bundle.tar -C ./ 

解压开来后,一共有11个deb包,用sudo dpkg -i [包名]命令逐个安装,因为包与包中间存在依赖关系,这里安装有个先后顺序。

-rw-r--r--  1 7155 31415    841472 Nov 28 05:50 libmysqlclient20_5.7.17-1ubuntu16.04_amd.deb 
-rw-r--r--  1 7155 31415   11512 Nov 28 05:50 libmysqlclient-dev_5.7.17-1ubuntu16.04_amd.deb 
-rw-r--r--  1 7155 31415  17383814 Nov 28 05:50 libmysqld-dev_5.7.17-1ubuntu16.04_amd.deb 
-rw-r--r--  1 7155 31415     124 Nov 28 05:50 mysql-client_5.7.17-1ubuntu16.04_amd.deb 
-rw-r--r--  1 7155 31415     71282 Nov 28 05:50 mysql-common_5.7.17-1ubuntu16.04_amd.deb 
-rw-r--r--  1 7155 31415      6815 Nov 28 05:50 mysql-community_5.7.17-1ubuntu16.04_amd.changes 
-rw-r--r--  1 7155 31415   7357222 Nov 28 05:50 mysql-community-client_5.7.17-1ubuntu16.04_amd.deb 
-rw-r--r--  1 7155 31415  24698654 Nov 28 05:50 mysql-community-server_5.7.17-1ubuntu16.04_amd.deb 
-rw-r--r--  1 7155 31415 133305884 Nov 28 05:50 mysql-community-source_5.7.17-1ubuntu16.04_amd.deb 
-rw-r--r--  1 7155 31415  23384678 Nov 28 05:50 mysql-community-test_5.7.17-1ubuntu16.04_amd.deb 
-rw-r--r--  1 7155 31415     12636 Nov 28 05:50 mysql-server_5.7.17-1ubuntu16.04_amd.deb 
-rw-r--r--  1 7155 31415     12652 Nov 28 05:50 mysql-testsuite_5.7.17-1ubuntu16.04_amd.deb 

我的安装的顺序是:
1.mysql-common_5.7.17-1ubuntu16.04_amd.deb
2.libmysqlclient20_5.7.17-1ubuntu16.04_amd.deb
3.libmysqlclient-dev_5.7.17-1ubuntu16.04_amd.deb
4.libmysqld-dev_5.7.17-1ubuntu16.04_amd.deb

5.mysql-community-client_5.7.17-1ubuntu16.04_amd.deb
6.mysql-client_5.7.17-1ubuntu16.04_amd.deb
7.mysql-community-source_5.7.17-1ubuntu16.04_amd.deb

这里需要再安装一个依赖包叫libmecab2,安装好后,继续安装最后一个:
8.mysql-community-server_5.7.17-1ubuntu16.04_amd.deb
安装过程中需要设置数据库密码。
到这里,所有的已经安装完毕。输入Mysql -u root -p可以登陆数据库了。

root@ubuntu:/fly/mysql# dpkg -i mysql-common_5.7.17-1ubuntu16.04_amd.deb  
dpkg: warning: downgrading mysql-common from 5.7.17-1ubuntu16.10 to 5.7.17-1ubuntu16.04 
(Reading database ... 2124 files and directories currently installed.) 
Preparing to unpack mysql-common_5.7.17-1ubuntu16.04_amd.deb ... 
Unpacking mysql-common (5.7.17-1ubuntu16.04) over (5.7.17-1ubuntu16.10) ... 
Setting up mysql-common (5.7.17-1ubuntu16.04) ... 
root@ubuntu:/fly/mysql# dpkg -i libmysqlclient20_5.7.17-1ubuntu16.04_amd.deb  
dpkg: warning: downgrading libmysqlclient20:amd from 5.7.17-1ubuntu16.10 to 5.7.17-1ubuntu16.04 
(Reading database ... 2124 files and directories currently installed.) 
Preparing to unpack libmysqlclient20_5.7.17-1ubuntu16.04_amd.deb ... 
Unpacking libmysqlclient20:amd (5.7.17-1ubuntu16.04) over (5.7.17-1ubuntu16.10) ... 
Setting up libmysqlclient20:amd (5.7.17-1ubuntu16.04) ... 
Processing triggers for libc-bin (2.23-0ubuntu5) ... 
root@ubuntu:/fly/mysql# dpkg -i libmysqlclient-dev_5.7.17-1ubuntu16.04_amd.deb  
dpkg: warning: downgrading libmysqlclient-dev from 5.7.17-1ubuntu16.10 to 5.7.17-1ubuntu16.04 
(Reading database ... 2124 files and directories currently installed.) 
Preparing to unpack libmysqlclient-dev_5.7.17-1ubuntu16.04_amd.deb ... 
Unpacking libmysqlclient-dev (5.7.17-1ubuntu16.04) over (5.7.17-1ubuntu16.10) ... 
Setting up libmysqlclient-dev (5.7.17-1ubuntu16.04) ... 
Processing triggers for man-db (2.7.5-1) ... 
root@ubuntu:/fly/mysql# dpkg -i libmysqld-dev_5.7.17-1ubuntu16.04_amd.deb  
dpkg: warning: downgrading libmysqld-dev from 5.7.17-1ubuntu16.10 to 5.7.17-1ubuntu16.04 
(Reading database ... 2124 files and directories currently installed.) 
Preparing to unpack libmysqld-dev_5.7.17-1ubuntu16.04_amd.deb ... 
Unpacking libmysqld-dev (5.7.17-1ubuntu16.04) over (5.7.17-1ubuntu16.10) ... 
Setting up libmysqld-dev (5.7.17-1ubuntu16.04) ... 
root@ubuntu:/fly/mysql# dpkg -i mysql-community-client_5.7.17-1ubuntu16.04_amd.deb  
dpkg: warning: downgrading mysql-community-client from 5.7.17-1ubuntu16.10 to 5.7.17-1ubuntu16.04 
(Reading database ... 2124 files and directories currently installed.) 
Preparing to unpack mysql-community-client_5.7.17-1ubuntu16.04_amd.deb ... 
Unpacking mysql-community-client (5.7.17-1ubuntu16.04) over (5.7.17-1ubuntu16.10) ... 
Setting up mysql-community-client (5.7.17-1ubuntu16.04) ... 
Processing triggers for man-db (2.7.5-1) ... 
root@ubuntu:/fly/mysql# dpkg -i mysql-client_5.7.17-1ubuntu16.04_amd.deb  
dpkg: warning: downgrading mysql-client from 5.7.17-1ubuntu16.10 to 5.7.17-1ubuntu16.04 
(Reading database ... 2124 files and directories currently installed.) 
Preparing to unpack mysql-client_5.7.17-1ubuntu16.04_amd.deb ... 
Unpacking mysql-client (5.7.17-1ubuntu16.04) over (5.7.17-1ubuntu16.10) ... 
Setting up mysql-client (5.7.17-1ubuntu16.04) ... 
root@ubuntu:/fly/mysql# dpkg -i mysql-community-source_5.7.17-1ubuntu16.04_amd.deb  
dpkg: warning: downgrading mysql-community-source from 5.7.17-1ubuntu16.10 to 5.7.17-1ubuntu16.04 
(Reading database ... 2124 files and directories currently installed.) 
Preparing to unpack mysql-community-source_5.7.17-1ubuntu16.04_amd.deb ... 
Unpacking mysql-community-source (5.7.17-1ubuntu16.04) over (5.7.17-1ubuntu16.10) ... 
Setting up mysql-community-source (5.7.17-1ubuntu16.04) ... 
root@ubuntu:/fly/mysql# dpkg -i mysql-community-server_5.7.17-1ubuntu16.04_amd.deb  
Selecting previously unselected package mysql-community-server. 
(Reading database ... 2124 files and directories currently installed.) 
Preparing to unpack mysql-community-server_5.7.17-1ubuntu16.04_amd.deb ... 
Unpacking mysql-community-server (5.7.17-1ubuntu16.04) ... 
Setting up mysql-community-server (5.7.17-1ubuntu16.04) ... 
update-alternatives: using /etc/mysql/mysql.cnf to provide /etc/mysql/my.cnf (my.cnf) in auto mode 
Processing triggers for systemd (229-4ubuntu13) ... 
Processing triggers for ureadahead (0.100.0-19) ... 
Processing triggers for man-db (2.7.5-1) ... 
root@ubuntu:/fly/mysql# 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.17 MySQL Community Server (GPL) 
 
Copyright (c) 2000, 2016, 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简单安装方式:

1. sudo apt-get install mysql-server

2. apt-get isntall mysql-client

3.  sudo apt-get install libmysqlclient-dev

安装过程中会提示设置密码什么的,注意设置了不要忘了,安装完成之后可以使用如下命令来检查是否安装成功:

sudo netstat -tap | grep mysql

通过上述命令检查之后,如果看到有mysql 的socket处于 listen 状态则表示安装成功。

登陆mysql数据库可以通过如下命令:

mysql -u root -p

-u 表示选择登陆的用户名, -p 表示登陆的用户密码,上面命令输入之后会提示输入密码,此时输入密码就可以登录到mysql。

然后通过 show databases; 就可以查看当前的数据库。

我们选择 mysql数据库就行下一步操作,使用use mysql 命令,显示当前数据库的表单:show tables

mysql下如何执行sql脚本

mysql> create database mydatabase; 
Query OK, 1 row affected (0.00 sec) 
 
mysql> use mydatabase; 
Database changed 
mysql> source ./mysql.sql 
Query OK, 0 rows affected, 1 warning (0.00 sec) 
Query OK, 0 rows affected (0.00 sec) 
Query OK, 0 rows affected (0.33 sec) 
Records: 0 Duplicates: 0 Warnings: 0 
Query OK, 0 rows affected, 1 warning (0.00 sec) 
Query OK, 0 rows affected (0.00 sec) 
Query OK, 0 rows affected, 1 warning (0.00 sec) 
Query OK, 0 rows affected (0.04 sec) 
Query OK, 0 rows affected, 1 warning (0.00 sec) 
Query OK, 0 rows affected (0.00 sec) 
 
mysql> show tables; 

dpkg安装出现的问题:

安装mysql server时产生软件依赖问题:
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.
那就先安装上:
sudo apt -get install libmecab2
然后mysql-community-server,mysql-server就能正常使用了

在ubuntu下安装任何软件都提示以下错误:

You might want to run 'apt-get -f install' to correct these:
The following packages have unmet dependencies:
 kate : Depends: kdelibs4c2a (>= 4:3.5.9) but it is not going to be installed
        Depends: libqt3-mt (>= 3:3.3.8b) but it is not going to be installed
        Recommends: kregexpeditor but it is not installable
 kscope : Depends: kdelibs4c2a (>= 4:3.5.7-1) but it is not going to be installed
          Depends: libaudio2 but it is not going to be installed
          Depends: libqt3-mt (>= 3:3.3.8really3.3.7) but it is not going to be installed
          Depends: cscope but it is not going to be installed
          Depends: exuberant-ctags but it is not going to be installed
          Depends: graphviz but it is not going to be installed
E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).

解决方法:

     删除提示的kate和kscope两个未完全安装的软件。

 $sudo dpkg --purge kate
 $sudo dpkg --purge kscope

精彩专题分享:mysql不同版本安装教程 mysql5.7各版本安装教程 mysql5.6各版本安装教程

下载本文
显示全文
专题