1.下载安装包
cd /usr/local/
wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz
2.解压
tar zxvf mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz
mv /usr/local/mysql-5.7.22-linux-glibc2.12-x86_64 mysql
3.创建mysql用户组和用户
groupadd mysql
useradd -r -g mysql -s /bin/false mysql
4.mysql目录授权给mysql组和mysql用户
chown mysql:mysql mysql
chmod 750 mysql
5.初始化数据库
./mysqld --initialize --user=mysql --datadir=/usr/local/mysql/data --basedir=/usr/local/mysql
6.查看密码
cat /usr/local/mysql/data/mysql.err
7.配置文件
vim /etc/my.cnf
[mysqld]
datadir=/usr/local/mysql/data
port = 3306
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
symbolic-links=0
max_connections=400
innodb_file_per_table=1
lower_case_table_names=1
character_set_server=utf8
8.启动命令
/usr/local/mysql/support-files/mysql.server start
9. 登陆 /usr/local/mysql/bin/mysql -u root -p //输入密码直接敲回车键
10. 刷新规则允许外部访问
use mysql #选择访问mysql库
update user set host = '%' where user = 'root'; #使root能再任何host访问
FLUSH PRIVILEGES; #刷新