How To: Databases

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 […]

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. […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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.

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.