CentOS 7操作系统MySQL 8.0.17 二进制非root用户解压安装

缺乏、安全感 2023-10-18 22:46 9阅读 0赞

查询删除原有mysql  
使用rpm -qa | grep mysql 或mariadb 搜索 mysql，如果存在，使用rpm -e --nodeps mariadb-全部删除，  
或使用yum remove mysql mysql-server mysql-libs compat-mysql51全部删除；

下载所需依赖包  
yum remove libnuma.so.1  
yum install make cmake libaio wget -y  
yum install numactl.x86\_64

创建MySQL用户组和用户  
/usr/sbin/groupadd mysql  
/usr/sbin/useradd -g mysql mysql  
passwd mysql  
mkdir -p /data/mysql  
cd /data  
chown -R mysql:mysql mysql  
login as mysql  
cd /data/mysql

获取MySQL  
地址可以查看MySQL官网  
wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.17-linux-glibc2.12-x86\_64.tar.xz

解压到/data/mysql  
tar xvf mysql-8.0.17-linux-glibc2.12-x86\_64.tar.xz  
cd mysql-8.0.17-linux-glibc2.12-x86\_64  
mv \* ../

创建MySQL数据目录，日志目录  
cd /data/mysql  
mkdir data

初始化数据库  
/data/mysql/bin/mysqld --initialize --basedir=/data/mysql --datadir=/data/mysql/data  
2019-08-01T21:58:45.860308Z 0 \[Warning\] \[MY-010139\] \[Server\] Changed limits: max\_open\_files: 1024 (requested 8161)  
2019-08-01T21:58:45.860335Z 0 \[Warning\] \[MY-010142\] \[Server\] Changed limits: table\_open\_cache: 431 (requested 4000)  
2019-08-01T21:58:45.866064Z 0 \[System\] \[MY-013169\] \[Server\] /data/mysql/bin/mysqld (mysqld 8.0.17) initializing of server in progress as process 31692  
2019-08-01T21:58:49.871106Z 5 \[Note\] \[MY-010454\] \[Server\] A temporary password is generated for root@localhost: G2AV)PrhLD?n  
2019-08-01T21:58:52.721667Z 0 \[System\] \[MY-013170\] \[Server\] /data/mysql/bin/mysqld (mysqld 8.0.17) initializing of server has completed

记录下最后一行mysql生成的root 临时密码: root@localhost: G2AV)PrhLD?n  
ssl 验证 /data/mysql/bin/mysql\_ssl\_rsa\_setup --datadir=/data/mysql/data

创建配置文件  
vi /data/mysql/my.cnf

\[mysqld\]  
\#严格模式  
sql\_mode=STRICT\_ALL\_TABLES  
\# 设置3306端口  
port=3306  
\# 设置mysql的安装目录  
basedir=/data/mysql  
\# 设置mysql数据库的数据的存放目录  
datadir=/data/mysql/data  
\# 允许最大连接数  
max\_connections=2000  
\# 允许连接失败的次数。  
max\_connect\_errors=10  
\# 服务端使用的字符集默认为UTF8  
character-set-server=utf8  
\# 创建新表时将使用的默认存储引擎  
default-storage-engine=INNODB  
\# 默认使用“mysql\_native\_password”插件认证  
\#mysql\_native\_password  
default\_authentication\_plugin=mysql\_native\_password  
\#skip-log-bin  
\#log\_bin=binlog

\[mysql\]  
\# 设置mysql客户端默认字符集  
default-character-set=utf8  
\[client\]  
\# 设置mysql客户端连接服务端时默认使用的端口  
port=3306  
default-character-set=utf8

启动mysql

/data/mysql/bin/mysqld\_safe --defaults-file=/data/mysql/my.cnf &  
ps -ef|grep mysql 能看到类似下面的信息，说明启动成功；  
root 4578 1 0 15:16 pts/0 00:00:00 /bin/sh /data/mysql/bin/mysqld\_safe --datadir=/usr/app/mysqldata --pid-file=/usr/app/mysqldata/bogon.pid  
mysql 4865 4578 0 15:16 pts/0 00:00:11 /data/mysql/bin/mysqld --basedir=/data/mysql --datadir=/usr/app/mysqldata --plugin-dir=/data/mysql/lib/plugin --user=mysql --log-error=/usr/app/mysqldata/myerror.log --pid-file=/usr/app/mysqldata/bogon.pid --socket=/var/run/mysqld/mysqld.sock --port=3306  
root 5839 1022 0 15:35 pts/0 00:00:00 grep --color=auto mysql

添加环境变量  
vi /home/mysql/.bash\_profile

在最后添加export PATH=$PATH:/data/mysql/bin

source /home/mysql/.bash\_profile

连接登录  
mysql -u root -p

改密码:  
alter user 'root'@'localhost' identified by 'password';  
flush privileges;

退出关闭mysql

mysql> quit  
Bye  
\[mysql@localhost ~\]$ mysqladmin shutdown -u root -p  
Enter password:  
2019-08-01T22:15:02.092168Z mysqld\_safe mysqld from pid file /data/mysql/data/localhost.pid ended  
\[1\]+ Done /data/mysql/bin/mysqld\_safe --defaults-file=/data/mysql/my.cnf (wd: /data/mysql/bin)  
(wd now: ~)  
\[mysql@localhost ~\]$

ps -ef|grep mysql  
\[mysql@localhost ~\]$ ps -ef | grep mysql  
root 25031 9524 0 05:45 ? 00:00:00 sshd: mysql \[priv\]  
mysql 25093 25031 0 05:45 ? 00:00:00 sshd: mysql@pts/2  
mysql 25095 25093 0 05:45 pts/2 00:00:00 -bash  
mysql 40360 25095 0 06:15 pts/2 00:00:00 ps -ef  
mysql 40361 25095 0 06:15 pts/2 00:00:00 grep --color=auto mysql  
\[mysql@localhost ~\]$

添加服务  
vi /usr/lib/systemd/system/mysqld.service  
\#  
\# systemd service file for MySQL forking server  
\#

\[Unit\]  
Description=MySQL Server  
Documentation=man:mysqld(8)  
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html  
After=network.target  
After=syslog.target

\[Install\]  
WantedBy=multi-user.target

\[Service\]  
User=mysql  
Group=mysql

Type=notify

\# Disable service start and stop timeout logic of systemd for mysqld service.  
TimeoutSec=0

\# Execute pre and post scripts as root  
PermissionsStartOnly=true

\# Start main service  
ExecStart=/data/mysql/bin/mysqld $MYSQLD\_OPTS

\# Use this to switch malloc implementation  
EnvironmentFile=-/etc/sysconfig/mysql

\# Sets open\_files\_limit  
LimitNOFILE = 10000

Restart=on-failure

RestartPreventExitStatus=1

\# Set enviroment variable MYSQLD\_PARENT\_PID. This is required for restart.  
Environment=MYSQLD\_PARENT\_PID=1

PrivateTmp=false