Linux MySQL Install

这里安装的版本是mysql-8.0.31-linux-glibc2.12-x86_64.tar.xz

完整的命令安装是这样的

环境初始化配置

sudo vim /etc/profile

export MYSQL_HOME=/usr/local/mysql/

export PATH=$MYSQL_HOME/bin:$PATH

这里正式开始安装命令

MYSQL_PKGNAME=mysql-8.0.31-linux-glibc2.12-x86_64.tar.xz

wget https://dev.mysql.com/get/Downloads/MySQL-8.0/${MYSQL_PKGNAME}

tar -xvf ${MYSQL_PKGNAME}

mv mysql-8.0.31-linux-glibc2.12-x86_64 /usr/local/mysql

groupadd mysql

useradd -r -g mysql mysql

chown -R mysql:mysql /usr/local/mysql/

cd /usr/local/mysql

mkdir data

yum -y install numactl.x86_64

ln -s -f /usr/lib64/libtinfo.so.6.2 /usr/lib64/libtinfo.so.5

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

chown -R root:root ./

chown -R mysql:mysql data

mkdir /etc/init.d

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

cp /opt/sh/.mysql.cnf /etc/my.cnf

chown 777 /etc/my.cnf

chmod +x /etc/init.d/mysqld

/etc/init.d/mysqld restart

source /etc/profile

echo "change rootpwd"

printf "source /opt/sh/.mysql_root_pwd;\n";

service mysqld restart

推荐使用安装命令，后续还能恢复异常情况

git clone https://github.com/pixel-jey/mysql-install

sudo \cp -r opt/* /

sudo sudo chown -R root:root /opt/sh/

sudo /opt/sh/myql-config-install.sh

Use: install|rootpwd|mycnf

主要提供三个功能：安装|恢复root密码|恢复默认配置