How to Install MySQL and Change User Password on CentOS 7

Installing MySQL on CentOS 7 is a relatively straightforward process, but it requires some attention to detail. In this tutorial, we will walk you through the steps of installing MySQL and changing the default user password.

Before you begin, make sure that your KVM VPS or dedicated server is running on CentOS 7 with root access enabled. If you need help connecting to your server via SSH, refer to our 'tutorial on SSH connection'(link to tutorial).

Step 1: Install MySQL

To install MySQL, you will first need to update your system by typing in the following command:

`sudo yum update -y`

Once the output indicates that the update is complete, you can proceed with installing MySQL using the following command:

`sudo yum install mysql-server -y`

The script will return with a list of packages and ask for confirmation to download and install them. Type `y` and press ENTER for each request.

Step 2: Prepare the Repository

After the installation is complete, you need to prepare the repository so you can later install MySQL packages from it. You can do this by downloading and installing the MySQL repositories using the following command:

`sudo yum install mysql-community-server -y`

At the end of the download, you should see a confirmation message that indicates the installation was successful.

Step 3: Change User Password

Once MySQL is installed, you need to change the default user password. To do this, type the following command:

`mysql_secure_installation`

Follow the prompts to set a new password for the root user. Be sure to choose a strong and unique password.

In this tutorial, we have covered the steps of installing MySQL on CentOS 7 and changing the default user password. With these steps complete, you now have a functional MySQL installation on your server. Remember to keep your system updated and secure by regularly running `sudo yum update -y` and changing passwords for all users.

Centos mysql change user password