MySQL-Installation unter Aws Linux 2 und Vorbereitung der Testdaten

MySQL-Installation

füge yum repository hinzu

$ sudo rpm -ivh http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm

MySQL-Installation

$ sudo yum install mysql-community-server

Starten Sie MySQL

$ sudo systemctl start mysqld.service

Erstkennwort für Root-Benutzer

Wird im nächsten Schritt verwendet. → + nu & TAHRi7p =

$ sudo cat /var/log/mysqld.log | grep "temporary password"
2020-06-12T08:50:36.870252Z 1 [Note] A temporary password is generated for root@localhost: +nu&TAHRi7p=

MySQL-Sicherheit

$ mysql_secure_installation

Securing the MySQL server deployment.

Enter password for user root: #Geben Sie das ursprüngliche Passwort ein → Diesmal+nu&TAHRi7p=

The existing password for the user account root has expired. Please set a new password.

New password: #Eingabe eines neuen Passworts für den Root-Benutzer

Re-enter new password: #Eingabe zur Bestätigung
The 'validate_password' plugin is installed on the server.
The subsequent steps will run with the existing configuration
of the plugin.
Using existing password for root.

Estimated strength of the password: 100
Change the password for root ? ((Press y|Y for Yes, any other key for No) : y #Ändern Sie das Root-Benutzerpasswort

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 #Anonymen Benutzer löschen
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 #Remote-Root-Benutzer löschen
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 #Testdatenbank löschen
 - 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 #Starten Sie die Autorisierungstabelle neu
Success.

All done!

Melden Sie sich bei MySQL an

$ mysql -u root -p

Vorbereitung der Testdaten

Testdaten abrufen

Verwenden Sie die offizielle. Offizielle MySQL-Testdaten

Auftauen

$ unzip world.sql.zip

An AWS senden

$ scp world.sql DataLamda_Outer:/home/ec2-user/

Laden Sie in MySQL

$ mysql> SOURCE /home/ec2-user/world.sql;

database.world wird erstellt.