linux安装MySQL5.7数据库

下载MySQL

• 进入安装包所在目录

cd /usr/local 

• 下载 MySQL

下载地址：https://dev.mysql.com/downloads/mysql/5.7.html#downloads

wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.25-linux-glibc2.12-x86_64.tar.gz

• 如果报-bash: wget: command not found错

yum install wget

• 解压文件

tar -zxvf mysql-5.7.25-linux-glibc2.12-x86_64.tar.gz

• 重命名

mv mysql-5.7.25-linux-glibc2.12-x86_64 mysql-5.7.25

安装数据库

• 添加系统mysql组和mysql用户

groupadd mysql
useradd -r -g mysql mysql
#useradd -r参数表示mysql用户是系统用户，不可用于登录系统

• 创建data目录

cd mysql-5.7.25
mkdir data

• 将/usr/local/mysql-5.7.25 的所有者及所属组改为mysql

chown -R mysql.mysql /usr/local/mysql-5.7.25

• 在/usr/local/mysql-5.7.25/support-files目录下创建my_default.cnf

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of MySQL.
 
[mysqld]
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 
 
basedir = /usr/local/mysql-5.7.25
datadir = /usr/local/mysql-5.7.25/data
port = 3306
socket = /tmp/mysql.sock
character-set-server=utf8
 
log-error = /usr/local/mysql-5.7.25/data/mysqld.log
pid-file = /usr/local/mysql-5.7.25/data/mysqld.pid

• 拷贝，如果提示是否覆盖，y

cp support-files/my_default.cnf /etc/my.cnf

• 初始化 mysqld

cd /usr/local/mysql-5.7.25

./bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql-5.7.25/ --datadir=/usr/local/mysql-5.7.25/data/ 

• 初始化完成之后，查看日志

/usr/local/mysql-5.7.25/data/mysqld.log

• 记住临时密码:a8?DQir=T+k+

[Note] A temporary password is generated for root@localhost: a8?DQir=T+k+

• 把启动脚本放到开机初始化目录

cp support-files/mysql.server /etc/init.d/mysql

• 启动mysql服务

service mysql start

• 登录mysql，密码为初始密码

cd /usr/local/mysql-5.7.25
./bin/mysql -u root -p
# 输入上面的临时密码 a8?DQir=T+k+

• 修改密码

mysql> set password=password('123456');
mysql> grant all privileges on *.* to root@'%' identified by '123456';
mysql> flush privileges;

• 重启mysql生效

service mysql stop
service mysql start

或

service mysql restart

你知道的越多，你不知道的越多。
有道无术，术尚可求，有术无道，止于术。
如有其它问题，欢迎大家留言，我们一起讨论，一起学习，一起进步