Elastic Compute Service:Install MySQL on a Linux instance

Connect to an ECS instance. For more information, see Connect to Linux.

Install MySQL.

# Install compat-openssl10, which is compatible with earlier versions of OpenSSL libraries. 
sudo yum install -y compat-openssl10
# Add an official MySQL repository.
sudo rpm -Uvh https://repo.mysql.com/mysql84-community-release-el8-1.noarch.rpm
# Install MySQL.
sudo dnf install -y mysql-server
# Start and configure MySQL to automatically start on system startup.
sudo systemctl start mysqld
sudo systemctl enable mysqld

Retrieve the temporary root password.

echo $(PASSWORD=$(sudo grep 'temporary password' /var/log/mysqld.log); PASSWORD=${PASSWORD##* }; echo $PASSWORD)

Run the secure installation script.

sudo mysql_secure_installation

1. Enter the temporary password for the root user.

   Note

   The password is not displayed as you type. Ensure you enter it correctly.

   

2. The root password has expired. The system prompts you to set a new password for the root user. Re-enter the password to confirm.

   Important

   The password policy requires the password to contain at least one uppercase letter, one lowercase letter, one digit, one special character, and be at least 8 characters long.

   

3. When asked if you want to change the password again, enter n.

4. Enter y to remove anonymous users.

   Note

   Removing anonymous users helps prevent unauthorized access to your MySQL server.

   

5. Enter y to disallow remote root login.

   Note

   To allow remote root login, press any key other than Y.

   

6. Enter y to remove the test database.

7. Enter y to reload the privilege tables to apply your changes.

Connect to an ECS instance. For more information, see Connect to Linux.

Install MySQL.

# Add an official MySQL repository.
sudo rpm -Uvh https://repo.mysql.com/mysql84-community-release-el7-1.noarch.rpm
# Install MySQL.
sudo yum install -y mysql-server
# Start and configure MySQL to automatically start on system startup.
sudo systemctl start mysqld
sudo systemctl enable mysqld

Retrieve the temporary root password.

echo $(PASSWORD=$(sudo grep 'temporary password' /var/log/mysqld.log); PASSWORD=${PASSWORD##* }; echo $PASSWORD)

Run the secure installation script.

sudo mysql_secure_installation

1. Enter the temporary password for the root user.

   Note

   The password is not displayed as you type. Ensure you enter it correctly.

   

2. The root password has expired. The system prompts you to set a new password for the root user. Re-enter the password to confirm.

   Important

   The password policy requires the password to contain at least one uppercase letter, one lowercase letter, one digit, one special character, and be at least 8 characters long.

   

3. When asked if you want to change the password again, enter n.

4. Enter y to remove anonymous users.

   Note

   Removing anonymous users helps prevent unauthorized access to your MySQL server.

   

5. Enter y to disallow remote root login.

   Note

   To allow remote root login, press any key other than Y.

   

6. Enter y to remove the test database.

7. Enter y to reload the privilege tables to apply your changes.

Connect to an ECS instance. For more information, see Connect to Linux.

Install MySQL.

# Add an official MySQL repository.
sudo rpm -Uvh https://repo.mysql.com/mysql84-community-release-el8-1.noarch.rpm
# Install MySQL.
sudo dnf install -y mysql-server
# Start and configure MySQL to automatically start on system startup.
sudo systemctl start mysqld
sudo systemctl enable mysqld

Run the secure installation script.

sudo mysql_secure_installation

1. Enter y to use the VALIDATE PASSWORD component.

2. Enter 2 to set the password validation policy to STRONG. This policy requires passwords to contain at least one uppercase letter, one lowercase letter, one digit, one special character, and be at least 8 characters long.

3. Set a new password for the root user and enter it twice to confirm.

   Important

   The password must meet the requirements of the validation policy you selected.

   

4. Enter y to continue with the password you provided.

5. Enter y to remove anonymous users.

   Note

   Removing anonymous users helps prevent unauthorized access to your MySQL server.

   

6. Enter y to disallow remote root login.

   Note

   To allow remote root login, press any key other than Y.

   

7. Enter y to remove the test database.

8. Enter y to reload the privilege tables to apply your changes.

Connect to an ECS instance. For more information, see Connect to Linux.

Install MySQL.

# Add an official MySQL repository.
sudo rpm -Uvh https://repo.mysql.com/mysql84-community-release-el7-1.noarch.rpm
# Install MySQL.
sudo yum install -y mysql-server
# Start and configure MySQL to automatically start on system startup.
sudo systemctl start mysqld
sudo systemctl enable mysqld

Retrieve the temporary root password.

echo $(PASSWORD=$(sudo grep 'temporary password' /var/log/mysqld.log); PASSWORD=${PASSWORD##* }; echo $PASSWORD)

Run the secure installation script.

sudo mysql_secure_installation

1. Enter the temporary password for the root user.

   Note

   The password is not displayed as you type. Ensure you enter it correctly.

   

2. The root password has expired. The system prompts you to set a new password for the root user. Re-enter the password to confirm.

   Important

   The password policy requires the password to contain at least one uppercase letter, one lowercase letter, one digit, one special character, and be at least 8 characters long.

   

3. When asked if you want to change the password again, enter n.

4. Enter y to remove anonymous users.

   Note

   Removing anonymous users helps prevent unauthorized access to your MySQL server.

   

5. Enter y to disallow remote root login.

   Note

   To allow remote root login, press any key other than Y.

   

6. Enter y to remove the test database.

7. Enter y to reload the privilege tables to apply your changes.

Connect to an ECS instance. For more information, see Connect to Linux.

Update your system's package index.

sudo apt-get update

Install the MySQL APT repository.

# Download the APT configuration package.
sudo wget https://dev.mysql.com/get/mysql-apt-config_0.8.33-1_all.deb
# Run the dpkg command to install the MySQL APT configuration package that you downloaded.
sudo dpkg -i mysql-apt-config_0.8.33-1_all.deb

1. Optional. If mysql-apt-config detects an unsupported OS version, an interface appears. Select the closest supported version to continue the installation.

   Note

   To find your system's codename, see What do I do if I cannot start MySQL due to the "Permission denied" error?

   

2. The configuration page lists all components to be installed. Verify that the correct version and components are selected, then use the arrow keys to navigate to Ok and press Enter.

Install the MySQL server.

# Update the package list.
sudo apt update
# Install the MySQL server.
sudo apt install -y mysql-server
# Start the MySQL service.
sudo systemctl start mysql
# Check the startup status.
sudo systemctl status mysql
# Configure MySQL to automatically start on system startup. 
sudo systemctl enable mysql

Run the secure installation script.

sudo mysql_secure_installation

1. Enter the root user password you set during installation.

2. Enter y to use the VALIDATE PASSWORD component.

3. Enter 2 to set the password validation policy to STRONG. This policy requires passwords to contain at least one uppercase letter, one lowercase letter, one digit, one special character, and be at least 8 characters long.

4. Enter n to skip changing the password of the root user.

   Note

   To change the password of the root user, enter y.

   

5. Enter y to remove anonymous users.

   Note

   Removing anonymous users helps prevent unauthorized access to your MySQL server.

   

6. Enter y to disallow remote root login.

   Note

   To allow remote root login, press any key other than Y.

   

7. Enter y to remove the test database.

8. Enter y to reload the privilege tables to apply your changes.