Database

How to create a database in DirectAdmin?

1. Login to your DirectAdmin Account. 2. In the Account Manager section, click on the MySQL Management Icon or type MySQL Management in the navigation filter box and then the option will appear. Click on it.  3. In the top right-hand side, click on the Create New Database button.  4. Fill the database name in the text field and then enter the password in the Database Password field or click on the Generate password icon and then on Create Database.  Your database will be created and you can copy its details such as database user/password and database name.

How to change a database user password in DirectAdmin?

1. Login to your DirectAdmin Account. 2. In the Account Manager section, click on the MySQL Management icon or type MySQL Management in the navigation filter box and then the option will appear. Click on it.  3. Under database text, click on the database which contains the database username you wish to change the password for.  4. Under User list, you can find your database users. Click on Change Password.  5. Enter your password or click on the generate password icon and then on Change button.  Your password will be changed and you can copy your database user password in a safe place.

How to modify database user privileges in DirectAdmin?

1. Login to your DirectAdmin Account. 2. In the Account Manager section, click on the MySQL Management icon or type MySQL Management in the navigation filter box. The option will appear. Click on it.  3. Under database text, click on the database you wish to modify privileges for.  4. Under User list, you can find your database users. Click on** Modify Privileges**.  5. Modify Privileges according to your needs and then click the Change button.  Your database user privileges will be successfully changed.

How to create a new database user in DirectAdmin?

1. Login to your DirectAdmin Account. 2. In the Account Manager section, click on the MySQL Management icon or type MySQL Management in the navigation filter box. The option will appear. Click on it.  3. Under database text, click on the database for which you want to create a user.  4. Under Users, click on Create New User.  5. Enter a user in the username field and a password in the password field or use the** generate new password** icon to generate a random password. Then click on Create.  A new database user will be created, and you can copy its details in a safe place.

How to repair a database in DirectAdmin?

1. Login to your DirectAdmin Account. 2. In the Account Manager section, click on the MySQL Management icon or type MySQL Management in the navigation filter box. The option will appear. Click on it.  3. Under** database** text, Select the database. You can select multiple databases for repair.  4. Click on Repair. Your database will be repaired and it will display a report such as whether your database has been repaired or not, etc.

How to examine or optimize a database in DirectAdmin?

1. Login to your DirectAdmin Account. 2. In the Account Manager section, click on the MySQL Management icon or type MySQL Management in the navigation filter box. The option will appear. Click on it.  3. Under database text, select the database. You can select multiple databases for examining or optimizing them.  4. Click on the Check button for examine or click on Optimize to optimize your database. This will display a result.

How to delete your database in DirectAdmin?

You can remove your database from the DirectAdmin control panel but we recommend you to first make a backup of it before removing it. 1. Login to your DirectAdmin Account. 2. In the Account Manager section, click on the MySQL Management Icon or type MySQL Management in the navigation filter box. The option will appear. Click on it.  3. Under database text, select the database. You can select multiple databases.  4. Click the Delete button. A new window will open, asking you for confirmation. Click again on Delete to remove the database.  The database will be removed.

How to download your database from DirectAdmin?

You can download your database from DirectAdmin. It can be useful for backup purposes or other uses. 1. Login to your DirectAdmin Account. 2. In the Account Manager section, click on the MySQL Management icon or type MySQL Management in the navigation filter box. The option will appear. Click on it.  3. Under database text, you can see a list of your databases. On your database, you will see a plus (+) icon, displayed on the right side. Click on it and select Download as SQL or GZ.  4. It will prompt for a download, which you will be able to save to your computer.