centos6.6简易安装mysql_CentOS6.6安装mysql-5.7.25二进制安装包简易教程

[root@bogon:~]# cat /etc/redhat-release

CentOS release 6.6 (Final)

[root@bogon:~]# uname -r

2.6.32-504.el6.x86_64

[root@bogon:~]# uname -m

x86_64

2，排除系统中存在的mysql和mariadb

[root@bogon:~]# rpm -qa|egrep "mysql|mariadb"

mysql-libs-5.1.73-3.el6_5.x86_64

[root@bogon:~]# rpm -e --nodeps mysql-libs-5.1.73-3.el6_5.x86_64

#包括/var/lib/mysql下的文件也需要清空(可以通过find / -name "mysql"来查找)

3，从官网下载二进制安装包，创建存放软件包的文件，并通过rsync把软件从本地上传到服务器指定位置，并用md5校验文件的准确性

[root@bogon:/home/hejian/tools]# rsync -avzP -e "ssh -p 22" hejian@192.168.0.103:/Users/hejian/Desktop/mysql-5.7.25-linux-glibc2.12-x86_64.tar.gz .

[root@bogon:/home/hejian/tools]# md5sum mysql-5.7.25-linux-glibc2.12-x86_64.tar.gz

d241f5dd6527cf1f9ff39449538c1eb1 mysql-5.7.25-linux-glibc2.12-x86_64.tar.gz

4，把mysl解压到指定文件夹，并创建软链接

[root@bogon:/home/hejian/tools]# mkdir -p /application

[root@bogon:/home/hejian/tools]# tar -xf mysql-5.7.25-linux-glibc2.12-x86_64.tar.gz -C /application/

5，创建mysql用户，并给mysql文件夹授权

[root@bogon:/application]# useradd -s /sbin/nologin -M mysql

[root@bogon:/application]# chown -R mysql.mysql /application/mysql

6，创建my-default.cnf配置文件，并拷贝到/etc下

从5.7.18版本开始，已经不提供my-default.cnf文件

[client]

port = 3306

socket = /tmp/mysql.sock

[mysqld]

#设置3306端口

port = 3306

#设置socke文件所在目录

socket=/tmp/mysql.sock

# 设置mysql的安装目录

basedir=/application/mysql

# 设置mysql数据库的数据的存放目录

datadir=/application/mysql/data

# 允许最大连接数

max_connections=200

#SQL数据包发送的大小

max_allowed_packet = 128M

# 服务端使用的字符集默认为latin1字符集

character-set-server=utf8

# 创建新表时将使用的默认存储引擎

default-storage-engine=INNODB

[mysqld_safe]

#数据库错误日志文件

log_error =/application/mysql/data/error.log

[root@bogon:/application/mysql/support-files]# cp my-default.cnf /etc/my.cnf

7，对mysql进行初始化，会5.7以后用--initialize来初始化，并最后生成一个随机密码

[root@bogon:/application/mysql]# ./bin/mysqld --initialize --basedir=/application/mysql/ --datadir=/application/mysql/data/ --user=mysql

2019-04-11T11:51:03.883359Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

2019-04-11T11:51:04.624279Z 0 [Warning] InnoDB: New log files created, LSN=45790

2019-04-11T11:51:04.714769Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.

2019-04-11T11:51:04.792980Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 1602c2e3-5c50-11e9-98d6-000c2933615e.

2019-04-11T11:51:04.794419Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.

2019-04-11T11:51:04.798256Z 1 [Note] A temporary password is generated for root@localhost: &jKQaE6rE77b

8，设置加密连接

[root@bogon:/application/mysql]# /application/mysql/bin//mysql_ssl_rsa_setup

Generating a 2048 bit RSA private key

..+++

..............+++

writing new private key to 'ca-key.pem'

-----

Generating a 2048 bit RSA private key

........................................+++

.......................+++

writing new private key to 'server-key.pem'

-----

Generating a 2048 bit RSA private key

..............................+++

..............................................................................................................+++

writing new private key to 'client-key.pem'

-----

9，配置系统的方式启动MySQL，并设置开机自启动

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

由于mysql默认的安装路径是/usr/local/mysql，需要对mysqld脚本下的文件做个替换

[root@bogon:/application/mysql]# sed -i 's#/usr/local#/application#g' /etc/init.d/mysqld

然后启动mysql，并设置开机自启动

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

[root@bogon:/application]# netstat -tunlp|grep mysqld

tcp 0 0 :::3306 :::* LISTEN 25092/mysqld

[root@bogon:/application]# chkconfig mysqld on

[root@bogon:/application]# chkconfig --list|grep mysqld

mysqld 0:off1:off2:on3:on4:on5:on6:off

10，配置环境变量

vim /etc/profile

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

source /etc/profile

11，然后输入第7步生成的随机密码，就可以正常登录了

[root@bogon:/application]# mysql -hlocalhost -uroot -p

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 6

Server version: 5.7.25

Copyright (c) 2000, 2019, 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> show databases;

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

mysql> set password=password("123456");

mysql> flush privileges;

mysql成功安装完毕！