linux安装mysql8并初始化
时间: 2023-11-15 19:54:35 浏览: 59
好的,下面是安装MySQL8并初始化的步骤:
1. 下载MySQL8的安装包,可以从官网或者其他镜像源下载,例如:
```shell
wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
```
2. 安装MySQL8的yum源:
```shell
rpm -Uvh mysql80-community-release-el7-3.noarch.rpm
```
3. 安装MySQL8服务器和客户端:
```shell
yum install mysql-community-server mysql-community-client
```
4. 启动MySQL8服务:
```shell
systemctl start mysqld
```
5. 查看MySQL8服务状态:
```shell
systemctl status mysqld
```
6. 查看MySQL8默认生成的root密码:
```shell
grep "password" /var/log/mysqld.log | awk '{print $NF}'
```
7. 用默认密码登录MySQL8:
```shell
mysql -uroot -p
```
8. 修改root用户密码:
```mysql
ALTER USER 'root'@'localhost' IDENTIFIED BY 'your_new_password';
```
9. 创建新用户和数据库:
```mysql
CREATE USER 'your_username'@'localhost' IDENTIFIED BY 'your_password';
CREATE DATABASE your_database_name;
GRANT ALL PRIVILEGES ON your_database_name.* TO 'your_username'@'localhost';
```
10. 导入数据到新创建的数据库中:
```mysql
USE your_database_name;
source /path/to/your/sql/file.sql;
```
11. 退出MySQL客户端:
```mysql
exit;
```
相关推荐
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![doc](https://img-home.csdnimg.cn/images/20210720083327.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)