1、下载mysql二进制安装包
wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.30-linux-glibc2.12-x86_64.tar.gz
2、解压配置环境变量
#添加mysql用户
useradd mysql
#创建mysql工作目录
mkdir /usr/local/mysql && chown -R mysql. /usr/local/mysql
#解压mysql二进制安装包到工作目录
tar -zxvf ./mysql-5.7.30-linux-glibc2.12-x86_64.tar.gz
mv mysql-5.7.30-linux-glibc2.12-x86_64/* /usr/local/mysql && chown -R mysql. /usr/local/mysql
rm -rf mysql-5.7.30-linux-glibc2.12-x86_64
#创建日志目录
mkdir /usr/local/mysql/logs
chown -R mysql. /usr/local/mysql
#初始化,此处初始化的是空密码
/usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf --initialize-insecure --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql
#--initialize-insecure 生成空密码
#--initialize 生成随机密码
#启动mysql,通过mysqld_safe守护进程来启动mysqld
/usr/local/mysql/bin/mysqld_safe --defaults-file=/etc/my.cnf --user=mysql &
echo "请执行下面语句修改密码:"
echo "ALTER USER USER() IDENTIFIED BY '123456';"
#注意,每次修改类型操作都刷新一下
echo "flush privileges;"
#注意:my.cnf配置文件中,需要加入以下配置,否则报找不到socket
[client]
port = 3306
socket=/usr/local/mysql/mysql.sock
#配置开机自启(mysql.server调用mysqld_safe守护进程):
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
chmod +755 /etc/init.d/mysqld #添加执行权限
chkconfig --add mysqld #添加自启服务
chkconfig --list #显示自启服务列表
#查看mysql状态:
service mysqld status
#配置任何路径都可操作mysql
#在~/.bashrc或者在/etc/profile里加上如下配置:
export MYSQL_HOME=/usr/local/mysql
export PATH=$PATH:$MYSQL_HOME/bin
#再使配置生效
source ~/.bashrc或者source /etc/profile