'This guide shows how to allow remote MySQL access so you can connect from tools like HeidiSQL. By default, MySQL blocks external connections, so you need to update user permissions and configuration settings.', 'howto' => [ 'Create a MySQL user that allows remote connections.', 'Grant proper privileges to the user.', 'Update MySQL configuration bind-address setting.', 'Restart MySQL service.', 'Check firewall and port settings if connection fails.' ], 'why' => 'Remote MySQL access allows you to manage your database from external tools like HeidiSQL, making development and server management much easier.', 'faq' => [ [ 'q' => 'Why is MySQL not accessible remotely?', 'a' => 'MySQL blocks external access by default using bind-address and user host restrictions.' ], [ 'q' => 'Is it safe to allow root remote access?', 'a' => 'It is not recommended. Creating a separate user with limited privileges is safer.' ], [ 'q' => 'What port does MySQL use?', 'a' => 'MySQL uses port 3306 by default.' ], [ 'q' => 'What if I still cannot connect?', 'a' => 'Check firewall rules, cloud security groups, and ensure port 3306 is open.' ] ] ]; include_once $_SERVER['DOCUMENT_ROOT'] . '/inc/guides/related-guides-helper.php'; include_once $_SERVER['DOCUMENT_ROOT'] . '/inc/guides/related-tools-helper.php'; $relatedGuides = getAutoRelatedGuides($guideSlug, $guideCategory, 5); $relatedTools = getRelatedToolsForGuide($guideSlug, 5); include_once $_SERVER['DOCUMENT_ROOT'] . "/inc/header.html"; ?>

Guides

Fix real problems quickly with simple and practical solutions.
Linux Guides

How to Allow Remote MySQL Connection

Fix HeidiSQL connection issues by enabling external MySQL access in minutes.

Before you start

You need root or sudo access to the server.
MySQL must already be installed and running.
Port 3306 must be open in firewall or cloud settings.

Step-by-step instructions

1. Create remote MySQL user

Create a user that can connect from any IP.

SQL 
CREATE USER 'root'@'%' IDENTIFIED BY 'yourpassword';

2. Grant privileges

SQL 
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';
FLUSH PRIVILEGES;

3. Update bind-address

Edit MySQL configuration file.

vi /etc/mysql/my.cnf
bind-address = 0.0.0.0

4. Restart MySQL

service mysql restart

Common issues

Port 3306 blocked

Make sure firewall or cloud security allows MySQL port.

bind-address not changed

MySQL will still block external access if bind-address is 127.0.0.1.

Wrong user host

User must be created with '%' to allow remote access.