How to manage Databases using ServerAvatar

How to manage Databases using ServerAvatar

Alright, so there is no denying the fact that when it comes to web development, we use Databases all the time. Does not matter if you are someone who is using some custom dynamic PHP script or using any popular Content Management System (CMS) like WordPress. The thing is that you do need to have Database and the Database users in order to make your website or web application. MySQL is one of the most popular Databases Management System which most web developers use today. Now, we won’t be going in deep for Why MySQL is the best in this post.

This post is going to be all about How to manage Databases using ServerAvatar. Since you are using VPS, it can be difficult for starters to create and manage databases using SSH. But, you need not worry any longer since ServerAvatar has got you on board for an easy experience with VPS. With that being said, let us now take a quick look at What is Database, Database Users and how it works. Should we?

What is a Database?

Well, as the name suggests, the database is the place where your data has been stored. Now, the first thing should have come to your mind after reading this can be “Files” of your website. Right? Well, this is not the database. In simple words, the database contains data of your website in the form of tables which makes it easier and efficient to retrieve and add the data to the database. Every dynamic website on the internet relies on some kind of Database. MySQL is the most popular and widely used one.

Popular Content Management Systems like WordPress are using MySQL to cater to their Database Management needs. In fact, Wikipedia is also relying on MySQL for their website. Now, with that being out of the way, let us now take a look at What is a Database user. Should we?

What is Database User?

What is the first thing that comes to your mind after reading the term “Database user”. The user who uses the database, Right? Well, it is true and as simple as that. If you are on any Social Media Network like Facebook, then you are a Database User as well. Now, a lot of you might deny to this since you are not managing the database. Well, this is simply because you don’t have the privileges to do so.

There are different types of users in a Database which depends on the type of privileges a user have. The Database Administrator has the most privileges followed by Database Designer, Manager and the end user. With that being said, let us now take a look at How to manage Databases using ServerAvatar. Should we?

How to manage Databases using ServerAvatar

In this guide, we will be sharing all the steps which you need to follow in order to manage the database of your websites using ServerAvatar. We would be covering on:

  • How to create a new Database using ServerAvatar
  • How to Manage users in Database using ServerAvatar.
  • and How to delete a Database.

So without any further, we do, let’s take a look at How to create a new Database using ServerAvatar. Should we?

How to create a new Database using ServerAvatar

Here are the steps which you need to follow in order to create a new database using ServerAvatar:

  • First of all, you need to make sure that you have connected your server with the ServerAvatar.
  • Now, you need to log in to your ServerAvatar Account.
  • Here, select the Server Panel option under your Server.
  • Now, in the server panel dashboard, you need to click on the Databases option from the left menu.
  • Here, you need to click on the Create button from the top right corner.
  • Now, simply type in the name for your new database and check the Set Custom Username and Password option. Alternatively, you can also leave that unchecked if you want ServerAvatar to set some random username and password to the database. You’ll receive the credentials on your registered email address. You can also enter the Remote IP here if you wish to access this database from the remote host.
  • Once done, simply click on the Create Database button to create your new database.
  • That’s it! You have successfully created a database on your Server with the help of ServerAvatar. Was pretty easy, No?

Let us now take a look at How to Manage users in Database using ServerAvatar . Should we?

How to Manage users in Database using ServerAvatar

How to add user to the Database (with Remote Access)

Here are the steps which you need to follow in order to add users to a Database using ServerAvatar:

  • First of all, you need to login to your ServerAvatar Account.
  • Now, you need to click on the Server Panel option under your Server.
  • Here, you need to click on the Databases option from the left menu.
  • Now, you need to click on the Manage Users option under the database name.
  • Here, you’ll find a list of all the database users for that particular database. To add a new user, simply click on the Create button from top right.
  • Now, simply enter the Database Username, Password and Remote IP (OPTIONAL) if you want to use one.
  • Once done, simply click on the Create Database User button to create a new user.
  • That’s it! You have successfully created a new database user.

How to delete user from a Database

Here are the steps which you need to follow in order to delete a user from your database.

  • First of all, you need to login to your ServerAvatar Account.
  • Now, you need to click on the Server Panel option under your Server.
  • Here, you need to click on the Databases option from the left menu.
  • You now need to click on the Manage Users option under the database name.
  • Here, you’ll find a list of all the database users for that particular database. To delete an existing user, simply click on the Delete button under the database username.
  • When prompted, simply click on the Yes, Delete it! option to delete the database user.
  • That’s it! You have successfully deleted a user from the database.

Let us now take a look at How to delete a database using ServerAvatar. Should we?

How to delete Database using Serveravatar

Here are the steps which you need to follow in order to delete a database using ServerAvatar:

  • First of all, you need to log in to your ServerAvatar Account.
  • Here, select the Server Panel option under your Server.
  • You now need to click on the Databases option from the left menu.
  • Here, you will get a list of all the databases that you have on your server.
  • Now. simply click on the Delete Database option under the database name to delete it.
  • When prompted, select the Yes, Delete it! option to confirm the deletion.
  • That’s it! You have successfully deleted a database using ServerAvatar.

As you can see, the ServerAvatar lets you create and manage databases within a few clicks. This can help you a lot if you are new to servers and even if you are familiar with them, you know that it can save you a lot of time.

So that’s it guys, this was our take on How to manage Databases using ServerAvatar. We hope that you found this post useful. Just in case if you have stuck somewhere between the steps or had any questions related to the topic, then feel free to leave them in the comments section down below.

Sharing is caring 🙂
0Shares

Leave a Comment

So glad to see you sticking around!

Interesting in learning New techniques to Improve the performance of your WordPress/PHP website or your Web Server?

Enter your E-mail below and get new techniques that we discover by experimenting new stuff directly to your inbox!

Thank You For Subscribing

This means the world to us!

Spamming is not included! Pinky promise.