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.
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.
- 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.
- 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.
- To import databse
Click the import icon next to the database to select the SQL file path, then click Import button.
- To delete database
Click remove icon to delete database permanently from the server.
- 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.
- 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.
- 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.
- To show the user password
If you forget the user password, click the eye icon to check it.
- To delete user
Click remove icon next to the user to delete the user permanently from the server.
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: