如何在Amazon Linux上安装MySQL 5.7

时间:2019-05-19 01:26:21  来源:igfitidea点击:

MySQL是一个关系数据库系统。在上一个教程中,我们在Amazon Linux上安装了Apache和PHP。本教程将在Amazon Linux系统上安装MySQL 5.7。

步骤1–准备工作

登录到Fedora系统并打开一个终端。现在通过运行以下命令将当前包升级到最新版本。

yum update

步骤2-安装MySQL服务器

之后,运行以下命令在系统上安装MySQL 5.7包。这也将安装所有其他必需的依赖项。

yum install mysql57-server

在Fedora系统上安装MySQL服务器之后。在系统启动时启用MySQL服务。另外,使用以下命令启动服务:

service mysqld start
chkconfig mysqld on

好的,现在按照安装后的说明操作。

步骤3–安装后设置

MySQL社区版服务器已经安装在系统上。现在运行以下命令在MySQL服务器上应用安全性。只需执行下面的命令并遵循安全向导。

mysql_secure_installation

按照屏幕上的说明操作。更改根帐户密码并按Y键执行所有其他操作以应用改进的安全性。

VALIDATE PASSWORD PLUGIN can be used to test passwords
and improve security. It checks the strength of password
and allows the users to set only those passwords which are
secure enough. Would you like to setup VALIDATE PASSWORD plugin?

Press y|Y for Yes, any other key for No:   **y**  

There are three levels of password validation policy:

LOW    Length >= 8
MEDIUM Length >= 8, numeric, mixed case, and special characters
STRONG Length >= 8, numeric, mixed case, special characters and dictionary                  file

Please enter 0 = LOW, 1 = MEDIUM and 2 = STRONG:  ** 0**  
Please set the password for root here.

New password:

Re-enter new password:

Estimated strength of the password: 100
Do you wish to continue with the password provided?(Press y|Y for Yes, any other key for No) :  ** y**  
By default, a MySQL installation has an anonymous user,
allowing anyone to log into MySQL without having to have
a user account created for them. This is intended only for
testing, and to make the installation go a bit smoother.
You should remove them before moving into a production
environment.

Remove anonymous users? (Press y|Y for Yes, any other key for No) :  ** y**  
Success.

Normally, root should only be allowed to connect from
'localhost'. This ensures that someone cannot guess at
the root password from the network.

Disallow root login remotely? (Press y|Y for Yes, any other key for No) :  ** y**  
Success.

By default, MySQL comes with a database named 'test' that
anyone can access. This is also intended only for testing,
and should be removed before moving into a production
environment.

Remove test database and access to it? (Press y|Y for Yes, any other key for No) :  ** y**  
 - Dropping test database...
Success.

 - Removing privileges on test database...
Success.

Reloading the privilege tables will ensure that all changes
made so far will take effect immediately.

Reload privilege tables now? (Press y|Y for Yes, any other key for No) :  ** y**  
Success.

All done!

步骤4-连接MySQL终端

一切都结束了。现在可以使用命令行连接到MySQL服务器。以下命令将以根用户身份连接在localhost上运行的MySQL。这将提示输入root帐户密码。

$ mysql -u root -p

Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.7.25 MySQL Community Server (GPL)

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>