centos7环境下二进制安装包安装 mysql5.6的方法详解_Mysql

centos7环境下二进制安装包安装 mysql5.6的方法详解

2021-01-07 16:57怀素真 Mysql

这篇文章主要介绍了centos7环境下二进制安装包安装 mysql5.6的方法,详细分析了centos7环境下使用二进制安装包安装 mysql5.6的具体步骤、相关命令、配置方法及操作注意事项,需要的朋友可以参考下

本文实例讲述了centos7环境下二进制安装包安装 mysql5.6的方法。分享给大家供大家参考，具体如下：

centos7 二进制安装包安装 mysql5.6

一、下载mysql5.6二进制安装包

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

如:mysql-5.6.34-linux-glibc2.5-x86_64.tar.gz

二、安装mysql5.6(安装在/data/mysql56)

(1)、创建mysql用户账号

1	`>` `useradd` `-s` `/sbin/nologin` `-M mysql`

(2)、解压压缩包

1	`>` `tar` `xf mysql-5.6.34-linux-glibc2.5-x86_64.tar.gz`

(3)、重命名

1	`>` `mv` `mysql-5.6.34-linux-glibc2.5-x86_64 mysql56`

(4)、复制配置文件

1	`>` `cp` `/data/mysql56/support-files/my-default.cnf` `/etc/my.cnf`

修改配置文件

									[client]

									port = 3306

									socket = /data/mysql56/mysql.sock

									default-character-set = utf8

									[mysqld]

									skip-name-resolve

									user = mysql

									basedir = /data/mysql56

									datadir = /data/mysql56/data

									port = 3306

									server_id = 10

									socket = /data/mysql56/mysql.sock

									pid-file = /data/mysql56/mysql.pid

									log-error = /data/mysql56/data/mysql.err

									log-bin = /data/mysql56/data/mysql-bin

									character-set-server = utf8

(*二进制安装，默认配置文件在/etc/my.cnf)

(5)、初始化数据库

									> chown -R mysql.mysql /data/mysq56

									> /data/mysql56/scripts/mysql_install_db \

									--defaults-file=/etc/my.cnf \

									--user=mysql \

									--basedir=/data/mysql56 \

									--datadir=/data/mysql56/data

如果出现如下信息

FATAL ERROR: please install the following Perl modules before executing
Data::Dumper

1	`> yum -y` `install` `autoconf`

此包安装时会安装Data:Dumper模块

三、配置并启动mysql

1 2	`>` `cp` `/data/mysql56/support-files/mysql.server` `/etc/init.d/mysqld` `>` `chmod` `755` `/etc/init.d/mysqld`

(*注意,mysql二进制安装默认的路径为/usr/local/mysql,启动脚本里/usr/local/mysql需要替换)

1	`>` `sed` `-i` `'s#/usr/local/mysql#/data/mysql56#g'` `/data/mysql56/bin/mysqld_safe` `/etc/init.d/mysqld`

启动mysql

1	`> service mysqld start`

四、添加自启动

									> chkconfig --add mysqld

									> chkconfig mysqld on

									> chkconfig --list mysqld

五、配置环境变量

1 2	`>` `echo` `'export PATH=/data/mysql56/bin:$PATH'` `>>` `/etc/profile` `>` `source` `/etc/profile`

六、修改mysql密码(mysql5.6安装默认root密码为空)

1	`> mysqladmin -u root password` `'123456'`

七、清理无用的mysql用户及库

登陆mysql

1	`> mysql -uroot -p`

查询用户

1	`>` `select` `user,host from mysql.user;`

如下所示

+------+-----------------------+
| user | host                  |
+------+-----------------------+
| root | 127.0.0.1             |
| root | ::1                   |
|      | localhost             |
| root | localhost             |
|      | localhost.localdomain |
| root | localhost.localdomain |
+------+-----------------------+

									> drop user "root"@"::1";

									> drop user ""@"localhost";

									> drop user ""@"localhost.localdomain";

									> drop user "root"@"localhost.localdomain";