mysql

##二进制安装

1.解压二进制包

[root@localhost ~]# tar xf mysql-5.6.40.tar.gz 

2.创建安装目录

[root@localhost ~]# mkdir /application/

3.移动mysql二进制包到安装目录下并改名

[root@localhost ~]# mv mysql-5.6.40 /application/mysql-5.6.49

4.做一个软链接，方便后期无缝升级

[root@localhost ~]# ln -s /application/mysql-5.6.40/ /application/mysql

5.进入mysql目录

[root@localhost ~]# cd /application/mysql

6.进入脚本及配置文件目录

[root@localhost mysql]# cd /application/mysql/support-files/

7.拷贝配置文件

[root@localhost support-files]# cp my-default.cnf /etc/my.cnf

8.拷贝启动脚本

[root@localhost support-files]# cp mysql.server /etc/init.d/mysqld

9.初始化目录

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

遇到下图问题，检查是否有bin目录文件同时发现cmake， 可尝试编译

[root@locahost mysql]# ./scripts/mysql_install_db –user=mysql –basedir=/application/mysql/ –datadir=/application/mysql/data/

FATAL ERROR: Could not find my_print_defaults

The following directories were searched:

/application/mysql//bin
/application/mysql//extra
If you compiled from source, you need to run ‘make install’ to
copy the software into the correct location ready for operation.

If you are using a binary release, you must either be at the top
level of the extracted archive, or pass the –basedir option
pointing to that location.

安装yum -y install gcc gcc-c++ make perl ncurses-devel perl cmake

在MySQL的压缩包解压的目录下执行以下命令文件编译

cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql #/usr/local/mysql可以更改此为路径

make
make install

完成编译后 可压缩

[root@localhost application]# tar -zcvf /application/mysql-5.6.40.tar.gz /application/mysql-5.6.40/

留存后期使用。

10.授权mysql权限

[root@localhost scripts]# chown -R mysql.mysql /application/mysql*

11.配置启动脚本及陈旭问价路径为/application

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

12.启动mysql

[root@localhost application]# /etc/init.d/mysqld start

13.配置环境变量

[root@localhost application]# vim /etc/profile.d/mysql.sh

export PATH="/application/mysql/bin/:$PATH"

14.加载环境变量

[root@localhost application]# source /etc/profile

文章参考于B站视频