Install MySQL Database Server on CentOS

You can install a MySQL database server on CentOS by doing the following:

1. Open your VPS console from the Power Management control panel.
2. Log In to your VPS by entering your username and password.
3. Install the MySQL database server and client using the following command:

   # yum install mysql-server mysql
   

4. Start the MySQL service using the following commands:

   # chkconfig mysqld on
   # /etc/init.d/mysqld start
   

5. Set up a new MySQL root password using the following command:

   # mysqladmin -u root password NEW PASSWORD
   

6. To test connectivity, Run and log in with the provided password:

   # mysql -u root -p
   

Congratulations, you have installed a MySQL database server on CentOS.