Home Customer Knowledgebase & Guides
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. Log in 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 appears. Click on it. 4. It will prompt […]

How to delete your database in DirectAdmin?

You can remove your database from the DirectAdmin control panel, but we recommend you first make a backup before removing it. 1. Log in 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 appears. Click on it. […]

How to examine or optimize a database in DirectAdmin?

1. Log in 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. 4. Click on the Check button to examine or click on Optimize to optimize your database. This will display a […]

How to repair a database in DirectAdmin?

1. Log in 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. 4. Click on Repair. Your database will be repaired, and it will display a report such as whether your database […]

How to create a new database user in DirectAdmin?

1. Log in 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. 4. Under Users, click on Create New User. A new database user will be created, and you can copy its […]

How to modify database user privileges in DirectAdmin?

1. Log in 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. 4. Under the User list, you can find your database users. Click on Modify Privileges. Your database user privileges will […]

How to change a database user password in DirectAdmin?

1. Log in 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. 4. Under the User list, you can find your database users. Click on Change Password. Your password will […]

How to create a database in DirectAdmin?

1. Log in 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. 4. Fill the database name in the text field and then enter the password in the Database Password […]

How to Download a Backup of Your Email, FTP, or Database Only through DirectAdmin?

Do you know that If you want to download a backup of only FTP data, emails, or database data, you can do this from your DirectAdmin control panel? How to Generate а Backup of Your Database, FTP, or Your Email Only? 1. Log in to your DirectAdmin account. 2. In the Advanced Features section, click […]

How to optimize the database via phpMyAdmin in cPanel?

1. Log into your cPanel account. 2. In the Databases section, click on the phpMyAdmin icon. 3. In left side-bar, Click on the expand button to expand the database like “example”.       4. Under your cPanel username, you can see a list of all databases. Select the appropriate database which you want to […]

How to Repair database via phpMyAdmin in cPanel?

1. Log into your cPanel account. 2. In the Databases section, click on the phpMyAdmin icon. 3. In the left side-bar, Click on the expand button to expand the database like “example”.             4. Under your cPanel username, you can see a list of all databases. Select the appropriate database […]

How to delete database table via phpMyAdmin in cPanel?

1. Log into your cPanel account. 2. In the Databases section, click on the phpMyAdmin icon. 3. In left side-bar, Click on the expand button to expand the database like “example”.     4. Under your cPanel username, you can see a list of all databases. Select the appropriate database, and it will be expanded […]

How to edit database table via phpMyAdmin in cPanel?

1. Log into your cPanel account. 2. In the Databases section, click on the phpMyAdmin icon. 3. In left side-bar, Click on the expand button to expand the database like “example”. 4. Under your cPanel username, you can see a list of all databases. Select an appropriate database which you want to edit, and it […]

How to export database table via phpMyAdmin in cPanel?

1. Log into your cPanel account. 2. In the Databases section, click on the phpMyAdmin icon. 3. In left side-bar, Click on the expand button to expand the database like “example”.     4. Under your cPanel username, you can see a list of all databases. Please select an appropriate database which you want to […]

How to import database via phpMyAdmin in cPanel?

1. Log into your cPanel account. 2. In the Databases section, click on the phpMyAdmin icon. 3. In left side-bar, Click on the expand button to expand the database like “example”.       4. Under your cPanel username, you can see a list of all databases. Select an appropriate database in which you want […]

How do I create a MYSQL database?

Each time a website is created, whether for personal or business use, an accompanying database must also be formed to keep data and information for that site. Luckily, website databases are mostly automatically generated, thanks to those auto-installer applications and scripts supplied by various website building software that we use today. However, there are situations […]

How to add a user to a database and add privileges?

1. Log into your cPanel account. 2. In the Databases section, click on MySQL Databases Icon.  3. Scroll down to the end of the page and under Add User to Database, select a user from the dropdown list, and then choose a Database from the list. 4. Click on the Add button. 5. On Manage […]

How to Create a Database Username in cPanel?

1. Log into your cPanel account. 2. In the Databases section, click on MySQL Databases Icon.  3. Under MySQL Users in the Username field, enter the new username you wish to create.4. Enter your new password or use a password generator.5. Click on the Create a User Button. Tip: Write down the Database Username and […]

How to delete a database in cPanel?

1. Log into your cPanel account. 2. In the Databases section, click on MySQL Databases Icon.  3. Under Current Databases, you can see a list of all your databases. Locate the Database you wish to remove and then click on the Delete icon. 4. Click on the Delete Database button.

How to rename a database in cPanel?

1. Log into your cPanel account. 2. In the Databases section, click on MySQL Databases Icon. 3. Under Current Databases, You can see a list of all your databases. Locate the Database and then click on Rename Icon.4. Change the database name and then click on the Proceed button.