如何在Linux下安装MySQL8.0

逃离我推掉我的手 2022-12-30 03:55 108阅读 0赞

# 如何在Linux下安装MySQL8.0 #

## 准备工作： ##

mysql8.0 rpm文件

测试工具（比如 idea的database工具）

## 安装步骤： ##

1. 下载mysql的repo源，下载地址：[https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm][https_dev.mysql.com_get_mysql80-community-release-el7-1.noarch.rpm]

进入Linux系统，输入指令：

wgethttps://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm

![70][]

2.安装mysql-community-release-el7-5.noarch.rpm包

输入指令：sudo rpm -ivh mysql80-community-release-el7-1.noarch.rpm

![70 1][]

安装这个包后，会获得两个mysql的yum repo源：/etc/yum.repos.d/mysql-community.repo，/etc/yum.repos.d/mysql-community-source.repo。

3.安装mysql

输入指令：sudo yum install mysql-server

![70 2][]

![70 3][]

![70 4][]

![70 5][]

![70 6][]

![70 7][]

根据提示安装就可以了,不过安装完成后没有密码,需要重置密码

4. 登录时有可能报这样的错：ERROR2002 (HY000): Can‘t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock‘ (2)，原因是/var/lib/mysql的访问权限问题。下面的命令把/var/lib/mysql的拥有者改为当前用户：

输入指令：mysql -u root

![70 8][]

输入指令：sudo chown -R root:root /var/lib/mysql

![70 9][]

输入指令：service mysqld restart

![70 10][]

等重新完成后在输入mysql -u root 就可以看到如下，但是现在又提醒密码错误的信息，输入指令获取随机密码

![70 11][]

生成随机密码

输入指令：grep 'temporary password' /var/log/mysqld.log

![70 12][]

![70 13][]

当我去查询用户的时候报这个错误：You must reset your password using ALTER USER statement beforeexecuting this statement

大致意思是说：在执行此语句之前，必须使用ALTE USER语句重设密码。

![70 14][]

然后我执行修改密码的操作：

又报：Your password does not satisfy the current policy requirements

大致意思是说：您的密码不符合当前的策略要求。

![70 15][]

注意：如果只想设置简单密码需要修改两个全局参数：

mysql> set globalvalidate\_password\_policy=0;

mysql> set globalvalidate\_password\_length=1;

（这里我没过试，不知道是否可用，我用的复杂密码）

## 远程连接 ##

1。 改表发。

可能是你的帐号不允许从远程登陆，只能在localhost。这个时候只要在localhost的那台电脑，登入mysql后，更改 "mysql" 数据库里的 "user" 表里的 "host" 项，从"localhost"改成"%"

Sql代码

1.mysql -u root -pvmwaremysql>use mysql;

2.mysql>update user set host = '%' where user = 'root';

3.mysql>select host, user from user;

2. 授权法。

例如，你想myuser使用mypassword从任何主机连接到mysql服务器的话。

Sql代码

1.GRANT ALL PRIVILEGES ON \*.\* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH

GRANT OPTION;

2.FLUSH PRIVILEGES;

如果你想允许用户myuser从ip为192.168.1.6的主机连接到mysql服务器，并使用mypassword作为密码

这里我使用了改表发，执行授权法一直报错，我不知道是不是因为我MySQL8.0的原因。

然后重启服务：service mysqld restart

这里我是使用的idea自带的一个database工具进行测试连接，连接成功。

![70 16][]

到这里，整个MySQL8.0就安装完成了。

[https_dev.mysql.com_get_mysql80-community-release-el7-1.noarch.rpm]: https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm
[70]: /images/20221120/3ff1c9b836064930b589d08349a129cf.png
[70 1]: /images/20221120/60cbc8537c4e4497a1311e386c700a0a.png
[70 2]: /images/20221120/62676698d5dd47d0b9feed2046e18ec0.png
[70 3]: https://img-blog.csdn.net/20180425125837153?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM1MDk4NTI2/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70
[70 4]: https://img-blog.csdn.net/20180425125844507?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM1MDk4NTI2/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70
[70 5]: https://img-blog.csdn.net/20180425125851246?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM1MDk4NTI2/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70
[70 6]: https://img-blog.csdn.net/20180425125859917?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM1MDk4NTI2/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70
[70 7]: https://img-blog.csdn.net/20180425125907765?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM1MDk4NTI2/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70
[70 8]: https://img-blog.csdn.net/20180425125923511?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM1MDk4NTI2/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70
[70 9]: https://img-blog.csdn.net/20180425125930814?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM1MDk4NTI2/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70
[70 10]: https://img-blog.csdn.net/20180425125939453?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM1MDk4NTI2/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70
[70 11]: https://img-blog.csdn.net/20180425125946250?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM1MDk4NTI2/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70
[70 12]: https://img-blog.csdn.net/20180425125954304?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM1MDk4NTI2/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70
[70 13]: https://img-blog.csdn.net/20180425130000461?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM1MDk4NTI2/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70
[70 14]: https://img-blog.csdn.net/20180425130009236?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM1MDk4NTI2/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70
[70 15]: https://img-blog.csdn.net/2018042513001917?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM1MDk4NTI2/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70
[70 16]: https://img-blog.csdn.net/20180425130032149?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM1MDk4NTI2/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70