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
  • 2 Users Found This Useful
Was this answer helpful?

Related Articles

Protect SSH with Fail2Ban on CentOS 6

Fail2Ban is an SSH security program that blocks SSH brute force attempts on your server (as well...

Install Minecraft Pocket Edition Server (Nukkit) on CentOS 7 64-bit

Installing Minecraft: Pocket Edition servers has never been easier with the advent of Nukkit (the...

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....

How to Use the VPS Serial Console

The VPS serial console allows you to access your cloud VPS server with SSH directly from the back...