Mysql 安装教程

Time: 2025-03-18 Thursday 23:56:01

服务器各环境安装教程

MySQL

首先在官网下载 rpm包

sudo rpm -Uvh https://dev.mysql.com/get/mysql80-community-release-el7-11.noarch.rpm

然后 yum 下载

sudo yum install mysql-community-server -y

临时密码会存储在

cat /var/log/mysqld.log

安全脚本

sudo mysql_secure_installation

授予远程访问权限

### 步骤 1：使用 `CREATE USER` 创建用户,在 MySQL 中先创建用户并设置密码：
CREATE USER 'root'@'%' IDENTIFIED BY 'Casio233.';

#### 步骤 2：授予权限,赋予所有权限并允许授权（`WITH GRANT OPTION`）：
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;

#### 步骤 3：检查权限是否生效,确认用户 `root@'%'` 已存在：
SELECT user, host FROM mysql.user WHERE user = 'root';

安装 Node

curl -sL https://rpm.nodesource.com/setup_20.x | sudo bash -

sudo yum install nodejs -y

安装 JDK

wget https://download.oracle.com/java/17/archive/jdk-17.0.12_linux-x64_bin.rpm

sudo rpm -ivh jdk-17.0.12_linux-x64_bin.rpm

SSH免密码

ssh-keygen -t rsa -b 4096
ssh-copy-id your_username@your_server_ip

安装docker

sudo dnf remove docker \
                  docker-client \
                  docker-client-latest \
                  docker-common \
                  docker-latest \
                  docker-latest-logrotate \
                  docker-logrotate \
                  docker-engine
                  
sudo dnf -y install dnf-plugins-core
sudo dnf config-manager --add-repo https://download.docker.com/linux/centos/docker-ce.repo
sudo dnf install docker-ce docker-ce-cli containerd.io docker-buildx-plugin docker-compose-plugin

yum源

1.备份现有的yum源配置 

sudo cp /etc/yum.repos.d /etc/yum.repos.d.backup -r

2.下载阿里云的yum源配置文件

sudo curl -o /etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-vault-9.repo

3.清理yum源缓存，生成新的

sudo yum clean all

sudo yum makecache

4.验证配置是否正确

sudo yum repolist

验证正确，

docker镜像解决方案

sudo mkdir -p /etc/docker
sudo tee /etc/docker/daemon.json <<-'EOF'
{
    "registry-mirrors": [
        "https://do.nark.eu.org",
        "https://dc.j8.work",
        "https://docker.m.daocloud.io",
        "https://dockerproxy.com",
        "https://docker.mirrors.ustc.edu.cn",
        "https://docker.nju.edu.cn"
    ]
}
EOF
sudo systemctl daemon-reload
sudo systemctl restart docker
————————————————
 

防火墙

sudo firewall-cmd --permanent --add-port=80/tcp
sudo firewall-cmd --reload

redis下载

sudo yum install redis
sudo systemctl enable redis
sudo systemctl start redis

最终的脚本

curl -sL https://rpm.nodesource.com/setup_20.x | sudo bash -
sudo yum install nodejs -y

wget https://download.oracle.com/java/17/archive/jdk-17.0.12_linux-x64_bin.rpm
sudo rpm -ivh jdk-17.0.12_linux-x64_bin.rpm

sudo yum install redis
sudo systemctl enable redis
sudo systemctl start redis

//centos 9 || https://repo.mysql.com//mysql84-community-release-el9-1.noarch.rpm

sudo rpm -Uvh https://dev.mysql.com/get/mysql80-community-release-el7-11.noarch.rpm
sudo yum install mysql-community-server -y
cat /var/log/mysqld.log
sudo mysql_secure_installation