安装MySQL-5.7
实验环境:
cat /etc/redhat-release
CentOS Linux release 8.4.2105
0,准备工作
yum install libaio
yum install ncurses-compat-libs
1,从网易镜像下载二进制包
wget http://mirrors.163.com/mysql/Downloads/MySQL-5.7/mysql-5.7.32-linux-glibc2.12-x86_64.tar.gz
tar zxf mysql-5.7.32-linux-glibc2.12-x86_64.tar.gz
2,准备程序目录/usr/local/mysql
mv mysql-5.7.32-linux-glibc2.12-x86_64 /usr/local/mysql
useradd -s /sbin/nologin mysql
In order to upgrade the database, you must run SSSD.
useradd mysqli
3,准备数据库目录/data/mysql
cd /usr/local/mysql
mkdir -p /data/mysql
chown -R mysql:mysql /data/mysql
4,配置数据库文件
vim /etc/my.cnf
[mysqld]
innodb_buffer_pool_size=128M
log_bin=aminglinux
basedir=/usr/local/mysql
datadir=/data/mysql
port=3306
server_id=128
socket=/tmp/mysql.sock
join_buffer_size=128M
sort_buffer_size=2M
read_rnd_buffer_size=2M
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
5,初始化数据库
/usr/local/mysql/bin/mysqld --initialize --user=mysql
会生成一个临时密码
6,复制启动脚本文件并修改datadir
cp support-files/mysql.server /etc/init.d/mysqld
chmod 755 /etc/init.d/mysqld
vm /etc/init.d/mysqld
修改datadir=/data/mysql
7,将服务加入启动系统列表
chkconfig --add mysqld
chkconfig mysqld on
8,启动服务并设置管理员密码
service mysqld start
/usr/local/mysql/bin/mysqladmin -uroot -p'临时密码' password '新密码'