Elastic Compute Service:Install MySQL on a Linux instance

Connect to an ECS instance. For more information, see Use Workbench to connect to a Linux instance over SSH.

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

Query the default initial password of the root user.

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

Run the following command to configure MySQL security settings:

sudo mysql_secure_installation

1. Enter the initial password of the root user.

   Note

   The password characters are hidden when you enter the password. Make sure that the password that you enter is correct.

   

2. If an error message indicating that the root password expired appears, specify a new password for the root user by entering the new password twice.

   Important

   The password must be at least eight characters in length, and contain at least one uppercase letter, one lowercase letter, one digit, and one special character.

   

3. After you change the root password, enter n to skip re-specifying a new password.

4. Enter y to remove the anonymous user.

   Note

   This prevents unauthorized users from skipping the step of entering valid credentials and accessing your MySQL server.

   

5. Enter y to prevent the root user from accessing MySQL.

   Note

   If you want to allow the root user to connect to the MySQL server in specific scenarios, press a key other than y to allow remote root user logons.

   

6. Enter y to remove the pre-installed test database of the MySQL server.

7. Enter y to reload the permissions table to allow the preceding modifications to take effect.

Connect to an ECS instance. For more information, see Use Workbench to connect to a Linux instance over SSH.

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

Query the default initial password of the root user.

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

Run the following command to configure MySQL security settings:

sudo mysql_secure_installation

1. Enter the initial password of the root user.

   Note

   The password characters are hidden when you enter the password. Make sure that the password that you enter is correct.

   

2. If an error message indicating that the root password expired appears, specify a new password for the root user by entering the new password twice.

   Important

   The password must be at least eight characters in length, and contain at least one uppercase letter, one lowercase letter, one digit, and one special character.

   

3. After you change the root password, enter n to skip re-specifying a new password.

4. Enter y to remove the anonymous user.

   Note

   This prevents unauthorized users from skipping the step of entering valid credentials and accessing your MySQL server.

   

5. Enter y to prevent the root user from accessing MySQL.

   Note

   If you want to allow the root user to connect to the MySQL server in specific scenarios, press a key other than y to allow remote root user logons.

   

6. Enter y to remove the pre-installed test database of the MySQL server.

7. Enter y to reload the permissions table to allow the preceding modifications to take effect.

Connect to an ECS instance. For more information, see Use Workbench to connect to a Linux instance over SSH.

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 following command to configure MySQL security settings:

sudo mysql_secure_installation

1. Enter y to enable the VALIDATE PASSWORD component.

2. Enter 2. The password must be at least eight characters in length, and contain at least one uppercase letter, one lowercase letter, one digit, and one special character.

3. To specify a new password for the root user, enter the new password twice.

   Important

   The password must be at least eight characters in length, and contain at least one uppercase letter, one lowercase letter, one digit, and one special character.

   

4. Enter y to continue using the provided password.

5. Enter y to remove the anonymous user.

   Note

   This prevents unauthorized users from skipping the step of entering valid credentials and accessing your MySQL server.

   

6. Enter y to prevent the root user from accessing MySQL.

   Note

   If you want to allow the root user to connect to the MySQL server in specific scenarios, press a key other than y to allow remote root user logons.

   

7. Enter y to remove the pre-installed test database of the MySQL server.

8. Enter y to reload the permissions table to allow the preceding modifications to take effect.

Connect to an ECS instance. For more information, see Use Workbench to connect to a Linux instance over SSH.

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

Query the default initial password of the root user.

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

Run the following command to configure MySQL security settings:

sudo mysql_secure_installation

1. Enter the initial password of the root user.

   Note

   The password characters are hidden when you enter the password. Make sure that the password that you enter is correct.

   

2. If an error message indicating that the root password expired appears, specify a new password for the root user by entering the new password twice.

   Important

   The password must be at least eight characters in length, and contain at least one uppercase letter, one lowercase letter, one digit, and one special character.

   

3. After you change the root password, enter n to skip re-specifying a new password.

4. Enter y to remove the anonymous user.

   Note

   This prevents unauthorized users from skipping the step of entering valid credentials and accessing your MySQL server.

   

5. Enter y to prevent the root user from accessing MySQL.

   Note

   If you want to allow the root user to connect to the MySQL server in specific scenarios, press a key other than y to allow remote root user logons.

   

6. Enter y to remove the pre-installed test database of the MySQL server.

7. Enter y to reload the permissions table to allow the preceding modifications to take effect.

Connect to an ECS instance. For more information, see Use Workbench to connect to a Linux instance over SSH.

Run the following command to update the system Advanced Packaging Tool (APT) repository and ensure that the system package list is updated:

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 the mysql-apt-config script detects that the operating system version is not officially supported, the system prompts you to select the closest supported version to proceed with installation.

   Note

   For information about how to obtain the system alias, see How do I obtain the system alias of a Ubuntu or Debian instance?

   

2. The configuration page displays all components that must be installed, such as MySQL Server, MySQL Client, and required tools. Confirm the version and components that you want to install, press the down arrow key to select OK, and then press the Enter key.

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 following command to configure MySQL security settings:

sudo mysql_secure_installation

1. Enter the root password.

2. Enter y to enable the VALIDATE PASSWORD component.

3. Enter 2. The password must be at least eight characters in length, and contain at least one uppercase letter, one lowercase letter, one digit, and one special character.

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 the anonymous user.

   Note

   This prevents unauthorized users from skipping the step of entering valid credentials and accessing your MySQL server.

   

6. Enter y to prevent the root user from accessing MySQL.

   Note

   If you want to allow the root user to connect to the MySQL server in specific scenarios, press a key other than y to allow remote root user logons.

   

7. Enter y to remove the pre-installed test database of the MySQL server.

8. Enter y to reload the permissions table to allow the preceding modifications to take effect.