首页 / LINUX / linux mysql5.6版本的安装配置过程

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

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了linux mysql5.6版本的安装配置过程，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含7907字，纯文字阅读大概需要12分钟。

内容图文

从今年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]# ls
bin etc games include lib libexec sbin share src
[root@mysql5 local]# cp /root/mysql-5.6.10.tar.gz /usr/local/
[root@mysql5 local]# ll
total 34468
drwxr-xr-x 2 root root 4096 Jan 27 2010 bin
drwxr-xr-x 2 root root 4096 Jan 27 2010 etc
drwxr-xr-x 2 root root 4096 Jan 27 2010 games
drwxr-xr-x 2 root root 4096 Jan 27 2010 include
drwxr-xr-x 2 root root 4096 Jan 27 2010 lib
drwxr-xr-x 2 root root 4096 Jan 27 2010 libexec
-rw-r--r-- 1 root root 35174149 Apr 17 00:55 mysql-5.6.10.tar.gz
drwxr-xr-x 2 root root 4096 Jan 27 2010 sbin
drwxr-xr-x 4 root root 4096 Apr 17 00:32 share
drwxr-xr-x 2 root root 4096 Jan 27 2010 src
[root@mysql5 local]# tar -zxvf mysql-5.6.10.tar.gz
[root@mysql5 local]# cd mysql-5.6.10
cmake .
make && make install
[root@mysql5 mysql-5.6.10]# chown -R mysql.mysql /usr/local/mysql
[root@mysql5 mysql-5.6.10]#
[root@mysql5 mysql-5.6.10]# cd /usr/local/mysql/scripts/
[root@mysql5 scripts]# ./mysql_install_db --user=mysql --basedir=/usr/local/mys
ql --datadir=/usr/local/mysql/data
Installing MySQL system tables...2013-04-17 01:26:58 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2013-04-17 01:26:58 18715 [Note] InnoDB: The InnoDB memory heap is disabled
2013-04-17 01:26:58 18715 [Note] InnoDB: Mutexes and rw_locks use InnoDB‘s own implementation
2013-04-17 01:26:58 18715 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-04-17 01:26:58 18715 [Note] InnoDB: CPU does not support crc32 instructions
2013-04-17 01:26:58 18715 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2013-04-17 01:26:58 18715 [Note] InnoDB: Completed initialization of buffer pool
2013-04-17 01:26:58 18715 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
2013-04-17 01:26:59 18715 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
2013-04-17 01:26:59 18715 [Note] InnoDB: Database physically writes the file full: wait...
2013-04-17 01:26:59 18715 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2013-04-17 01:26:59 18715 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2013-04-17 01:26:59 18715 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2013-04-17 01:26:59 18715 [Warning] InnoDB: New log files created, LSN=45781
2013-04-17 01:26:59 18715 [Note] InnoDB: Doublewrite buffer not found: creating new
2013-04-17 01:26:59 18715 [Note] InnoDB: Doublewrite buffer created
2013-04-17 01:26:59 18715 [Note] InnoDB: 128 rollback segment(s) are active.
2013-04-17 01:26:59 18715 [Warning] InnoDB: Creating foreign key constraint system tables.
2013-04-17 01:26:59 18715 [Note] InnoDB: Foreign key constraint system tables created
2013-04-17 01:26:59 18715 [Note] InnoDB: Creating tablespace and datafile system tables.
2013-04-17 01:26:59 18715 [Note] InnoDB: Tablespace and datafile system tables created.
2013-04-17 01:26:59 18715 [Note] InnoDB: Waiting for purge to start
2013-04-17 01:26:59 18715 [Note] InnoDB: 1.2.10 started; log sequence number 0
2013-04-17 01:26:59 18715 [Note] Binlog end
2013-04-17 01:26:59 18715 [Note] InnoDB: FTS optimize thread exiting.
2013-04-17 01:26:59 18715 [Note] InnoDB: Starting shutdown...
2013-04-17 01:27:00 18715 [Note] InnoDB: Shutdown completed; log sequence number 1625977
OK
Filling help tables...2013-04-17 01:27:00 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2013-04-17 01:27:00 18738 [Note] InnoDB: The InnoDB memory heap is disabled
2013-04-17 01:27:00 18738 [Note] InnoDB: Mutexes and rw_locks use InnoDB‘s own implementation
2013-04-17 01:27:00 18738 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-04-17 01:27:00 18738 [Note] InnoDB: CPU does not support crc32 instructions
2013-04-17 01:27:00 18738 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2013-04-17 01:27:00 18738 [Note] InnoDB: Completed initialization of buffer pool
2013-04-17 01:27:00 18738 [Note] InnoDB: Highest supported file format is Barracuda.
2013-04-17 01:27:00 18738 [Note] InnoDB: 128 rollback segment(s) are active.
2013-04-17 01:27:00 18738 [Note] InnoDB: Waiting for purge to start
2013-04-17 01:27:01 18738 [Note] InnoDB: 1.2.10 started; log sequence number 1625977
2013-04-17 01:27:01 18738 [Note] Binlog end
2013-04-17 01:27:01 18738 [Note] InnoDB: FTS optimize thread exiting.
2013-04-17 01:27:01 18738 [Note] InnoDB: Starting shutdown...
2013-04-17 01:27:02 18738 [Note] InnoDB: Shutdown completed; log sequence number 1625987
OK
To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/local/mysql/bin/mysqladmin -u root password ‘new-password‘
/usr/local/mysql/bin/mysqladmin -u root -h mysql5.6 password ‘new-password‘
Alternatively you can run:
/usr/local/mysql/bin/mysql_secure_installation
which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.
See the manual for more instructions.
You can start the MySQL daemon with:
cd . ; /usr/local/mysql/bin/mysqld_safe &
You can test the MySQL daemon with mysql-test-run.pl
cd mysql-test ; perl mysql-test-run.pl
Please report any problems with the ./bin/mysqlbug script!
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/local/mysql/my.cnf and
will be used by default by the server when you start it.
You may edit this file to change server settings
WARNING: Default config file /etc/my.cnf exists on the system
This file will be read by default by the MySQL server
If you do not want to use this, either remove it, or use the
--defaults-file argument to mysqld_safe when starting the server
[root@mysql5 scripts]#
[root@mysql5 scripts]# cd /usr/local/mysql/support-files/
[root@mysql5 support-files]# cp mysql.server /etc/rc.d/init.d/mysql
[root@mysql5 support-files]# cp my-default.cnf /etc/my.cnf
cp: overwrite `/etc/my.cnf‘? y
[root@mysql5 support-files]#
[root@mysql5 support-files]# chkconfig -add mysql
-add: unknown option
[root@mysql5 support-files]# chkconfig --add mysql
[root@mysql5 support-files]# chkconfig mysql on
[root@mysql5 support-files]# service mysql start
Starting MySQL. [ OK ]
[root@mysql5 support-files]#
[root@mysql5 data]# mysql -u mysql -p -S /tmp/mysql.sock
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.10 Source distribution
Type ‘help;‘ or ‘\h‘ for help. Type ‘\c‘ to clear the buffer.
mysql>
mysql> status;
--------------
mysql Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu (i686) using readline 5.1
Connection id: 1
Current database:
Current user: mysql@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ‘‘
Using delimiter: ;
Server version: 5.6.10 Source distribution
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: latin1
Db characterset: latin1
Client characterset: latin1
Conn. characterset: latin1
UNIX socket: /tmp/mysql.sock
Uptime: 3 min 38 sec
Threads: 1 Questions: 5 Slow queries: 0 Opens: 67 Flush tables: 1 Open tables: 60 Queries per second avg: 0.022
--------------
mysql>

原文：http://www.jb51.net/article/39191.htm

内容总结

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

内容备注

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

内容手机端

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

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

来源：【匿名】

【上一篇】linux shell 多线程执行程序【下一篇】Linux下安装GD

更多 ►

【linux mysql5.6版本的安装配置过程】教程文章相关的互联网学习教程文章

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

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 - 最新教程

LINUX - 最热教程