MySQL：Centos8安装Mysql8。

我不是女神ヾ 2022-12-14 09:07 224阅读 0赞

# 下载安装包 #

wget https://repo.mysql.com//mysql80-community-release-el8-1.noarch.rpm

![在这里插入图片描述][20200410192926535.png]

# 使用rpm安装 #

rpm -ivh mysql80-community-release-el8-1.noarch.rpm

![在这里插入图片描述][2020041019294434.png]

# 使用yum安装mysql服务 #

yum install mysql-server

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTI1OTA3MTg_size_16_color_FFFFFF_t_70]

输入y  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTI1OTA3MTg_size_16_color_FFFFFF_t_70 1]

# 检查是否已经设置为开机启动MySQL服务 #

systemctl list-unit-files|grep mysqld

![在这里插入图片描述][20200411071547861.png]

# 设置开机启动 #

systemctl enable mysqld.service

![在这里插入图片描述][2020041107180916.png]

# 再次检查 #

systemctl list-unit-files|grep mysqld

![在这里插入图片描述][20200411071911538.png]

# 查看是否启动MySQL服务 #

ps -ef|grep mysql

![在这里插入图片描述][20200411072023310.png]

# 启动服务 #

systemctl start mysqld.service

# 再次检查 #

ps -ef|grep mysql

![在这里插入图片描述][2020041107231294.png]

# 连接mysql #

mysql

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTI1OTA3MTg_size_16_color_FFFFFF_t_70 2]

# 查看数据库  #

mysql8.默认密码是空，但是因为习惯还是修改下密码

show databases;

![在这里插入图片描述][20200411072736135.png]

# 修改密码 #

alter user 'root'@'localhost' identified by 'Aliwang!123';

![在这里插入图片描述][20200411072827112.png]

# 退出 #

exit

# 测试root用户，然后输入上面修改的密码 #

mysql -u root -p

![在这里插入图片描述][20200411073019430.png]

# ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTI1OTA3MTg_size_16_color_FFFFFF_t_70 3]   创建用户 #

*  语法：CREATE USER ‘用户名’@’%’ IDENTIFIED BY ‘密码’;

CREATE USER 'aliwang'@'%' IDENTIFIED BY 'aliwang';

![在这里插入图片描述][20200411073801862.png]

# 授权 #

*  语法：GRANT ALL PRIVILEGES ON *.* TO ‘用户名’@’%’ WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON *.* TO 'aliwang'@'%' WITH GRANT OPTION;

![在这里插入图片描述][2020041107390630.png]

# 立即生效 #

flush privileges;

![在这里插入图片描述][20200411073955499.png]

# 设置root用户远程可以访问 #

## 使用mysql 数据库 ##

use mysql;

![在这里插入图片描述][20200411080142355.png]

## host 修改 ##

update user set host='%' where user='root';

![在这里插入图片描述][20200411080254384.png]

## 指定用户的授权  ##

第一次执行可能会报错，再执行一次就ok了

grant all privileges on aliwang.* to root@'%';

![在这里插入图片描述][20200411080402908.png]

## 立即生效 ##

flush privileges;

![在这里插入图片描述][20200411073955499.png]

## 退出 ##

exit

![在这里插入图片描述][2020041108055224.png]

# 因为安全原因修改默认端口 **(自选)** #

## 打开配置文件 ##

vim /etc/my.cnf.d/mysql-server.cnf

1![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTI1OTA3MTg_size_16_color_FFFFFF_t_70 4]

## 添加端口配置 ##

*  语法：port=端口号

port=3307

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTI1OTA3MTg_size_16_color_FFFFFF_t_70 5]

## 保存退出 ##

Esc => :wq

## 重启mysql ##

systemctl restart mysqld

## 查看端口监听 ##

netstat -lnpt

![在这里插入图片描述][20200411081828922.png]

[20200410192926535.png]: /images/20221123/935ad6c06b7a4d2e8af586b8c4428ae5.png
[2020041019294434.png]: /images/20221123/97886389d3914fd9bbce535e1a5b3a6e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTI1OTA3MTg_size_16_color_FFFFFF_t_70]: /images/20221123/63b4842d894540ceaa6b8006e14d5c9f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTI1OTA3MTg_size_16_color_FFFFFF_t_70 1]: /images/20221123/c392801b83104116b1f1884851b78787.png
[20200411071547861.png]: /images/20221123/54cd2c120113456c861c68c40946eff7.png
[2020041107180916.png]: /images/20221123/e8f2eb9b535144e493e77491128b7feb.png
[20200411071911538.png]: /images/20221123/da95fc9fea3c4f95a311ba6a70d34b22.png
[20200411072023310.png]: /images/20221123/37198d7d258c4287988dbc36c41f8294.png
[2020041107231294.png]: /images/20221123/586181d5e036411191ca81622450c0a7.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTI1OTA3MTg_size_16_color_FFFFFF_t_70 2]: /images/20221123/4cac41e7bbac4fe99b53e23c184b618b.png
[20200411072736135.png]: /images/20221123/8b9c85ca59344a72b7f96c1d70aa63f5.png
[20200411072827112.png]: /images/20221123/552c0206f5ae49168a18074a15abbdb9.png
[20200411073019430.png]: /images/20221123/37e3d92ac1684bd1b3c2c1af814e7d2e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTI1OTA3MTg_size_16_color_FFFFFF_t_70 3]: /images/20221123/711e9532f58845bab65a7dbac956b01c.png
[20200411073801862.png]: /images/20221123/ea5c3ebcb8e34cdfa1b7edb5c2930921.png
[2020041107390630.png]: /images/20221123/f414dda6c29446eb8ceaac7c36c6f7ad.png
[20200411073955499.png]: /images/20221123/8e3d51fb8e4b4ae1a98b95a6d440e555.png
[20200411080142355.png]: /images/20221123/d0a748dfc8914c779bd7dc1eb7005780.png
[20200411080254384.png]: /images/20221123/569b4b875fc1458a95d1fdbc60af61f5.png
[20200411080402908.png]: /images/20221123/7f68d803f16d4e9886136e4fdae4544b.png
[2020041108055224.png]: /images/20221123/5b2ecde577da48f5b422d3e663402f30.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTI1OTA3MTg_size_16_color_FFFFFF_t_70 4]: /images/20221123/fd65addb858d4709bbbffd3775b5cf27.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTI1OTA3MTg_size_16_color_FFFFFF_t_70 5]: /images/20221123/a856767ad05a446287116acd0deadd73.png
[20200411081828922.png]: /images/20221123/6407ddeccd624ac5bfe1ba233fd1c84c.png