Basic MySQL database administration on a Linux VPS

MySQL is one of the most popular relational database management systems (RDBMS). It is open-source and it is used by many individuals and organizations. If you are using our Linux VPS hosting services, you are most likely using MySQL as a database system. Therefore, it is important for you to know how to operate with your database system when you need to make some changes in your databases. Today, we will have a very simple task – to teach you how to work with your MySQL database system using these simple commands from your Linux VPS.

The first thing you need to do is to check your MySQL version using the command:

## mysql -h localhost -V

If by any chance you do not have MySQL database server installed on your VPS, you can install it using the commands:

You will get an ‘Empty set’ message. This is because the ‘test_table’ is new and does not hold any data.

In the next tutorial, we will show you how to insert and manipulate data into your tables.

Of course you don’t have to do any of this if you use one of our Linux VPS hosting services, in which case you can simply ask our expert Linux admins to do this for you. They are available 24×7 and will take care of your request immediately.

PS. If you liked this post please share it with your friends on the social networks using the buttons on the left or simply leave a reply below. Thanks.