Need a Minecraft server? BeastNode offers the highest performance servers with DDoS protection!

Shop for plans now


How to Install a MySQL Server on your CentOS VPS

Install MySQL on your Linux Server

This guide is based on a standard install of CentOS - other distributions are not guaranteed.

To install MySQL, just run these commands:

sudo yum install mysql-server

 

sudo service mysqld start


Set the root password:

mysqladmin -u root password 'passwordhere'

In some cases you may need to use this command instead of the above to set the password (hit enter if it asks for an initial password):

mysql_secure_installation


To access the MySQL shell:

mysql -u root -p


Enter your password created as above and you'll be presented a command line with:

mysql>


Some basic MySQL commands that you can use (all commands must end with a semicolon):


Show all databases:

SHOW DATABASES;


Enter/use a database:

USE databasename;


Show tables (after you used a database):

show tables;


Create a database:

CREATE DATABASE databasename;


Delete a database:

DROP DATABASE databasename;


Exit the MySQL prompt:

\q




MySQL server management commands:


Start the MySQL server:

sudo service mysqld start


Restart the MySQL server:

sudo service mysqld restart


Stop the MySQL server:

sudo service mysqld stop

Was this answer helpful?

 Print this Article

Also Read

How to Use a BeastNode VPS to Backup Your Minecraft Server

This guide will explain the basic steps for you to create your own backup VPS (running on CentOS...

How to install a Starbound server on your VPS (Ubuntu)

Although this guide is for Ubuntu, these same steps may apply to other operating systems/distros....

Common Linux SSH/Shell Commands

This is a list of frequently used Linux SSH/shell commands. It may not apply to all Linux...

Accessing your VPS Server using SFTP (Secure FTP)

There are two ways to access your VPS files - SFTP or via SSH commands. SSH commands are for more...