How to Configure Remote MySQL Access in DirectAdmin

This guide will help you set up remote MySQL access for your database in DirectAdmin. Remote access is useful if you need to manage your database using an external tool like phpMyAdmin, a MySQL client, or if your application hosted on another server needs to access the database.

Step 1: Log in to DirectAdmin

  • Sign in to your DirectAdmin control panel.

Step 2: Navigate to Database Section

  • Click on the “Databases” icon to manage your databases.
  • Find the database for which you want to enable remote access. Click on "Manage" next to the database name.
  • Under the database settings, you will see the users associated with this database. Click on "Manage" next to the user you wish to configure for remote access.

Step 3: Configure Allowed Hosts

  • Scroll to the bottom of the page to find the "Allowed Hosts" section.
  • Here, you can specify which hosts are allowed to connect to the database. If you enter “%” in this field, any IP address will be able to access the database remotely. However, using “%” is not recommended for production environments due to security risks. It’s better to specify exact IP addresses or IP ranges that need access.
Was this answer helpful? 2 Users Found This Useful (2 Votes)