还是5.7.29，还是CentOS 7

二进制包安装MySQL

一、下载

安装依赖包

 yum install ncurses-devel.x86_64 libaio.x86_64 -y
 

下载MySQL二进制包

方法一：使用wget命令直接下载

 wget https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.29-el7-x86_64.tar.gz
 

方法二：到官网下载，然后上传到Linux

https://downloads.mysql.com/archives/community/

选择对应的版本

解压缩

 # 解压缩
tar -zxf mysql-5.7.29-el7-x86_64.tar.gz

# 移动到/usr/local下
mv mysql-5.7.29-el7-x86_64 /usr/local/mysql
 

二、修改配置文件并初始化

前提工作

 # 创建mysql用户
useradd -r -s /sbin/nologin mysql

# 建立工作目录
mkdir -p /data/mysql/{data,log}

# 授权目录
chown -R mysql.mysql /data/mysql
chown -R mysql.mysql /usr/local/mysql
 

编辑配置文件

 cat > /etc/my.cnf << EOF
[client]
default-character-set = utf8mb4
port = 3306
socket = /data/mysql/mysql.sock

[mysqld]
server_id = 1
character-set-server = utf8
user = mysql
port = 3306
socket = /data/mysql/mysql.sock
basedir = /usr/local/mysql
datadir = /data/mysql/data
log-error = /data/mysql/log/mysql_error.log
log-bin = /data/mysql/log/mysql-bin
binlog_format = ROW
pid-file = /data/mysql/mysql.pid
open_files_limit = 8192
innodb_buffer_pool_size = 512M

[mysql]
auto-rehash
prompt = ‘\u@\h [\d]> ‘
EOF
 

初始化

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

三、启动MySQL

添加环境变量

 echo "export PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile
source /etc/profile
 

启动

 cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
service mysql start
chkconfig --add mysql
 

获取默认密码登录

 # 获取默认密码
temp_passwd=`cat /data/mysql/log/mysql_error.log | grep "temporary password" | awk ‘{print $NF}‘`

# 使用默认密码登录
mysql -uroot -p$temp_passwd

# 修改密码
root@localhost [(none)]> ALTER USER ‘root‘@‘localhost‘ IDENTIFIED BY ‘NewPassword2233$‘;
 

二进制包安装mysql完成！

二进制包安装MySQL5.7.29

标签：ncurses   log   sock   arch   def   eof   ali   roo   localhost   

查看更多关于二进制包安装MySQL5.7.29的详细内容...