linux下安装mysql5.7的压缩版

  • 下载安装包并解压
  • 解压后拷贝到 /usr/local/mysql目录
  • 创建 data、logs 目录： 
1
mkdir -p /usr/local/mysql/data /usr/local/mysql/logs
  • 修改 /etc/my.cnf文件，若没有改文件则创建
1
2
3
4
5
6
7
8
9
10
11
12
13
[client]
socket=/usr/local/mysql/mysql.sock

[mysqld]
port=3306
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
socket=/usr/local/mysql/mysql.sock
symbolic-links=0

[mysqld_safe]
log-error=/usr/local/mysql/logs/mysql.log
pid-file=/usr/local/mysql/mysql.pid
  • 创建mysql用户组及其用户
1
2
groupadd mysql
useradd -r -g mysql mysql
  • 赋予目录相应权限
1
2
chown -R mysql /usr/local/mysql/
chgrp -R mysql /usr/local/mysql/
  • 修改环境变量，增加mysql路径
1
2
MYSQL_HOME=/usr/local/mysql
export PATH=$MYSQL_HOME/bin:$PATH
  • 初始化，并记录下初始化的root用户密码
1
mysqld --initialize --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/
  • 已安全方式启动mysql，该方式启动可保证mysql进程异常后会自动重启
1
mysqld_safe --user=mysql
  • 加入系统自动启动
1
2
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
chkconfig mysqld on
  • 用root账户登录，并修改初始密码
1
2
mysql -uroot -p
alter user root@localhost identified by 'tiger';