1、Centos7 系統(tǒng)自帶MariaDB安裝MySQL前需要卸載
# 查看系統(tǒng)自帶的MariaDB
[root@chensir ~]# rpm -qa |grep mariadb
mariadb-libs-5.5.56-2.el7.x86_64
# 卸載系統(tǒng)自帶的MariaDB
[root@chensir ~]# rpm -e --nodeps mariadb-libs-5.5.56-2.el7.x86_64
# 刪除 /etc/my.cnf配置文件
[root@chensir ~]# rm -rf /etc/my.cnf
2、檢查MySQL是否存在：rpm -qa |grep mysql
3、創(chuàng)建mysql用戶和用戶組：adduser mysql
修改mysql用戶密碼：passwd mysql
4、下載mysql的tar包 下載地址
5、上傳下載的MySQL tar包至/usr/local/
6、解壓mysql-5.7.25-linux-glibc2.12-x86_64.tar.gz：tar -zxvf mysql-5.7.25-linux-glibc2.12-x86_64.tar.gz
7、重命名：mv mysql-5.7.25-linux-glibc2.12-x86_64 mysql
8、在/etc目錄下創(chuàng)建my.cnf文件：vim /etc/my.cnf
內(nèi)容如下：
my.cnf配置內(nèi)容如下：
[mysqld]
[mysql]
# 設(shè)置mysql客戶端默認(rèn)字符集
default-character-set=utf8
[mysqld]
# 設(shè)置3306端口
port = 3306
# 設(shè)置mysql的安裝目錄
basedir=/usr/local/mysql
# 設(shè)置mysql數(shù)據(jù)庫(kù)的數(shù)據(jù)的存放目錄
datadir=/usr/local/mysql/data
# 允許最大連接數(shù)
max_connections=200
# 服務(wù)端使用的字符集默認(rèn)為8比特編碼的latin1字符集
character-set-server=utf8
# 創(chuàng)建新表時(shí)將使用的默認(rèn)存儲(chǔ)引擎
default-storage-engine=INNODB
lower_case_table_names=1
max_allowed_packet=16M
# 開(kāi)啟binlog
server-id = 1
log-bin=/usr/local/mysql/log/mysql-bin
explicit_defaults_for_timestamp=true
pid-file = /usr/local/mysql/mysql.pid
log_error = /usr/local/mysql/log/error.log
# 跳過(guò)mysql密碼驗(yàn)證
# skip-grant-tables
# 解決mysql版本導(dǎo)致的sql_model=only_full_group_by問(wèn)題
# sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
[mysql.server]
user=mysql
9、創(chuàng)建對(duì)應(yīng)目錄：
# 進(jìn)入mysql目錄內(nèi)
cd /usr/local/mysql
# 新建log文件夾
makir log
# 新建data文件夾
mkdir data
10、更改mysql所屬用戶為mysql：
chown mysql:mysql -R /usr/local/mysql
11、安裝mysql:
bin/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/
12、拷貝軟連接：cp ./support-files/mysql.server /etc/init.d/mysqld
13、賦可執(zhí)行權(quán)限chmod +x /etc/init.d/mysqld
14、啟動(dòng)mysql：service mysqld start
15、設(shè)置開(kāi)機(jī)啟動(dòng)：
chkconfig --level 35 mysqld on
chmod +x /etc/rc.d/init.d/mysqld
chkconfig --add mysqld
service mysqld status
16、修改配置文件vim /etc/profile
# 修改/etc/profile文件
#set mysql environment
export PATH=$PATH:/usr/local/mysql/bin
使其生效：source /etc/profile
17、獲取數(shù)據(jù)庫(kù)初始密碼：
cat /root/.mysql_secret
18、修改密碼：
mysql -uroot -p
set PASSWORD = PASSWORD('123456');
flush privileges;
19、添加遠(yuǎn)程訪問(wèn)權(quán)限
mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> update user set host='%' where user='root';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0
mysql> select host,user from user;
+-----------+---------------+
| host | user |
+-----------+---------------+
| % | root |
| localhost | mysql.session |
| localhost | mysql.sys |
+-----------+---------------+
3 rows in set (0.00 sec)
————————————————
flush privileges;生效
查看是否開(kāi)啟binlog：show variables like '%log_bin%';
