Monthly Archives: June 2021

How to Allow MySQL remote connections in Ubuntu Server 18.04

This tutorial explains how to allow remote connections to the MySQL/MariaDB server on Ubuntu 18.04. The default behavior of the Ubuntu MySQL Server blocks all remote connections. Which prevent us from accessing the database server from the outside.

Note that to allow mysql remote connections we need to edit the MySQL main configuration file. If you are using MariaDB Database server, configuration file going to be “nano /etc/mysql/mysql.conf.d/mysqld.cnf”, If you have installed MySQL Database server configuration file is: “nano /etc/mysql/mysql.conf.d/mysqld.cnf”.

Open the nano /etc/mysql/mysql.conf.d/mysqld.cnf file (or /etc/mysql/mysql.conf.d/mysqld.cnf). Continue reading