centos安装mysql8.0设置密码为Liwenzhuo666.cn61me.@ndgj 端口设置为15692 且只能ip:47.95.36.250访问
时间: 2024-04-12 18:32:58 浏览: 23
您好!要在CentOS上安装MySQL 8.0并设置密码、更改端口并限制访问IP,您可以按照以下步骤进行操作:
1. 添加MySQL Yum Repository:
```
sudo dnf install https://dev.mysql.com/get/mysql80-community-release-el8-3.noarch.rpm
```
2. 安装MySQL 8.0:
```
sudo dnf install mysql-community-server
```
3. 启动MySQL服务并设置开机自启:
```
sudo systemctl start mysqld
sudo systemctl enable mysqld
```
4. 获取MySQL初始密码:
```
sudo grep 'temporary password' /var/log/mysqld.log
```
5. 运行MySQL安全性脚本以提高安全性并设置新密码:
```
sudo mysql_secure_installation
```
6. 登录MySQL:
```
mysql -u root -p
```
7. 更改密码:
```sql
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Liwenzhuo666.cn61me.@ndgj';
```
8. 更改MySQL监听端口:
```sql
sudo vi /etc/my.cnf.d/mysql-server.cnf
```
将`[mysqld]`部分中的`port`设置为15692:
```conf
[mysqld]
port=15692
```
9. 重新启动MySQL服务:
```
sudo systemctl restart mysqld
```
10. 限制访问IP:
```sql
CREATE USER 'root'@'47.95.36.250' IDENTIFIED BY 'Liwenzhuo666.cn61me.@ndgj';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'47.95.36.250' WITH GRANT OPTION;
FLUSH PRIVILEGES;
```
请注意,上述步骤假设您已经安装了CentOS 8,并且您可能需要根据您的实际情况进行调整。希望对您有所帮助!如果有任何问题,请随时提问。