Linux(Ubuntu)下Mysql5.6.28安装配置方法图文教程

mysql5.6.28安装配置方法

1.系统基本信息查看，尝试yum安装

$ sudo -s
# df -lh
Filesystem  Size Used Avail Use% Mounted on
/dev/vda1  79G 1.6G 74G 3% /
udev   3.9G 8.0K 3.9G 1% /dev
tmpfs   799M 252K 799M 1% /run
none   5.0M  0 5.0M 0% /run/lock
none   3.9G  0 3.9G 0% /run/shm
# uname -a
Linux nj01 3.16.0-34-generic #47~14.04.1-Ubuntu SMP Fri Apr 10 17:49:16 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux

# rpm -qa|grep yum
The program 'rpm' is currently not installed. You can install it by typing:
apt-get install rpm
# apt-get install rpm
……
# rpm -qa|grep yum
# yum install 
The program 'yum' is currently not installed. You can install it by typing:
apt-get install yum
# apt-get install yum
……
# yum install mysql
Setting up Install Process
No package mysql available.
Nothing to do

2.更换安装方式

# apt-get install mysql-server
Reading package lists... Done
Building dependency tree      
Reading state information... Done
The following extra packages will be installed:
  libdbd-mysql-perl libdbi-perl libhtml-template-perl libmysqlclient18 libnet-daemon-perl libplrpc-perl libterm-readkey-perl mysql-client-5.5
  mysql-client-core-5.5 mysql-common mysql-server-5.5 mysql-server-core-5.5
Suggested packages:
  libipc-sharedcache-perl tinyca mailx
The following NEW packages will be installed:
  libdbd-mysql-perl libdbi-perl libhtml-template-perl libmysqlclient18 libnet-daemon-perl libplrpc-perl libterm-readkey-perl mysql-client-5.5
  mysql-client-core-5.5 mysql-common mysql-server mysql-server-5.5 mysql-server-core-5.5
0 upgraded, 13 newly installed, 0 to remove and 15 not upgraded.
Need to get 27.6 MB of archives.
After this operation, 98.2 MB of additional disk space will be used.
Do you want to continue [Y/n]? y
Get:1 http://apt.wmcloud.com/ubuntu/ precise-updates/main mysql-common all 5.5.52-0ubuntu0.12.04.1 [12.6 kB]
Get:2 http://apt.wmcloud.com/ubuntu/ precise-updates/main libmysqlclient18 amd64 5.5.52-0ubuntu0.12.04.1 [952 kB]
Get:3 http://apt.wmcloud.com/ubuntu/ precise/main libnet-daemon-perl all 0.48-1 [43.1 kB]
Get:4 http://apt.wmcloud.com/ubuntu/ precise/main libplrpc-perl all 0.2025-2 [36.0 kB]
Get:5 http://apt.wmcloud.com/ubuntu/ precise/main libdbi-perl amd64 1.616-1build2 [849 kB]
Get:6 http://apt.wmcloud.com/ubuntu/ precise/main libdbd-mysql-perl amd64 4.020-1build2 [106 kB]
Get:7 http://apt.wmcloud.com/ubuntu/ precise-updates/main mysql-client-core-5.5 amd64 5.5.52-0ubuntu0.12.04.1 [1,948 kB]
Get:8 http://apt.wmcloud.com/ubuntu/ precise/main libterm-readkey-perl amd64 2.30-4build3 [28.6 kB]
Get:9 http://apt.wmcloud.com/ubuntu/ precise-updates/main mysql-client-5.5 amd64 5.5.52-0ubuntu0.12.04.1 [8,365 kB]
Get:10 http://apt.wmcloud.com/ubuntu/ precise-updates/main mysql-server-core-5.5 amd64 5.5.52-0ubuntu0.12.04.1 [6,327 kB]
Get:11 http://apt.wmcloud.com/ubuntu/ precise-updates/main mysql-server-5.5 amd64 5.5.52-0ubuntu0.12.04.1 [8,855 kB]
Get:12 http://apt.wmcloud.com/ubuntu/ precise/main libhtml-template-perl all 2.10-1 [65.0 kB]
Get:13 http://apt.wmcloud.com/ubuntu/ precise-updates/main mysql-server all 5.5.52-0ubuntu0.12.04.1 [10.8 kB]
Fetched 27.6 MB in 0s (38.2 MB/s)   
Preconfiguring packages ...
Selecting previously unselected package mysql-common.
(Reading database ... 77501 files and directories currently installed.)
Unpacking mysql-common (from .../mysql-common_5.5.52-0ubuntu0.12.04.1_all.deb) ...
Selecting previously unselected package libmysqlclient18.
Unpacking libmysqlclient18 (from .../libmysqlclient18_5.5.52-0ubuntu0.12.04.1_amd64.deb) ...
Selecting previously unselected package libnet-daemon-perl.
Unpacking libnet-daemon-perl (from .../libnet-daemon-perl_0.48-1_all.deb) ...
Selecting previously unselected package libplrpc-perl.
Unpacking libplrpc-perl (from .../libplrpc-perl_0.2025-2_all.deb) ...
Selecting previously unselected package libdbi-perl.
Unpacking libdbi-perl (from .../libdbi-perl_1.616-1build2_amd64.deb) ...
Selecting previously unselected package libdbd-mysql-perl.
Unpacking libdbd-mysql-perl (from .../libdbd-mysql-perl_4.020-1build2_amd64.deb) ...
Selecting previously unselected package mysql-client-core-5.5.
Unpacking mysql-client-core-5.5 (from .../mysql-client-core-5.5_5.5.52-0ubuntu0.12.04.1_amd64.deb) ...
Selecting previously unselected package libterm-readkey-perl.
Unpacking libterm-readkey-perl (from .../libterm-readkey-perl_2.30-4build3_amd64.deb) ...
Selecting previously unselected package mysql-client-5.5.
Unpacking mysql-client-5.5 (from .../mysql-client-5.5_5.5.52-0ubuntu0.12.04.1_amd64.deb) ...
Selecting previously unselected package mysql-server-core-5.5.
Unpacking mysql-server-core-5.5 (from .../mysql-server-core-5.5_5.5.52-0ubuntu0.12.04.1_amd64.deb) ...
Processing triggers for man-db ...
Setting up mysql-common (5.5.52-0ubuntu0.12.04.1) ...
Selecting previously unselected package mysql-server-5.5.
(Reading database ... 77879 files and directories currently installed.)
Unpacking mysql-server-5.5 (from .../mysql-server-5.5_5.5.52-0ubuntu0.12.04.1_amd64.deb) ...
Selecting previously unselected package libhtml-template-perl.
Unpacking libhtml-template-perl (from .../libhtml-template-perl_2.10-1_all.deb) ...
Selecting previously unselected package mysql-server.
Unpacking mysql-server (from .../mysql-server_5.5.52-0ubuntu0.12.04.1_all.deb) ...
Processing triggers for ureadahead ...
Processing triggers for man-db ...
Setting up libmysqlclient18 (5.5.52-0ubuntu0.12.04.1) ...
Setting up libnet-daemon-perl (0.48-1) ...
Setting up libplrpc-perl (0.2025-2) ...
Setting up libdbi-perl (1.616-1build2) ...
Setting up libdbd-mysql-perl (4.020-1build2) ...
Setting up mysql-client-core-5.5 (5.5.52-0ubuntu0.12.04.1) ...
Setting up libterm-readkey-perl (2.30-4build3) ...
Setting up mysql-client-5.5 (5.5.52-0ubuntu0.12.04.1) ...
Setting up mysql-server-core-5.5 (5.5.52-0ubuntu0.12.04.1) ...
Setting up mysql-server-5.5 (5.5.52-0ubuntu0.12.04.1) ...
160928 10:56:48 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
160928 10:56:48 [Note] /usr/sbin/mysqld (mysqld 5.5.52-0ubuntu0.12.04.1) starting as process 6166 ...
mysql start/running, process 6304
Setting up libhtml-template-perl (2.10-1) ...
Setting up mysql-server (5.5.52-0ubuntu0.12.04.1) ...
Processing triggers for libc-bin ...
ldconfig deferred processing now taking place

安装过程中输入root的密码即可；

3.安装成功，基本配置

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' identified by '******';
Query OK, 0 rows affected (0.00 sec)

mysql> 
mysql> 
mysql> 
mysql> 
mysql> 
mysql> create database testdb;
Query OK, 1 row affected (0.01 sec)

mysql> 
mysql> 
mysql> 
mysql> 
mysql> show databases;
+--------------------+
| Database   |
+--------------------+
| information_schema |
| mysql    |
| testdb    |
| performance_schema |
+--------------------+
4 rows in set (0.00 sec)

mysql> insert into mysql.user(Host,User,Password) values("%","test",password("******"));
Query OK, 1 row affected, 3 warnings (0.00 sec)

mysql> 
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> GRANT ALL PRIVILEGES ON testdb.* TO 'test'@'% identified by '******';
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

4.问题解决

（1）访问报错，网络连接报错：10038 ，telnet 不通
S1.关闭防火墙 # ufw allow 3306 ，还是不行
S2.用户网络权限已经给了（rant all privileges on . to ‘root'@'%' identified by ‘youpassword' with grant option;）
S3.查看网路信息 # netstat -ano
tcp 0 0 127.0.0.1:3306
应该是绑定IP问题，修改/etc/MySQL/my.conf
找到bind-address = 127.0.0.1这一行
改为bind-address = 0.0.0.0，问题解决。
（2）表区分大小写：
用root帐号登录后，在/etc/my.cnf 中的[mysqld]后添加添加lower_case_table_names=1，重启MYSQL服务，这时已设置成功：不区分表名的大小写；
lower_case_table_names参数详解：
lower_case_table_names = 0
其中 0：区分大小写，1：不区分大小写

5.基本服务命令

# 启动MySQL$ sudo service mysql start 
# 关闭MySQL$ sudo service mysql stop
# 重启MySQL$ sudo service mysql restart
# 其他命令：$ sudo /etc/init.d/mysql start
$ sudo /etc/init.d/mysql stop
$ sudo /etc/init.d/mysql restart

6.卸载Mysql：

sudo apt-get autoremove mysql* --purge
sudo apt-get remove apparmor
sudo apt-get install mysql-server mysql-common

卸载后删除mysql相关文件（/var/lib/mysql ， /etc/mysql等等，可以用 find -name mysql 查询下相关路径）

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

# Linux  # Ubuntu  # mysql5.6.28  # mysql5.6  # Ubuntu18.04(linux)安装MySQL的方法步骤  # Linux下mysql 8.0安装教程  # linux上免安装版MySQL5.7.18的教程详解  # Linux下MySQL5.7.18 yum方式从卸载到安装过程图解  # Oracle Linux 6.8安装 mysql 5.7.17的详细教程  # 使用YUM在Linux(CentOS 7)下安装mysql 5.7.18的教程详解  # linux系统ubuntu18.04安装mysql 5.7  # Linux yum 命令安装mysql8.0的教程详解  # Linux下mysql 8.0.15 安装配置图文教程以及修改密码  # linux安装mysql 8.0.x的完整步骤  # 报错  # 重启  # 可以用  # 帐号  # 给了  # 绑定  # 大家多多  # 这一行  # 过程中  # 基本配置  # 已设置  # 应该是  # 网路  # sharedcache  # mailx  # tinyca  # libipc  # common  # core  # Suggested 

相关文章： Swift开发中switch语句值绑定模式  西安大型网站制作公司,西安招聘网站最好的是哪个？  青浦网站制作公司有哪些,苹果官网发货地是哪里？  网站按钮制作软件,如何实现网页中按钮的自动点击？  如何通过IIS搭建网站并配置访问权限？  官网网站制作腾讯审核要多久,联想路由器newifi官网  定制建站方案优化指南：企业官网开发与建站费用解析  专业的网站制作设计是什么,如何制作一个企业网站，建设网站的基本步骤有哪些？  在线教育网站制作平台,山西立德教育官网？  javascript中的try catch异常捕获机制用法分析  如何用西部建站助手快速创建专业网站？  学校建站服务器如何选型才能满足性能需求？  如何快速搭建高效WAP手机网站吸引移动用户？  如何在阿里云通过域名搭建网站？  子杰智能建站系统｜零代码开发与AI生成SEO优化指南  可靠的网站设计制作软件,做网站设计需要什么样的电脑配置？  如何在西部数码注册域名并快速搭建网站？  如何在宝塔面板创建新站点？  建站之星后台密码遗忘或太弱？如何重置与强化？  如何快速查询网址的建站时间与历史轨迹？  制作网站哪家好,cc、.co、.cm哪个域名更适合做网站？  建站之星伪静态规则如何设置？  如何在阿里云ECS服务器部署织梦CMS网站？  建站主机SSH密钥生成步骤及常见问题解答？  湖南网站制作公司,湖南上善若水科技有限公司做什么的？  如何通过宝塔面板实现本地网站访问？  建站之星如何快速更换网站模板？  深圳网站制作设计招聘,关于服装设计的流行趋势，哪里的资料比较全面？  设计网站制作公司有哪些,制作网页教程？  高端建站如何打造兼具美学与转化的品牌官网？  红河网站制作公司,红河事业单位身份证如何上传？  专业商城网站制作公司有哪些,pi商城官网是哪个？  英语简历制作免费网站推荐,如何将简历翻译成英文？  南宁网站建设制作定制,南宁网站建设可以定制吗？  c# 在ASP.NET Core中管理和取消后台任务  建站之星后台密码遗忘如何找回？  长沙做网站要多少钱,长沙国安网络怎么样？  盐城做公司网站,江苏电子版退休证办理流程？  制作公司内部网站有哪些,内网如何建网站？  美食网站链接制作教程视频,哪个教做美食的网站比较专业点？  图册素材网站设计制作软件,图册的导出方式有几种？  电视网站制作tvbox接口,云海电视怎样自定义添加电视源？  网站制作费用多少钱,一个网站的运营，需要哪些费用？  SAX解析器是什么，它与DOM在处理大型XML文件时有何不同？  网站制作知乎推荐,想做自己的网站用什么工具比较好？  网页设计与网站制作内容,怎样注册网站？  北京网站制作费用多少,建立一个公司网站的费用.有哪些部分,分别要多少钱？  建站之星如何保障用户数据免受黑客入侵？  如何在阿里云部署织梦网站？  如何用PHP工具快速搭建高效网站？