发布于 2017-01-26 15:46:28 | 252 次阅读 | 评论: 0 | 来源: 网友投递

这里有新鲜出炉的Mysql教程,程序狗速度看过来!

Mysql关系型数据库管理系统

MySQL是一个开放源码的小型关联式数据库管理系统,开发者为瑞典MySQL AB公司。MySQL被广泛地应用在Internet上的中小型网站中。由于其体积小、速度快、总体拥有成本低,尤其是开放源码这一特点,许多中小型网站为了降低网站总体拥有成本而选择了MySQL作为网站数据库。


这篇文章主要为大家分享了ubuntu 16.04下mysql 5.7.17 安装配置方法图文教程,具有一定的参考价值,感兴趣的小伙伴们可以参考一下

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

mysql-server_5.7.17-1ubuntu16.04_amd64.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_amd64.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_amd64.deb 
-rw-r--r--  1 7155 31415   1189512 Nov 28 05:50 libmysqlclient-dev_5.7.17-1ubuntu16.04_amd64.deb 
-rw-r--r--  1 7155 31415  17383814 Nov 28 05:50 libmysqld-dev_5.7.17-1ubuntu16.04_amd64.deb 
-rw-r--r--  1 7155 31415     12644 Nov 28 05:50 mysql-client_5.7.17-1ubuntu16.04_amd64.deb 
-rw-r--r--  1 7155 31415     71282 Nov 28 05:50 mysql-common_5.7.17-1ubuntu16.04_amd64.deb 
-rw-r--r--  1 7155 31415      6815 Nov 28 05:50 mysql-community_5.7.17-1ubuntu16.04_amd64.changes 
-rw-r--r--  1 7155 31415   7357222 Nov 28 05:50 mysql-community-client_5.7.17-1ubuntu16.04_amd64.deb 
-rw-r--r--  1 7155 31415  24698654 Nov 28 05:50 mysql-community-server_5.7.17-1ubuntu16.04_amd64.deb 
-rw-r--r--  1 7155 31415 133305884 Nov 28 05:50 mysql-community-source_5.7.17-1ubuntu16.04_amd64.deb 
-rw-r--r--  1 7155 31415  23384678 Nov 28 05:50 mysql-community-test_5.7.17-1ubuntu16.04_amd64.deb 
-rw-r--r--  1 7155 31415     12636 Nov 28 05:50 mysql-server_5.7.17-1ubuntu16.04_amd64.deb 
-rw-r--r--  1 7155 31415     12652 Nov 28 05:50 mysql-testsuite_5.7.17-1ubuntu16.04_amd64.deb 

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

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

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

root@ubuntu:/fly/mysql# dpkg -i mysql-common_5.7.17-1ubuntu16.04_amd64.deb  
dpkg: warning: downgrading mysql-common from 5.7.17-1ubuntu16.10 to 5.7.17-1ubuntu16.04 
(Reading database ... 212644 files and directories currently installed.) 
Preparing to unpack mysql-common_5.7.17-1ubuntu16.04_amd64.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_amd64.deb  
dpkg: warning: downgrading libmysqlclient20:amd64 from 5.7.17-1ubuntu16.10 to 5.7.17-1ubuntu16.04 
(Reading database ... 212644 files and directories currently installed.) 
Preparing to unpack libmysqlclient20_5.7.17-1ubuntu16.04_amd64.deb ... 
Unpacking libmysqlclient20:amd64 (5.7.17-1ubuntu16.04) over (5.7.17-1ubuntu16.10) ... 
Setting up libmysqlclient20:amd64 (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_amd64.deb  
dpkg: warning: downgrading libmysqlclient-dev from 5.7.17-1ubuntu16.10 to 5.7.17-1ubuntu16.04 
(Reading database ... 212644 files and directories currently installed.) 
Preparing to unpack libmysqlclient-dev_5.7.17-1ubuntu16.04_amd64.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_amd64.deb  
dpkg: warning: downgrading libmysqld-dev from 5.7.17-1ubuntu16.10 to 5.7.17-1ubuntu16.04 
(Reading database ... 212644 files and directories currently installed.) 
Preparing to unpack libmysqld-dev_5.7.17-1ubuntu16.04_amd64.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_amd64.deb  
dpkg: warning: downgrading mysql-community-client from 5.7.17-1ubuntu16.10 to 5.7.17-1ubuntu16.04 
(Reading database ... 212644 files and directories currently installed.) 
Preparing to unpack mysql-community-client_5.7.17-1ubuntu16.04_amd64.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_amd64.deb  
dpkg: warning: downgrading mysql-client from 5.7.17-1ubuntu16.10 to 5.7.17-1ubuntu16.04 
(Reading database ... 212644 files and directories currently installed.) 
Preparing to unpack mysql-client_5.7.17-1ubuntu16.04_amd64.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_amd64.deb  
dpkg: warning: downgrading mysql-community-source from 5.7.17-1ubuntu16.10 to 5.7.17-1ubuntu16.04 
(Reading database ... 212644 files and directories currently installed.) 
Preparing to unpack mysql-community-source_5.7.17-1ubuntu16.04_amd64.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_amd64.deb  
Selecting previously unselected package mysql-community-server. 
(Reading database ... 212644 files and directories currently installed.) 
Preparing to unpack mysql-community-server_5.7.17-1ubuntu16.04_amd64.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

以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持PHPERZ。



相关阅读 :
mysql 5.7.17 安装配置方法图文教程(ubuntu 16.04)
mysql 5.7.17 安装配置方法图文教程(windows10)
mysql 5.7.16 安装配置方法图文教程(ubuntu 16.04)
Windows10下mysql 5.7.17 安装配置方法图文教程
mysql 5.7.30安装配置方法图文教程
mysql 5.7.13 安装配置方法图文教程(linux)
mysql 5.7.13 安装配置方法图文教程(win10)
mysql 5.7.10 安装配置方法图文教程
最全的mysql 5.7.13 安装配置方法图文教程(linux) 强烈推荐!
mysql 5.7.14 安装配置方法图文教程
mysql 5.7.15 安装配置方法图文教程
mysql 5.7.18 安装配置方法图文教程(CentOS7)
最新网友评论  共有(0)条评论 发布评论 返回顶部

Copyright © 2007-2017 PHPERZ.COM All Rights Reserved   冀ICP备14009818号  版权声明  广告服务