本文共 2500 字，大约阅读时间需要 8 分钟。

CentOS7??MySQL???????

1. ????

???MySQL????????????????????

1.1 MySQL????

??????MySQL??????/usr/local/software/mysql????

1.2 ??????

MySQL????????????/home/mysql/data????

2. MySQL????

2.1 ?????

?????????????MySQL?????????????????????

mkdir -p /opt/software
mkdir -p /usr/local/software
cd /opt/software
tar -zxvf mysql-5.7.30-linux-glibc2.12-x86_64.tar.gz
mv mysql-5.7.30-linux-glibc2.12-x86_64 mysql
mv mysql /usr/local/software

2.2 ??MySQL??????

groupadd mysql
useradd -r -g mysql -s /bin/bash mysql

2.3 ???????????

??????????????????

mkdir -p /home/mysql/data
chown -R mysql:mysql /home/mysql/data
chown -R mysql:mysql /usr/local/software/mysql

3. MySQL????????

3.1 ??MySQL????

cd /usr/local/software/mysql
./bin/mysqld --user=mysql --basedir=/usr/local/software/mysql --datadir=/home/mysql/data --initialize

3.2 ??MySQL????

??my.cnf????????????

[mysqld]
character_set_server=utf8
init_connect='SET NAMES utf8'
basedir=/usr/local/software/mysql
datadir=/home/mysql/data
socket=/usr/local/software/mysql/mysql.sock
lower_case_table_names=1
bind-address=0.0.0.0
[mysqld_safe]
log-error=/home/log/mysqld.log
pid-file=/usr/local/software/mysql/data/mysqld.pid
[client]
socket=/usr/local/software/mysql/mysql.sock
default-character-set=utf8

3.3 MySQL??????

?MySQL????????????????????

cp ./support-files/mysql.server /etc/init.d/mysqld
chkconfig --add mysqld

??MySQL??????

service mysqld start

3.4 ??????

?/etc/profile??????????

export PATH=$PATH:/usr/local/software/mysql/bin

?????????

source /etc/profile

??MySQL???

service mysqld restart

4. ??????

4.1 ??root????

mysql -u root -p
use mysql;
update user set user.Host='%';
flush privileges;
update mysql.user set authentication_string=password('123456') where user='root';
flush privileges;

?????????MySQL?????????

5. ??????

5.1 ?????Access denied

?????????????Access denied??????????

systemctl stop mysqld.service

2. ???????

vim /etc/my.cnf

??????????

skip-grant-tables

3. ??MySQL???

systemctl start mysqld.service

4. ??MySQL?

mysql -u root

5. ?????

use mysql;
update mysql.user set authentication_string=password('your_password') where user='root';
flush privileges;

6. ??skip-grant-tables?????MySQL?????

5.2 ??????

??????????????????????????????

7. ???????

set global validate_password_policy=0;
set global validate_password_length=4;

2. ??????

use mysql;
update mysql.user set authentication_string=password('your_password') where user='root';
flush privileges;

6. ??

????????MySQL????CentOS7?????????????????????????????MySQL???? /var/log/mysqld.log ????????