Ha, just when you thought that I had enough of writing tutorials and guides, I decided to write yet another one. This time it is how to setup MySQL databases using DirectAdmin. Although DirectAdmin is not as popular as Cpanel, it is nevertheless a very good alternative control panel for web hosts. Sure, it has less features than Cpanel, but it is still a very user-friendly control panel and if you like basic and easy, you got it in DirectAdmin. When the latest version, DirectAdmin has really bumped up the competition which was previously completely owned by Cpanel. I must say good job there, Mr DirectAdmin.

The step by step tutorial is for the beginner and it will teach you how to setup MySQL database in just a few simple steps. In fact, it is much easier and less complicated than Cpanel. If you think the Cpanel tutorial is easy, you will be even more suprised to see how you can setup my MySQL databases with DirectAdmin. So without futherado, we begin the tutorial (or some people call this pictorial). You will need your userid and your password to access your DirectAdmin console in order for you to follow the tutorial. If you don’t have the information, you will need to get it from your webhost. Your webhost will also provide the URL which you can access DirectAdmin

At your home page of your DirectAdmin account, under Your Account, you will see MySQL Management. This is where you access the page to configure and setup your database. So your first step is to click on MySQL Management.

If you have existing databases, you can see them being displayed here. What you need to do is to click on Create new Database to create a new database.

The next step is to key in the necessary information. You will need the database Name, a username (or you can use an existing user) and the password (twice).  Do note that both the database name and the username has a prefix in front. You will need the full database name and username when you configure your scripts or software to access the database. Of course, you should also remember the password.

After you have finished keying all the necessary information, click on Create. Remember, your database is usually exposed to the Internet, so you should have a very complex password to protect all your hard work. Clicking on random will generate a random password for you.

There, your database and user has been created. We are so happy for you. Take note of the hostname of your MySQL server as well.

You can see your new database on the MySQL managament page. Please note that by default the user privileges is set to Full access to the database. If you need to do some changes or the modify the privileges, you can always do your changes later by clicking on the database. However, this is for the slightly more advanced user. The defaults should work fine for most web applications. I would recommend you not to do any changes to the default privileges unless your application really requires it.

With that, I hope that you guys will enjoy the rest of the week. Remember to relax, have a beer and dont forget to live your life to the fullest.