MariaDB not allowing remote connections

mysql windows windows-server-2008 mariadb navicat
ItsJamie picture ItsJamie · Feb 9, 2014 · Viewed 66.2k times · Source

enter image description here

enter image description here

As the screenshots show, I have the accounts setup to allow remote connections but as shown in the second screenshot I still cannot connect remotely.

Answer

LandiLeite picture LandiLeite · Jan 5, 2018

I use for testing in the virtual machine (Ubuntu 16.04), for me, I fixed the error changing the file 50-server.cnf.

My server is Ubuntu, so changing the file below:

50-server.cnf

The path of this file:

/etc/mysql/mariadb.conf.d

PS: Create a backup of the file before the change.

Only change in file the bind-address 127.0.0.0 to bind-address 0.0.0.0

After this restart service and try again.

Regarding that user, need to allow for external connections.

I hope that this info helps you.

Related questions

Is there a way to pass the DB user password into the command line tool mysqladmin?

I currently use the following but it ALWAYS prompts me to manually type the password. Is there any way to pass it in on the command line when launching the executable? mysqladmin processlist -u root -p

Read More
Batch-file for mysqldump to backup each database into a separate file

Trying to create a batch (cmd) file for backing up each database into a separate file. Databases are created/deleted often, so batch file needs to grab current db names everytime it runs and backup each one of them. Here …

Read More
How to log in to phpMyAdmin with WAMP, what is the username and password?

What does the word "root" mean in phpMyAdmin? Whenever I write localhost/phpmyadmin on the address bar, I am asked to enter a username and a password, but I don't know what they are. I don't remember when and where …

Read More