Mysql centos 7下载安装-优快云博客

本文链接：https://blog.youkuaiyun.com/qq_38534887/article/details/131750086

在这里插入图片描述

上传
解压安装

[root@ip1 mysql]# yum -y install mysql-community-*.rpm
[root@ip1 mysql]# systemctl start mysqld
[root@ip1 mysql]# systemctl status mysqld
● mysqld.service - MySQL Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: active (running) since 日 2023-07-16 14:24:46 CST; 4s ago
     Docs: man:mysqld(8)
           http://dev.mysql.com/doc/refman/en/using-systemd.html
  Process: 2557 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
 Main PID: 2636 (mysqld)
   Status: "Server is operational"
   CGroup: /system.slice/mysqld.service
           └─2636 /usr/sbin/mysqld

7月 16 14:24:40 ip1 systemd[1]: Starting MySQL Server...
7月 16 14:24:46 ip1 systemd[1]: Started MySQL Server.

修改密码

# q退出
[root@ip1 mysql]# less /var/log/mysqld.log

在这里插入图片描述

[root@ip1 mysql]# mysql -uroot -p
mysql> ALTER USER USER() IDENTIFIED BY 'Mysql@12';
Query OK, 0 rows affected (0.00 sec)

修改远程链接

mysql> update mysql.user set host='%' where user='root';
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

关闭防火墙

[root@ip1 mysql]# systemctl stop firewalld.service
[root@ip1 mysql]# systemctl disable firewalld.service