首页 / LINUX / Linux系统上安装MySQL5.6

Linux系统上安装MySQL5.6

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了Linux系统上安装MySQL5.6，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含10496字，纯文字阅读大概需要15分钟。

内容图文

安装环境 : 软件版本位数 MySQL 5.6.22 32 CentOS 6.4 32 VMware 9.0.1 32 Mysql官方下载地址，可以根据当前系统自动识别适合当前系统版本的mysql版本： http://dev.mysql.com/downloads/mysql/ 官网比较慢，百度云盘包含32位和64位的： http://pan.baidu.

安装环境 :

软件	版本	位数
MySQL	5.6.22	32
CentOS	6.4	32
VMware	9.0.1	32

Mysql官方下载地址，可以根据当前系统自动识别适合当前系统版本的mysql版本：

http://dev.mysql.com/downloads/mysql/

官网比较慢，百度云盘包含32位和64位的：

http://pan.baidu.com/s/1sj6YeJj

一，卸载自带mysql，删除MySQL的lib库，服务文件

[root@localhost  ~]# yum remove mysql mysql-server mysql-libs

如果之前安装过，则执行rpm -ev进行删除，删除失败，则是有依赖项，则先删除依赖项

[root@localhost ~]# rpm -ev MySQL-server-5.0.22-0.i386
[root@localhost ~]# rpm -ev MySQL-client-5.0.22-0.i386

清除所有mysql相关文件：

[root@localhost ~]#find / -name mysql
[root@localhost ~]#rm -rf 文件或者文件夹

查看是否有残留文件：

[root@localhost ~]#rpm -qa | grep -i mysql

执行命令卸载MySQL相关的文件

[root@localhost ~]# yum -y remove MySQL*

二，安装MySQL

1.复制mysql安装包到安装目录

[root@localhost opt]# mkdir mysql
[root@localhost opt]# cp /home/duke147/Desktop/Tools/MySQL-5.6.22-1.linux_glibc2.5.i386.rpm-bundle.tar /opt/mysql/
[root@localhost opt]# cd mysql/
[root@localhost mysql]# ls -a 
.  ..  MySQL-5.6.22-1.linux_glibc2.5.i386.rpm-bundle.tar

2.解压安装包

[root@localhost mysql]# tar xvf MySQL-5.6.22-1.linux_glibc2.5.i386.rpm-bundle.tar
MySQL-test-5.6.22-1.linux_glibc2.5.i386.rpm                   #MySQL的测试组件
MySQL-shared-5.6.22-1.linux_glibc2.5.i386.rpm                 #MySQL的共享库
MySQL-shared-compat-5.6.22-1.linux_glibc2.5.i386.rpm          #MySQL版本兼容的包
MySQL-client-5.6.22-1.linux_glibc2.5.i386.rpm                 #MySQL客户端程序
MySQL-devel-5.6.22-1.linux_glibc2.5.i386.rpm                  #MySQL的库和头文件
MySQL-embedded-5.6.22-1.linux_glibc2.5.i386.rpm               #MySQL的嵌入式程序
MySQL-server-5.6.22-1.linux_glibc2.5.i386.rpm                 #MySQL服务端程序

3.安装服务端

[root@localhost mysql]# rpm -ivh MySQL-server-5.6.22-1.linux_glibc2.5.i386.rpm
Preparing...                ########################################### [100%]
   1:MySQL-server           ########################################### [100%]
2014-12-18 21:08:42 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2014-12-18 21:08:42 4959 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2014-12-18 21:08:42 4959 [Note] InnoDB: The InnoDB memory heap is disabled
2014-12-18 21:08:42 4959 [Note] InnoDB: Mutexes and rw_locks use InnoDB's own implementation
2014-12-18 21:08:42 4959 [Note] InnoDB: Memory barrier is not used
2014-12-18 21:08:42 4959 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-12-18 21:08:42 4959 [Note] InnoDB: Using Linux native AIO
2014-12-18 21:08:42 4959 [Note] InnoDB: Not using CPU crc32 instructions
2014-12-18 21:08:42 4959 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-12-18 21:08:42 4959 [Note] InnoDB: Completed initialization of buffer pool
2014-12-18 21:08:42 4959 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
2014-12-18 21:08:42 4959 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
2014-12-18 21:08:42 4959 [Note] InnoDB: Database physically writes the file full: wait...
2014-12-18 21:08:42 4959 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2014-12-18 21:08:43 4959 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2014-12-18 21:08:44 4959 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2014-12-18 21:08:44 4959 [Warning] InnoDB: New log files created, LSN=45781
2014-12-18 21:08:44 4959 [Note] InnoDB: Doublewrite buffer not found: creating new
2014-12-18 21:08:44 4959 [Note] InnoDB: Doublewrite buffer created
2014-12-18 21:08:44 4959 [Note] InnoDB: 128 rollback segment(s) are active.
2014-12-18 21:08:44 4959 [Warning] InnoDB: Creating foreign key constraint system tables.
2014-12-18 21:08:44 4959 [Note] InnoDB: Foreign key constraint system tables created
2014-12-18 21:08:44 4959 [Note] InnoDB: Creating tablespace and datafile system tables.
2014-12-18 21:08:44 4959 [Note] InnoDB: Tablespace and datafile system tables created.
2014-12-18 21:08:44 4959 [Note] InnoDB: Waiting for purge to start
2014-12-18 21:08:44 4959 [Note] InnoDB: 5.6.22 started; log sequence number 0
A random root password has been set. You will find it in '/root/.mysql_secret'.
2014-12-18 21:08:45 4959 [Note] Binlog end
2014-12-18 21:08:45 4959 [Note] InnoDB: FTS optimize thread exiting.
2014-12-18 21:08:45 4959 [Note] InnoDB: Starting shutdown...
2014-12-18 21:08:46 4959 [Note] InnoDB: Shutdown completed; log sequence number 1625977

2014-12-18 21:08:46 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2014-12-18 21:08:46 4982 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2014-12-18 21:08:46 4982 [Note] InnoDB: The InnoDB memory heap is disabled
2014-12-18 21:08:46 4982 [Note] InnoDB: Mutexes and rw_locks use InnoDB's own implementation
2014-12-18 21:08:46 4982 [Note] InnoDB: Memory barrier is not used
2014-12-18 21:08:46 4982 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-12-18 21:08:46 4982 [Note] InnoDB: Using Linux native AIO
2014-12-18 21:08:46 4982 [Note] InnoDB: Not using CPU crc32 instructions
2014-12-18 21:08:46 4982 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-12-18 21:08:46 4982 [Note] InnoDB: Completed initialization of buffer pool
2014-12-18 21:08:46 4982 [Note] InnoDB: Highest supported file format is Barracuda.
2014-12-18 21:08:46 4982 [Note] InnoDB: 128 rollback segment(s) are active.
2014-12-18 21:08:46 4982 [Note] InnoDB: Waiting for purge to start
2014-12-18 21:08:46 4982 [Note] InnoDB: 5.6.22 started; log sequence number 1625977
2014-12-18 21:08:46 4982 [Note] Binlog end
2014-12-18 21:08:46 4982 [Note] InnoDB: FTS optimize thread exiting.
2014-12-18 21:08:46 4982 [Note] InnoDB: Starting shutdown...
2014-12-18 21:08:48 4982 [Note] InnoDB: Shutdown completed; log sequence number 1625987

A RANDOM PASSWORD HAS BEEN SET FOR THE MySQL root USER !
You will find that password in '/root/.mysql_secret'.

#你可以找从/root/.mysql_secret中找到root用户的随机密码。

You must change that password on your first connect,
no other statement but 'SET PASSWORD' will be accepted.
See the manual for the semantics of the 'password expired' flag.

Also, the account for the anonymous user has been removed.

In addition, you can run:

  /usr/bin/mysql_secure_installation

which will also give you the option of removing the test database.
This is strongly recommended for production servers.

See the manual for more instructions.

Please report any problems at http://bugs.mysql.com/

The latest information about MySQL is available on the web at

  http://www.mysql.com

Support MySQL by buying support/licenses at http://shop.mysql.com

New default config file was created as /usr/my.cnf and
will be used by default by the server when you start it.
You may edit this file to change server settings

4.查看，安装客户端，库文件

[root@localhost mysql]# rpm -qa | grep -i mysql
MySQL-server-5.6.22-1.linux_glibc2.5.i386
[root@localhost mysql]# rpm -ivh MySQL-client-5.6.22-1.linux_glibc2.5.i386.rpm
Preparing...                ########################################### [100%]
   1:MySQL-client           ########################################### [100%]
[root@localhost mysql]# rpm -ivh MySQL-devel-5.6.22-1.linux_glibc2.5.i386.rpm 
Preparing...                ########################################### [100%]
   1:MySQL-devel            ########################################### [100%]

MySQL默认安装路径：

a.数据库目录： /var/lib/mysql/
b.配置文件： /usr/share/mysql
c.相关命令： /usr/bin
d.启动脚本： /etc/rc.d/init.d/

5.修改配置文件，将MySQL的配置文件拷贝到/etc目录下。

[root@localhost mysql]# cp /usr/share/mysql/my-default.cnf /etc/my.cnf

#如果使用默认配置，则不需要进行修改

[root@localhost mysql]# vi /etc/my.cnf

6.初始化MySQL

[root@localhost mysql]# /usr/bin/mysql_install_db

7.启动MySQL

[root@localhost mysql]# service mysql start
Starting MySQL.... SUCCESS!

检测mysql 3306是否安打开

[root@localhost mysql]# netstat -nat
tcp        0      0 :::3306                     :::*                        LISTEN

8.查看root账号初始信息

[root@localhost mysql]# cat /root/.mysql_secret
# The random password set for the root user at Thu Dec 18 21:08:44 2014 (local time): vuN8xfuKTRnmqX3I

9.使用默认密码登陆mysql

[root@localhost mysql]# mysql -u root -pvuN8xfuKTRnmqX3I
Warning: Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.6.22

Copyright (c) 2000, 2014, 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> set password = password('123456');
Query OK, 0 rows affected (0.02 sec)

退出mysql

mysql> quit;
Bye

10.添加自启动服务

[root@localhost ~]# chkconfig --add mysql
[root@localhost ~]# chkconfig mysql on

11.配置远程访问

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
Query OK, 0 rows affected (0.01 sec)

刷新权限

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

配置单个IP访问权限，*.* 指【数据库.表】：

mysql > GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.56' IDENTIFIED BY '123456' WITH GRANT OPTION;flush privileges;

关闭防火墙

[root@localhost ~]# service iptables stop
iptables: Flushing firewall rules:                         [  OK  ]
iptables: Setting chains to policy ACCEPT: filter          [  OK  ]
iptables: Unloading modules:                               [  OK  ]
[root@localhost ~]# service iptables status
iptables: Firewall is not running.

修改密码

mysql> use mysql;
mysql> update user set password=password('123456') where user='root';
mysql> flush privileges;

查看数据库

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

内容总结

以上是互联网集市为您收集整理的Linux系统上安装MySQL5.6全部内容，希望文章能够帮你解决Linux系统上安装MySQL5.6所遇到的程序开发问题。如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容，请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

扫描二维码推送至手机访问。

本文链接：https://qyyshop.com/info/564086.html

来源：【匿名】

【上一篇】linux下彻底卸载mysql图解教程【下一篇】Linux下安装GD

更多 ►

【Linux系统上安装MySQL5.6】教程文章相关的互联网学习教程文章

linux mysql5.6版本的安装配置过程

从今年3月份开始mysql官网开始发布相关的5.6系列的各个版本，对于mysql5.6系列的版本对一起的版本进行了全局性的细节性加强；个人感觉，以下是在虚拟机中配置的mysql5.6.10源码安装的过程分享记录下： [root@mysql5 ~]# groupadd mysql [root@mysql5 ~]# useradd -r -g mysql mysql [root@mysql5 ~]# ls anaconda-ks.cfg install.log install.log.syslog mysql-5.6.10.tar.gz [root@mysql5 ~]# cd /usr/local/ [root@mysql5 local]...

linux安装mysql5.6【代码】

linux安装mysql5.62021-04-25 1、先检查系统是否安装有mysqlyum list installed | grep mysql rpm –qa|grep mysql*2、下载mysql安装包装# 下载noarch.rpm wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm # 这个rpm还不是mysql的安装文件，只是两个yum源文件，执行后，在/etc/yum.repos.d/ 这个目录下多出mysql-community-source.repo和mysql-community.repo rpm -ivh mysql-community-release-el7-5.no...

linux-centos7安装mysql5.6【代码】【图】

环境： 1、操作系统：Centos 7.2 2、安装版本： mysql-5.6.43-linux-glibc2.12-x86_64.tar.gz 3、下载方式：官网下载即可：https://dev.mysql.com/downloads/ 4、说明：Linux下MySQL5.6与MySQL5.7安装方法略有不一样安装步骤1、查看并卸载老版本MySQL 查找并删除mysql有关的文件find / -name mysql rm -rf 上边查找到的路径，多个路径用空格隔开 #或者下边一条命令即可 find / -name mysql|xargs rm -rf说明：/usr/local/mysql 为...

LINUX6.5 + MYSQL5.6 + JIRA6.3 + CONFLUENCE5.9

#================MYSQL============================= [root@localhost Desktop]# /sbin/ifup eth0[root@localhost Desktop]# service network restart[root@localhost ~]# rpm -qa | grep mysqlmysql-libs-5.1.71-1.el6.x86_64[root@localhost ~]# rpm -e --nodeps mysql-libs-5.1.71-1.el6.x86_64[root@localhost ~]# cd /usr/tmp/[root@localhost tmp]# lltotal 221112-rwsrwsrwt. 1 root root 226416640 May 21 07:51 MyS...

Linux下MySQL5.6的修改字符集编码为UTF8

Linux安装mysql5.6【图】

系统环境：Centos 7第一步：下载mysql版本　　下载最新版本:https://www.mysql.com/downloads/　　下载历史版本:https://downloads.mysql.com/archives/community/第二步：上传下载的mysql软件到/usr/local/第三步：解压mysql软件到/usr/local/mysql　　>cd /usr/local/　　>tar -xvzf mysql.tar.gz -C /usr/local/mysql第四步：创建数据目录　　>mkdir /data/mysql/data　　>mkdir /data/mysql/logs　　>mkdir /data/mysql/tmp第五...

原版乐彩源码分享,最新php+mysql时时平台带开奖器和数据库mysql5.7源码安装linuxmysql源码安装mysql5.6源码包下【图】

原版乐彩源码分享,最新php+mysql时时平台带开奖器和数据库，给有需要的朋友。本人提供一站式服务：联系QQ:2 3 6 0 2 4 8666(私聊)以上就介绍了原版乐彩源码分享,最新php+mysql时时平台带开奖器和数据库，包括了Mysql,源码分享方面的内容，希望对PHP教程有兴趣的朋友有所帮助。

linux环境下安装mysql5.6，linuxmysql5.6_PHP教程

linux 环境下安装mysql5.6，linuxmysql5.6在网上找了很多博客看着头晕眼花各个步骤最终功夫不负有心人终于安装好了特此整理分享一下1> #yum remove mysql mysql-* //卸载原先版本的mysql 2>#yum install -y wget //如果没有下载wget 3># wget http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm //下载5.6的依赖源配置repo rpm文件 4>#rpm -ivh mysql-community-release-el6-5.noa...

Linux centos5.6版本下mysql5.6主从环境安装配置【代码】

MySQL数据库支持数据库的主从复制功能，因此在集群方面具有其独特的优势，国内外大型网站架构体系中，均采用了MySQL的主从数据库配置来实现查询负载、数据库热备等功能。本人在此将如何配置实现做了个简单小结。服务器配置，具体iP，主从库如下主库 IP：192.168.1.189 master server 从库 IP：192.168.1.188 slave server 服务器系统为:centos5.6，下载安装软件包具体包括如下 MySQL-client-5.6.13-1.linux_glibc2.5.x86_64.rpm ...

Linux centos5.6版本下mysql5.6主从环境安装配置【代码】

服务器配置，具体iP，主从库如下主库 IP：192.168.1.189 master server 从库 IP：192.168.1.188 slave server 服务器系统为:centos5.6，下载安装软件包具体包括如下 MySQL-client-5.6.13-1.linux_glibc2.5.x86_64.rpm MySQL-devel-5.6.13-1.linux_glibc2.5.x86_64.rpm MySQL-server-5.6.13-1.linux_glibc2.5.x86_64.rpm MySQL-shared-5.6.13-1.linux_glibc2.5.x86_64.rpm MySQL-shared-compat-5.6.13-1.linux_glibc2.5.x86_64.r...

Linux下安装mysql5.6

Rhel6.5+ cmake-2.8.10.2 + mysql-5.6.16 Cmake下载地址：http://www.cmake.org/filesMysql下载地址：http://pan.baidu.com/s/1bno9Cz9 密码：kayn 准备工作：检测gcc 、gcc-c++ 、 ncurses-devel 、perl工具与库是否已经安装。检测命令：rpm –qa | grep [ gcc 、gcc-c++、ncurses-devel、perl ]若没有安装，可使用命令：yum –y install完成安装。 1、编译安装cmake：tarzxf cmake-2.8.10.2.tar.gzcdcmake-2.8.10.2./bootstrap&...

Linux_RedHat下 RPM方式安装MySQL5.6

MySQL-5.6.25-1.linux_glibc2.5.i386.rpm-bundle.tar；a. 检查MySQL及相关RPM包，是否安装，如果有安装，则移除（rpm –e 名称）1[root@localhost~]#rpm -qa | grep -i mysql2mysql-libs-5.1.66-2.el6_3.x86_643[root@localhost~]#yum -y remove mysql-libs*b. 下载Linux对应的RPM包，如下：1[root@localhostrpm]#ll2total743643-rw-r--r--.1 root root 18442536 Dec 11 20:19 MySQL-client-5.6.15-1.el6.x86_64.rpm4-rw-r--r--.1 ...

Linux RedHat 6.4 MySQL5.6源码包安装

1、查询系统中已安装的MySQL相关软件包 [root@MySQL ~]# rpm -qa|grep -i mysql2、如果MySQL已开启，停止运行MySQL服务器 [root@MySQL ~]#service mysqld stop 3、卸载系统包[root@MySQL ~]# rpm -e perl-DBD-MySQL-4.013-3.el6.x86_64 --nodeps[root@MySQL ~]# rpm -e mysql-libs-5.1.66-2.el6_3.x86_64 --nodeps[root@MySQL ~]# rpm -e qt-mysql-4.6.2-25.el6.x86_64 --nodeps二、安装编译1、MySQL编译依赖（1）...

linux 下安装mysql5.6 -bundle.tar

下载页面：http://dev.mysql.com/downloads/mysql/此处选择“Red Hat Enterprise Linux 6 / Oracle Linux 6 (x86, 32-bit), RPM Bundle”下载，下载至/root/Downloads/目录下，下载文件名为“MySQL-5.6.15-1.el6.i686.rpm-bundle.tar”2. 解压tar包cd /root/Downloads/tar -xvf MySQL-5.6.15-1.el6.i686.rpm-bundle.tar3. 以RPM方式安装MySQL在RHEL系统中，必须先安装“MySQL-shared-compat-5.6.15-1.el6.i686.rpm”这个兼容包，然...

linux下mysql5.6 rpm包安装【图】

下载对应linux版本的rpm安装包地址(http://downloads.mysql.com/archives/community/)此例使用的是CentOS6.5 32位的linux。下载的对应安装包如下：说明： MySQL-server是基础的服务软件，MySQL-client是客户端命令软件，我们需要用客户端命令登录MySQL修改默认密码等操作，所以这两个是必须下载安装的。2.开始安装下载完成后通过工具上传到linux上。下载的两个的安装包名为MySQL-server-5.6.15-1.el6.i686.rpmMySQL-client-5.6.15-...

LINUX - 最热教程

Xrdp - 通过Windows的RDP连接Linux远程...VMware中Linux虚拟机挂载主机共享文件夹...Linux双网卡配置虚拟机下Linux安装好Nginx后，宿主机无...linux下安装postgresql并配置远程图形桌...Linux命令--exportfs命令详解 linux 终端printf打印显示乱码问题修正 Linux下Shell的for循环语句N种写法 Linux下创建nginx脚本-start、stop、re...SUSELinux安装MySQL

首页 / LINUX / Linux系统上安装MySQL5.6

Linux系统上安装MySQL5.6

内容导读

内容图文

内容总结

内容备注

内容手机端

【Linux系统上安装MySQL5.6】教程文章相关的互联网学习教程文章

linux mysql5.6版本的安装配置过程

linux安装mysql5.6【代码】

linux-centos7安装mysql5.6【代码】【图】

LINUX6.5 + MYSQL5.6 + JIRA6.3 + CONFLUENCE5.9

Linux下MySQL5.6的修改字符集编码为UTF8

Linux安装mysql5.6【图】

原版乐彩源码分享,最新php+mysql时时平台带开奖器和数据库mysql5.7源码安装linuxmysql源码安装mysql5.6源码包下【图】

linux环境下安装mysql5.6，linuxmysql5.6_PHP教程

Linux centos5.6版本下mysql5.6主从环境安装配置【代码】

Linux centos5.6版本下mysql5.6主从环境安装配置【代码】

Linux下安装mysql5.6

Linux_RedHat下 RPM方式安装MySQL5.6

Linux RedHat 6.4 MySQL5.6源码包安装

linux 下安装mysql5.6 -bundle.tar

linux下mysql5.6 rpm包安装【图】

LINUX - 相关标签

安装 - 相关标签

LINUX - 最新教程

LINUX - 最热教程