mysql 5.6 二进制安装_mysql 5.6二进制安装

安装环境

--软件

CentOS Linux release 7.2.1511 (Core)

MySQL5.6

--已有包卸载

rpm -qa | grep -i mysql  | xargs rpm -e --nodeps

rpm -qa | grep -i mariadb  | xargs rpm -e --nodeps

--删除现有的mysql用户信息

userdel -r mysql

--保证yum源可用

yum clean all

yum repolist

--依赖包安装

yum -y install perl-Digest-MD5 perl-DBD-MySQL perl-Time-HiRes

安装过程

#wget http://cdn.mysql.com//archives/mysql-5.6/mysql-5.6.12-linux-glibc2.5-x86_64.tar.gz

2、解压二进制安装包

# tar zxvf mysql-5.6.12-linux-glibc2.5-x86_64.tar.gz

3、将mysql解压后的程序包搬家到程序目录下，并创建软连接。

# mkdir /application

# mv mysql-5.6.12-linux-glibc2.5-x86_64 /application/mysql-5.6.12

# ln -s /application/mysql-5.6.12 /application/mysql

4、对MySQL存储目录进行授权

# useradd -s /sbin/nologin -M mysql

# chown -R mysql.mysql /application/mysql/

6、初始化数据库服务

注：5.6和5.7的初始化命令是不一样的

5.6版本初始化：

# /application/mysql/scripts/mysql_install_db --user=mysql --basedir=/application/mysql --datadir=/application/mysql/data

5.7版本初始化

# /application/mysql/bin/mysqld --initialize --user=mysql --basedir=/application/mysql-5.7.27 --datadir=/application/mysql/data

初始化时的最后一行输出会生成mysql的root密码，稍后改密码会用到

7、配置完成检查：

1、echo $? ---返回0

2、确认输出中有两个ok

3、确认data目录下生成数据库文件

# ls -l /application/mysql/data/total110604

-rw-rw---- 1 mysql mysql 12582912 Oct 26 11:56ibdata1-rw-rw---- 1 mysql mysql 50331648 Oct 26 11:56ib_logfile0-rw-rw---- 1 mysql mysql 50331648 Oct 26 11:56ib_logfile1

drwx------ 2 mysql mysql 4096 Oct 26 11:56mysql

drwx------ 2 mysql mysql 4096 Oct 26 11:56performance_schema

drwxr-xr-x 2 mysql mysql 4096 Oct 26 11:26 test

8、命令添加到环境变量，两种方法

1)

#echo 'export PATH=/application/mysql/bin:$PATH' >>/etc/profile

source /etc/profile

which mysql

2)

# vim /etc/profile.d/mysql.sh

PATH=/application/mysql/bin:$PATH

让配置生效

# ./etc/profile.d/mysql.sh

9、设置服务启动文件mysqld和mysql的配置文件

①copy启动文件

# cp /application/mysql/support-files/mysql.server /etc/init.d/mysqld

#将程序安装到/usr/local/下可以省略这一步

sed -i 's#/usr/local/mysql#/application/mysql#g' /application/mysql/bin/mysqld_safe /etc/init.d/mysqld

②copy配置文件

#cp /application/mysql/support-files/my-default.cnf /etc/my.cnf

10、设置数据库用户密码：

/application/mysql/bin/mysqladmin -u root password 'new-password'

#这里先输入初始化密码，再输入自定义的新密码

11、设置mysql开机自启

# chkconfig --add mysqld

# chkconfig mysqld on

12、启动并检查

#/etc/init.d/mysqld start

Starting MySQL...... SUCCESS!# netstat-lntup |grep 3306tcp0 0 :::3306 :::* LISTEN 54042/mysqld

常用的数据库操作选项

show databases;

create database clsn;

drop database clsn;

use mysql;

show tables；

并且mysql还可以限制指定用户可以从哪里进行连接登录数据库select * from user\G;

grant all on*.* to user@'host' identified by 'clsn123'; ---创建用户

grant all on*.* to Old_Boy@'localhost' identified by 'clsn123'; ---创建用户(大写用户)

drop user'user'@'host';

flush privileges；--- 刷新权限

问题解决

安装报错1：

[root@yl mysql]# /application/mysql/scripts/mysql_install_db --basedir=/application/mysql --datadir=/application/mysql/data --user=mysql

Can't locate Data/Dumper.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at /application/mysql/scripts/mysql_install_db line 42.

BEGIN failed--compilation aborted at /application/mysql/scripts/mysql_install_db line 42.

原因：缺少perl插件

解决：

[root@yl mysql]# yum install 'perl(Data::Dumper)'

安装报错:2：

error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory

出现该问题首先检查该链接库文件有没有安装使用 命令进行核查

rpm -qa|grep libaio

运行该命令后发现系统中无该链接库文件

解决：

yum install -y libaio-devel.x86_64

重新执行并测试：

# echo $?

0

参考：https://www.cnblogs.com/clsn/p/8025324.html