MySQL二进制部署

检查是否已安装MySQL
[root@xph ~]# rpm -qa | grep mysql
创建mysql用户组并更改权限
[root@xph ~]# groupadd mysql
[root@xph ~]# useradd mysql -g mysql -M -s /sbin/nologin
解压mysql安装包
[root@xph ~]# tar -zxvf mysql-5.7.30-linux-glibc2.12-x86_64.tar.gz
创建数据目录并赋予权限
[root@xph ~]# mkdir -p /data/mysql
配置属组
[root@xph ~]# chown mysql:mysql -R /data/mysql
将mysql解压缩文件移动到/usr/local/mysql文件中
[root@xph ~]# mv mysql-5.7.30-linux-glibc2.12-x86_64 /usr/local/
重命名
[root@xph local]# mv mysql-5.7.30-linux-glibc2.12-x86_64/ mysql
配置my.cnf
[root@xph ~]# cat /etc/my.cnf
[mysqld]

bind-address=0.0.0.0

port=3306

user=mysql

basedir=/usr/local/mysql

datadir=/data/mysql

socket=/tmp/mysql.sock

log-error=/data/mysql/mysql.err

pid-file=/data/mysql/mysql.pid

character_set_server=utf8mb4

symbolic-links=0

explicit_defaults_for_timestamp=true

进入mysql的bin目录
[root@xph ~]# cd /usr/local/mysql/bin
初始化mysql
[root@xph bin]# ./mysqld --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql/ --datadir=/data/mysql/ --user=mysql --initialize
查看mysql初始化密码
[root@xph bin]# cat /data/mysql/mysql.err

2024-02-27T14:01:06.952200Z 0 [Warning] InnoDB: New log files created, LSN=45790
2024-02-27T14:01:06.995641Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2024-02-27T14:01:07.090436Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: a7131fa1-d578-11ee-a2f0-000c290ac3bc.
2024-02-27T14:01:07.091114Z 0 [Warning] Gtid table is not ready to be used. Table ‘mysql.gtid_executed’ cannot be opened.
2024-02-27T14:01:08.169180Z 0 [Warning] CA certificate ca.pem is self signed.
2024-02-27T14:01:08.583142Z 1 [Note] A temporary password is generated for root@localhost: Iimy!zh94az<

做一个软连接

[root@xph bin]# ln -s /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
[root@xph bin]# ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql

启动mysql

[root@xph bin]# cd
[root@xph ~]# /usr/local/mysql/support-files/mysql.server start
Starting MySQL. SUCCESS!

查看mysql进程

[root@xph ~]# ps -ef|grep mysql

登录mysql并修改密码
[root@xph bin]# ./mysql -u root -p
Enter password:Iimy!zh94az<

mysql> SET PASSWORD = PASSWORD(‘mysql’);
Query OK, 0 rows affected, 1 warning (0.01 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.01 sec)

mysql>