Bobcares

Quick way to set up Webmin MySQL remote access and fix errors

by | May 21, 2019

For security reasons, Webmin doesn’t allow remote access to the MySQL database server.

What will you do, if you are away from your office network and need to instantly access your database?

Fortunately, the Webmin MySQL remote access allows you to access your database from different locations.

But, often wrong MySQL server settings or bad firewall cause problems with MySQL remote access.

At Bobcares, we often get requests from our customers set up MySQL remote access in Webmin as part of our Server Management Services.

Today, we’ll see how our Support Engineers set up MySQL remote access and fix the related errors.

How we set up Webmin MySQL remote access

Let’s see how our Support Engineers do it from Webmin control panel.

1. Firstly, we log into Webmin -> Servers -> MySQL Database Server -> MySQL Server Configuration, and set “MySQL server listening address” to “0.0.0.0”.

2. For any Virtual Server that should have remotely accessible databases, go into Edit Databases -> Remote Hosts, and add the IP address of the remote system there.

3. Setup firewall rule to allow MySQL port. Goto Webmin > Networking > Linux Firewall. If the rule does not exist, create the following rule: “If protocol is TCP and destination port is 3306” then accept.

 

Related issues and fixes

From our experience in managing server, we’ve seen that many customers had issues related to MySQL remote access in Webmin. Let’s take a look at the top problems and how we fix them.

 

Wrong firewall settings

Recently, one of our customers contacted us with a problem related to MySQL remote access. He got an error while connecting to the database as MySQL user abc_test. The exact error said: SQL Error (2003): Can’t connect to MySQL server on ‘X.X.X.X’.

On checking, we found that the server’s firewall was blocking his IP address.

Then, our Support Engineers fixed the issue by tweaking the settings in the firewall configuration file.

Again, the tweaking may depend on the different firewall used in servers such as UFW, CSF, etc.

 

Incorrect Mysql server settings

Similarly, often errors may occur due to incorrect Mysql server settings. For instance, one of the customer’s MySQL server was accepting connections only from local IP addresses. All the remote connections were failing.

Then our Support Engineers took the following steps to solve the issue.

1. First, we logged into Webmin control panel and selected Edit Databases -> Remote Hosts, and added the IP address for the various systems that want to remotely access MySQL.

2. MySQL doesn’t listen for external connections by default. Then we edited my.cnf file, set the “bind-address” to “0.0.0.0”.

3. At last, we restarted MySQL service.

In addition, we always make sure that  –skip-networking in MySQL server settings is disabled. Otherwise, the rule will prohibit remote access to the MySQL database.

 

[Having trouble with MySQL remote access in Webmin. ? We’ll fix it for you.]

 

Conclusion

In short, Webmin allows you to access your database from different locations. However, wrong MySQL server settings or bad firewall cause issues. Today, we saw how our Support Engineers set up MySQL remote access in Webmin and solved related issues.

PREVENT YOUR SERVER FROM CRASHING!

Never again lose customers to poor server speed! Let us help you.

Our server experts will monitor & maintain your server 24/7 so that it remains lightning fast and secure.

GET STARTED

var google_conversion_label = "owonCMyG5nEQ0aD71QM";

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

Never again lose customers to poor
server speed! Let us help you.

Privacy Preference Center

Necessary

Necessary cookies help make a website usable by enabling basic functions like page navigation and access to secure areas of the website. The website cannot function properly without these cookies.

PHPSESSID - Preserves user session state across page requests.

gdpr[consent_types] - Used to store user consents.

gdpr[allowed_cookies] - Used to store user allowed cookies.

PHPSESSID, gdpr[consent_types], gdpr[allowed_cookies]
PHPSESSID
WHMCSpKDlPzh2chML

Statistics

Statistic cookies help website owners to understand how visitors interact with websites by collecting and reporting information anonymously.

_ga - Preserves user session state across page requests.

_gat - Used by Google Analytics to throttle request rate

_gid - Registers a unique ID that is used to generate statistical data on how you use the website.

smartlookCookie - Used to collect user device and location information of the site visitors to improve the websites User Experience.

_ga, _gat, _gid
_ga, _gat, _gid
smartlookCookie
_clck, _clsk, CLID, ANONCHK, MR, MUID, SM

Marketing

Marketing cookies are used to track visitors across websites. The intention is to display ads that are relevant and engaging for the individual user and thereby more valuable for publishers and third party advertisers.

IDE - Used by Google DoubleClick to register and report the website user's actions after viewing or clicking one of the advertiser's ads with the purpose of measuring the efficacy of an ad and to present targeted ads to the user.

test_cookie - Used to check if the user's browser supports cookies.

1P_JAR - Google cookie. These cookies are used to collect website statistics and track conversion rates.

NID - Registers a unique ID that identifies a returning user's device. The ID is used for serving ads that are most relevant to the user.

DV - Google ad personalisation

_reb2bgeo - The visitor's geographical location

_reb2bloaded - Whether or not the script loaded for the visitor

_reb2bref - The referring URL for the visit

_reb2bsessionID - The visitor's RB2B session ID

_reb2buid - The visitor's RB2B user ID

IDE, test_cookie, 1P_JAR, NID, DV, NID
IDE, test_cookie
1P_JAR, NID, DV
NID
hblid
_reb2bgeo, _reb2bloaded, _reb2bref, _reb2bsessionID, _reb2buid

Security

These are essential site cookies, used by the google reCAPTCHA. These cookies use an unique identifier to verify if a visitor is human or a bot.

SID, APISID, HSID, NID, PREF
SID, APISID, HSID, NID, PREF