Web Hosting Services

Administering databases using DirectAdmin and phpMyAdmin

Wednesday, 25 July 2012 | Views: 10967

Table of contents:

Creating a new database in DirectAdmin (MySQL)

In order to create a new database first you have to log in to your DirectAdmin web panel

Once you are logged in, find the link to MySQL Management in Your Account section and click on it

On a top left corner you will notice Create new Database link. Click on it.

Now you can choose database name, database user name and the password (DA can generate one for you) for your new database. The prefix for both user name and database name will be your DA user name.
Please do not use easy to guess names and passwords!

Click Create button when you ready and the next thing you will see will be the values of your new database that you should use for your web projects

Back to top

Administering MySQL databases using DirectAdmin / phpMyAdmin

When it comes to databases' administration, you have two options to deal with it.

The first one - simple administration tasks - can be done through DirectAdmin. To access administration options log in to your DA account and click on MySQL Management link as shown here
Here is the list of what actions can you perform on MySQL database in DirectAdmin:

  • Choose phpMyAdmin administration client for advanced SQL tasks
  • Download database backup file
  • Restore database from backup file
  • Delete database
  • Repair, check and optimize the database
  • Create new or delete database users
  • Modify password and privileges of a database
  • Add / delete new hosts

And when you need more control over your databases, you should go for phpMyAdmin. Needless to say that this option should be used by experienced users only.
You can access phpMyAdmin in two ways:
First option - click on phpMyAdmin link in Advanced Features section in DirectAdmin.

Second option - type www.yourdomain.com/phpmyadmin in your browser window (replace yourdomain.com with your real domain name). You will be asked to provide database username and password.

Here is a screenshot of phpMyAdmin window

Back to top

Back to list