centos7安裝單節(jié)點(diǎn)mysql（rpm包安裝）

1、查看下面軟件包是否安裝，如果安裝卸載。

# rpm -qa | grep postfix

# rpm -qa | grep mariadb

# rpm -qa | grep mysql

2、創(chuàng)建目錄

創(chuàng)建包存放目錄

# mkdir /data/packages

創(chuàng)建mysql數(shù)據(jù)目錄

# mkdir /data/mysql_data

3、解壓并安裝

# cd /data/packages

# tar -xf mysql-5.7.18-1.el7.x86_64.rpm-bundle.tar

# rpm -ivh mysql-community-common-5.7.18-1.el7.x86_64.rpm 

# rpm -ivh mysql-community-libs-5.7.18-1.el7.x86_64.rpm

# rpm -ivh mysql-community-client-5.7.18-1.el7.x86_64.rpm 

# rpm -ivh mysql-community-server-5.7.18-1.el7.x86_64.rpm

4、賦予權(quán)限并設(shè)置開機(jī)自啟動(dòng)

# chown mysql:mysql /data/mysql_data

# systemctl enable mysqld.service

5、編輯配置文件

# vi /etc/my.cnf

[mysql]

default-character-set=utf8

datadir=/data/mysql_data

default-storage-engine=INNODB

character_set_server=utf8

expire_logs_days=15

innodb_buffer_pool_size=8G

innodb_log_file_size=256M

innodb_flush_method=O_DIRECT

max_connections=500

innodb_autoextend_increment=128

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

6、啟動(dòng)服務(wù)并設(shè)置登錄密碼

# systemctl start mysqld.service

查看初始密碼

# grep "root@localhost" /var/log/mysqld.log | awk '{print $11}'

使用初始密碼登錄并修改密碼

# mysql -uroot -p

mysql> set password=password('自定義密碼');