MySQL and MariaDB are most commonly used database managment system. Both can be used on server to manage the data from various programs.

This guide will cover how to manage MySQL & MariaDB databases and users with VPSrobots. We will especially learn how to create/delete databases and users, grant the privilege to user, and import/export database.

Sign in VPSrobots and connect to your server, click login icon next to your server on My Servers list to access your server.

Log in server

Log in server

After the access to server, you are redirected to server status page. Click Database option on the left side navigation menu to go to Database control panel.

  • To create database

Click Create Database tab and switch to database creating page. Enter database name and click Create Database Now button. The new database will be immediately created and listed in the database table.

Create database

Create database

  • To alter privileges for a database

Click privilege icon next to the database to open a pop-up window where all the granted privileges are displayed, if necessary, modify the privileges on the database and click Alter button afterwards.

The privileges for database

The privilege for database

  • To export a database

When you click export icon next to the database, a window pops up and you are asked to provide a destination folder, click file icon to select an export path. At last, click Export button to start the process.

Export database

Export database

  • To import databse

Click the import icon next to the database to select the SQL file path, then click Import button.

Import database

Import database

  • To delete database

Click remove icon to delete database permanently from the server.

Delete database

Delete database

  • To create users for the database

Click Create user tab and switch to Create User page. User name, host type, password, and privilege for user are required while creating a user for database. When you grant privileges for the user, either grant all privileges to the user by clicking All privileges option or choose the specific privilege options below for the user by clicking Grant option. Lastly, click Create User Now button.

Create user

Create user

  • To alter the privileges for a user

Click privilege icon and a pop-up window shows the granted privilege of the user. If necessary, modify the privileges for the user and click Alter button to save the changes.

The privilege for the user

The privilege for the user

  • To replace password for the user

To change the user password regularly is a good way to secure database. click the lock icon next to the user and a window pops up where a new password is required. Then click Alter button to replace the previous password.

Replace password

Replace password

  • To show the user password

If you forget the user password, click the eye icon to check it.

Show the user password

Show the user password

  • To delete user

Click remove icon next to the user to delete the user permanently from the server.

Delete user

Delete user

Alternatively, you are allowed to quick create a database and user on Quick Create page. Fill out the required information of database and user, then click Quick Create Now button. Note: the user is granted all privileges to access the database by default.

Managing MySQL databases and users is a fundamental skill needed by website owners. After following this tutorial, hopefully, you learned a skill of managing MySQL databses and users with VPSrobots. To explore more features on VPSrobots, please follow the articles below: