1500字范文 > 如何在Ubuntu上安装MySQL

如何在Ubuntu上安装MySQL

时间：2023-04-07 20:55:05

相关推荐

如何在Ubuntu上安装MySQL

In this article, it will be shown how to install MySQL 5.7 and 8.0.19 versions on an Ubuntu 18.04 machine.

在本文中，将展示如何在Ubuntu 18.04计算机上安装MySQL 5.7和8.0.19版本。

MySQL is one of the most popular open-source relational database management systems and can be run on almost all platforms such as MS Windows, Linux, UNIX.

MySQL是最流行的开源关系数据库管理系统之一，可以在几乎所有平台上运行，例如MS Windows，Linux和UNIX。

先决条件 (Prerequisite)

To follow this article, Linux Ubuntu 18.04 must be installed on the machine.

要遵循本文，必须在计算机上安装Linux Ubuntu 18.04 。

By default, the latest MySQL version is included in the APT package repository. At the time of writing this article, it is MySQL 5.7 version. To install MySQL 8 version, you must manually add MySQL’s repository.

默认情况下，最新MySQL版本包含在APT软件包存储库中。在撰写本文时，它是MySQL 5.7版本。要安装MySQL 8版本，必须手动添加MySQL的存储库。

安装MySQL 5.7服务器 (Install MySQL 5.7 server)

The first command that needs to be executed via the terminal is:

需要通过终端执行的第一个命令是：

sudo apt update

This command will update the local repository index.

该命令将更新本地存储库索引。

To install MySQL from the APT repository, run the following command:

要从APT存储库安装MySQL，请运行以下命令：

sudo apt install MySQL-server

During the process of the installation, the[Y/n]question to continue with the installation may appear, press theYkey from the keyboard, and hitEnter. This will install MySQL on the system.

在安装过程中，可能会出现[Y / n]问题以继续安装，请按键盘上的Y键，然后按Enter键。这将在系统上安装MySQL。

To verify the version of installed MySQL, execute the following command:

要验证已安装MySQL版本，请执行以下命令：

mysql --version

After the installation, the MySQL server should start automatically. To check if it’s running, execute the following command:

安装后，MySQL服务器应自动启动。要检查它是否正在运行，请执行以下命令：

systemctl status mysql.service

If, for some reasons, MySQL server is not running, execute the following command to start the MySQL server:

如果由于某些原因MySQL服务器未运行，请执行以下命令以启动MySQL服务器：

sudo systemctl start mysql

配置MySQL服务器 (Configure MySQL server)

To improve the security of MySQL installation, use the mysql_secure_installation command:

为了提高MySQL安装的安全性，请使用mysql_secure_installation命令：

sudo mysql_secure_installation

After you press theEnterkey, the first thing that will appear is theVALIDATE PASSWORDplugin prompt window:

在按Enter键之后，将出现的第一件事是VALIDATE PASSWORD插件提示窗口：

This step is to set up a secure password for therootuser, depending on which type of password is chosen. Type theYand pressEnter. Enter the number for the password strength and press theEnterkey:

此步骤是为root用户设置安全密码，具体取决于选择的密码类型。输入Y并按Enter键。输入密码强度数字，然后按Enter键：

On the next screen, enter and re-enter the password:

在下一个屏幕上，输入并重新输入密码：

On the next step, the strength of the entered password will be shown and also will be prompted with the question to continue with the provided password. ChoseYand press theEnterkey:

下一步，将显示输入密码的强度，并提示您输入密码以继续输入的密码。选择Y并按Enter键：

In the next couple of steps, you will be prompted with the questions and, depending on the answers you provide, the security on your system will be set.

在接下来的两个步骤中，将提示您一些问题，并根据您提供的答案来设置系统的安全性。

The first question is about removing anonymous test users. PressYand hit theEnterkey:

第一个问题是有关删除匿名测试用户的信息。按Y并按Enter键：

The next question is about forbidding root login from remote systems. It is recommended for arootuser to allow the connection from the local system and deny it from the remote connections. ChoseYand hit theEnterkey:

下一个问题是关于禁止远程系统的root登录。建议root用户允许来自本地系统的连接，并拒绝来自远程连接的连接。选择Y并按Enter键：

The next question will be to remove the ‘test’ database. If you want to remove it, pressYand hit theEnterkey:

下一个问题是删除“测试”数据库。如果要删除它，请按Y并按Enter键：

In the last step, you will be asked to reload privilege tables in order for the above-mentioned changes to take effect. PressYand hitEnterand all security settings will be committed:

在最后一步中，将要求您重新加载特权表，以使上述更改生效。按Y键，然后按Enter键，所有安全设置将被提交：

After the privilege tables are reloaded, the “All done!” message should appear:

重新加载特权表后，“全部完成！” 消息应该出现：

Now, when all is set, let’s login to MySQL with therootuser. In the terminal, type the following command:

现在，完成所有设置后，让我们以root用户登录MySQL。在终端中，键入以下命令：

mysql -u root -p

Insert a password for therootuser and hitEnter. Instead of login to the MySQL instance, you will get the following message:

输入root用户的密码，然后按Enter。您将收到以下消息，而不是登录MySQL实例：

zivko@Zivko2:~$ mysql -u root -p

Enter password:

ERROR 1698 (28000): Access denied for user ‘root’@’localhost’

zivko @ Zivko2：〜$ mysql -u root -p

输入密码：

错误1698（28000）：用户'root'@'localhost'的访问被拒绝

By default, therootuser is to use the auth_socket plugin authentication method rather than the password. To set therootuser to use a password to connect to MySQL instance, the authentication method needs to be changed from theauth_socketto the mysql_native_password method.

默认情况下，root用户将使用auth_socket插件身份验证方法，而不是密码。要设置root用户使用密码连接到MySQL实例，需要将身份验证方法从auth_socket更改为mysql_native_password方法。

To do this, firstly, connect to the MySQL instance using thesudocommand in front of the MySQL user:

为此，首先，在MySQL用户前面使用sudo命令连接到MySQL实例：

sudo mysql -u root -p

To check which authentication method each MySQL user uses, type the following command:

要检查每个MySQL用户使用哪种身份验证方法，请键入以下命令：

SELECT user,authentication_string,plugin,host FROM mysql.user;

As can be seen from the image above, therootuser uses theauth_socketplugin. To set to root user authenticate with a password, execute the following command:

从上图可以看出，root用户使用auth_socket插件。要设置使用密码对root用户进行身份验证，请执行以下命令：

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '<set password>';

After executing theALTER USERcommand, run the following command:

执行ALTER USER命令后，运行以下命令：

FLUSH PRIVILEGES;

This command will reload the grant tables and make the changes take effect. When checking which authentication method is used by therootuser, you’ll get this:

此命令将重新加载授权表并使更改生效。在检查root用户使用哪种身份验证方法时，您将获得以下信息：

Now, when trying to login to MySQL using therootuser, you’ll be logged without any problems:

现在，当尝试使用root用户登录MySQL时，您将被顺利登录：

安装MySQL 8服务器 (Install MySQL 8 server)

If you want to install the latest MySQL version, in this case, MySQL 8 version, the first thing that needs to be done is to download the latest release package using the wget command from the MySQL APT Repository:

如果要安装最新MySQL版本（在这种情况下为MySQL 8版本），则需要做的第一件事是使用MySQL APT存储库中的wget命令下载最新的发行包：

wget -c /get/mysql-apt-config_0.8.15-1_all.deb

To install MySQL package, execute the command below:

要安装MySQL软件包，请执行以下命令：

sudo dpkg -i mysql-apt-config_0.8.15-1_all.deb

In the first window that will be shown, select the first line and hit theEnterkey:

在将显示的第一个窗口中，选择第一行并按Enter键：

In the second window, the MySQL version can be selected. Here, you can choose between MySQL 8.0 or 5.7 version. Choose MySQL 8.0 version and press theEnterkey to proceed:

在第二个窗口中，可以选择MySQL版本。在这里，您可以选择MySQL 8.0或5.7版本。选择MySQL 8.0版本，然后按Enter键继续：

Now, select the last line with theOktext and press theEnterkey to continue:

现在，选择带有“确定”文本的最后一行，然后按Enter键继续：

Now, in terminal to download the latest package information from all repositories including the recently added MySQL repository, execute the following command:

现在，在终端上从所有存储库下载最新的软件包信息，包括最近添加MySQL存储库，执行以下命令：

sudo apt update

To install MySQL 8, execute again the command that we used to install MySQL 5.7 version:

要安装MySQL 8，再次执行用于安装MySQL 5.7版本的命令：

sudo apt install MySQL-server

In the beginning, it will be prompted to insert a password for therootuser. Enter the password and pressEnter:

首先，将提示您为root用户插入密码。输入密码，然后按Enter键：

In the next window, insert the password again for therootuser and hitEnter:

在下一个窗口中，再次输入root用户的密码，然后按Enter键：

Next, some information about the new authentication system based onSHA256-basedpassword methods will be shown, use the right arrow to select theOkbutton and hitEnterto proceed:

接下来，将显示有关基于基于SHA256的密码方法的新身份验证系统的一些信息，使用向右箭头选择“确定”按钮，然后按Enter继续：

In the next window, you will be asked to choose the authentication plugin, select the first one, and hitEnter:

在下一个窗口中，将要求您选择身份验证插件，选择第一个，然后按Enter：

After this step, the installation of MySQL 8 will proceed, and the server will be installed in your system. To check the installed MySQL version, use the following command:

完成此步骤后，将继续安装MySQL 8，并将服务器安装在您的系统中。要检查已安装MySQL版本，请使用以下命令：

mysql -V

To see more information about MySQL server, execute the following command:

要查看有关MySQL服务器的更多信息，请执行以下命令：

mysqladmin -u root -p version