Need a Minecraft server? BeastNode delivers awesome performance at a great value!

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

VPS offline or suspended without notice?

We have an automated anti-abuse system that may suspend your VPS if there is any abusive activity...

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

Disable Firewalld on CentOS 7

If for any reason you need to disable the firewalld service on your CentOS 7 VPS (such as to test...

Operating System Templates / ISOs

OpenVZ Templates: CentOS 5 (x86_64/x86) CentOS 6 (x86_64/x86) CentOS 6 Minimal (x86_64/x86)...