在CentOS下安装MySQL

1 下载
https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz

2 安装
创建目录
mkdir -p /root/{packages,services}

解压
tar -xvf /root/packages/mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz -C /root/packages

安装
mv /root/packages/mysql-5.7.26-linux-glibc2.12-x86_64 /root/services/mysql

3 设置环境变量
vim ~/.bashrc

export MYSQL_HOME=/root/services/mysql
export PATH=$PATH:$MYSQL_HOME/bin:$MYSQL_HOME/sbin:$MYSQL_HOME/support-files

source ~/.bashrc

4 验证
mysql -V

5 初始化MySQL服务器
创建MySQL用户
groupadd mysql
useradd -r -g mysql mysql

创建数据目录，并授权
mkdir -p /root/services/mysql/data
chown -R mysql:mysql /root/services/mysql
chmod -R 755 /root/services/mysql
chgrp -R mysql /root/services/mysql/data

初始化服务器
mysqld --initialize --user=mysql --datadir=/root/services/mysql/data --basedir=/root/services/mysql

上面的 :1Rq9tPfd1e# 是root用户的密码

6 创建配置文件
vim /etc/my.cnf

[mysqld]
port=3306
bind-address = 0.0.0.0
datadir=/root/services/mysql/data
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

symbolic-links=0
max_connections=600
innodb_file_per_table=1
lower_case_table_names=1
character_set_server=utf8

7 启动
启动之前，修改/root/services/mysql/support-files/mysql.server，
vim /root/services/mysql/support-files/mysql.server
basedir=/root/services/mysql
datadir=/root/services/mysql/data

然后启动，
mysql.server start

验证是否启动
ps -ef | grep -v grep | grep mysql

8 停止
mysql.server stop

9 访问
mysql -uroot -p
密码在初始化服务器时已输出

修改密码

set password for root@localhost = password('123');

远程登录

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123' WITH GRANT OPTION;
FLUSH PRIVILEGES;

​