centos 7 离线安装mysql

 

下载离线安装包:

-a----         2025/2/14     21:15       15322740 mysql-community-client-8.4.4-1.el7.x86_64.rpm
-a----         2025/2/14     21:16        3624232 mysql-community-client-plugins-8.4.4-1.el7.x86_64.rpm
-a----         2025/2/14     21:15         706416 mysql-community-common-8.4.4-1.el7.x86_64.rpm
-a----         2025/2/14     21:15        2345116 mysql-community-icu-data-files-8.4.4-1.el7.x86_64.rpm
-a----         2025/2/14     21:17        1590828 mysql-community-libs-8.4.4-1.el7.x86_64.rpm
-a----         2025/2/14     21:10       63858128 mysql-community-server-8.4.4-1.el7.x86_64.rpm

　　

卸载mariadb 

yum remove mariadb-libs

　　

安装

[root@localhost mysql]# rpm -ivh *
warning: mysql-community-client-8.4.4-1.el7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID a8d3785c: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:mysql-community-common-8.4.4-1.el################################# [ 17%]
   2:mysql-community-client-plugins-8.################################# [ 33%]
   3:mysql-community-libs-8.4.4-1.el7 ################################# [ 50%]
   4:mysql-community-client-8.4.4-1.el################################# [ 67%]
   5:mysql-community-icu-data-files-8.################################# [ 83%]
   6:mysql-community-server-8.4.4-1.el################################# [100%]
[root@localhost mysql]# 

　　

启动mysql

systemctl start mysqld

　

生成root密码:

mysqld --initialize --user=mysql

查看root密码

grep 'temporary password' /var/log/mysqld.log

 登陆

mysql -u root -p

[root@localhost mysql]#  mysqld --initialize --user=mysql
[root@localhost mysql]# sudo grep 'temporary password' /var/log/mysqld.log
2025-02-14T21:18:20.458329Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: 634ixnuIef*W
[root@localhost mysql]# mysql -u root -p

　　

 修改密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'root';

 创建远程访问用户:

mysql> CREATE USER 'root'@'%' IDENTIFIED BY 'root';
Query OK, 0 rows affected (0.01 sec)

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';
Query OK, 0 rows affected (0.00 sec)

　　

vi /etc/my.cnf

bind-address=0.0.0.0