Administering databases using DirectAdmin and phpMyAdmin
Table of contents:
- Creating a new database in DirectAdmin (MySQL)
- Administering MySQL databases using DirectAdmin / phpMyAdmin
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
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