Cài đặt Mysql 8 trên Amazon linux 2023

[ec2-user@ip-172-31-32-xxx ~]$ cat /etc/os-release
NAME="Amazon Linux"
VERSION="2023"
ID="amzn"
ID_LIKE="fedora"
VERSION_ID="2023"
PLATFORM_ID="platform:al2023"
PRETTY_NAME="Amazon Linux 2023"
ANSI_COLOR="0;33"
CPE_NAME="cpe:2.3:o:amazon:amazon_linux:2023"
HOME_URL="https://aws.amazon.com/linux/"
BUG_REPORT_URL="https://github.com/amazonlinux/amazon-linux-2023"
SUPPORT_END="2028-03-01"

[ec2-user@ip-172-31-32-xxx ~]$ pwd
/home/ec2-user

sudo wget https://dev.mysql.com/get/mysql80-community-release-el9-1.noarch.rpm 

Dependencies Resolved

======================================================================================================================================================================================================
 Package                                               Arch                               Version                           Repository                                                           Size
======================================================================================================================================================================================================
Installing:
 mysql80-community-release                             noarch                             el7-5                             /mysql80-community-release-el7-5.noarch                             9.1 k

Transaction Summary
======================================================================================================================================================================================================
Install  1 Package

Total size: 9.1 k
Installed size: 9.1 k
Is this ok [y/d/N]: y

sudo ls -lrt

[ec2-user@ip-172-31-32-xxx ~]$ sudo ls -lrt
total 12
-rw-r--r--. 1 root root 10534 Jul 25  2022 mysql80-community-release-el9-1.noarch.rpm

sudo yum repolist
ls /etc/yum.repos.d

[ec2-user@ip-172-31-32-xxx ~]$ ls /etc/yum.repos.d
amazonlinux.repo       mysql-community-debuginfo.repo  mysql-community.repo
kernel-livepatch.repo  mysql-community-source.repo

sudo dnf install mysql80-community-release-el9-1.noarch.rpm
dnf repolist enabled | grep "mysql.*-community.*"
sudo dnf install mysql-community-server

sudo systemctl start mysqld

[ec2-user@ip-172-31-32-xxx]$ sudo mysql -V
mysql  Ver 8.0.34 for Linux on x86_64 (MySQL Community Server - GPL)

sudo grep 'temporary password' /var/log/mysqld.log

sudo mysql_secure_installation -p

Securing the MySQL server deployment.


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

New password: <MẬT KHẨU MỚI>

Re-enter new password: <NHẬP LẠI MẬT KHẨU>
The 'validate_password' component is installed on the server.
The subsequent steps will run with the existing configuration
of the component.
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) :

 ... skipping.
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!

mysql -uroot -pMatKhauVuaThayDoi2023@@

create database db_new;

CREATE USER 'user_db'@'localhost' IDENTIFIED BY 'Matkhau2023@@';

GRANT ALL PRIVILEGES ON db_new.* TO 'user_db'@'localhost';
FLUSH PRIVILEGES;
exit;

mysql -uuser_db -pMatkhau2023@@

sudo service mysqld status

Redirecting to /bin/systemctl status mysqld.service
● mysqld.service - MySQL Server
     Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; preset: d>
     Active: active (running) since Mon 2023-07-31 10:10:56 UTC; 2 weeks 2 days>
       Docs: man:mysqld(8)
             http://dev.mysql.com/doc/refman/en/using-systemd.html
   Main PID: 250921 (mysqld)
     Status: "Server is operational"
      Tasks: 46 (limit: 2322)
     Memory: 575.6M
        CPU: 2h 19min 306ms
     CGroup: /system.slice/mysqld.service
             └─250921 /usr/sbin/mysqld

mysqldump -u user_db -pMatkhau2023@@ db_export > ./db_backup.sql

mysql -u username -p db_export < db_backup.sql