Mysql数据库环境搭建_mysql环境配置 csdn-优快云博客

本文链接：https://blog.youkuaiyun.com/m0_68530450/article/details/136561225

本文详细介绍了如何通过Yum工具在Linux系统上下载并安装MySQL8.0社区版，包括设置yum源、安装RPM包、配置MySQL服务器、修改root用户密码，以及授予特定用户权限的过程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Yum安装方法

1.从官网拉取yum源

yum -y install wget
wget  https://dev.mysql.com/get/mysql80-community-release-el7-11.noarch.rpm

2.下载rpm包

yum -y install mysql80-community-release-el7-11.noarch.rpm

3.选择安装的版本

#此处以5.7为例
vim /etc/yum.repos.d/mysql-community.repo

4.安装Mysql

yum -y install mysql-community-server

5.启动mysql

systemctl enable mysqld --now
systemctl status mysqld

6.修改密码

grep password /var/log/mysqld.log
2023-11-24T06:04:41.423079Z 1 [Note] A temporary password is generated for root@localhost: -64sowAPus)T

mysql -uroot -p'-64sowAPus)T'

#修改当前用户密码
ALTER USER user() IDENTIFIED BY 'Test123.';

#5.7版本'.'代表所有库 'root'代表允许root用户登，'192.168.200.20'指定主机ip，如果允许所有把ip变为'%'  IDENTIFIED BY 'Test123.'通过这个密码
GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.200.20' IDENTIFIED BY 'Test123.' WITH GRANT OPTION;

#刷新权限
flush privileges;

#退出
exit

#验证密码是否正确
[root@localhost app]# mysql -uroot -p
Enter password:   #输入上面修改过的密码即可
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.7.44 MySQL Community Server (GPL)

Copyright (c) 2000, 2023, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>