CODEWITHSUNDEEP
mysqlwindowswindows-server-2008mariadbnavicat
ItsJamie
ItsJamie

Reputation: 261

MariaDB not allowing remote connections

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.

Upvotes: 24

Views: 109504

Answers (4)

Konstantin XFlash Stratigenas
Konstantin XFlash Stratigenas

Reputation: 607

This may help on Docker

docker exec abu-mariadb-1 /bin/bash -c "echo '[mysqld]' >> /etc/mysql/my.cnf"
docker exec mariadb-1 /bin/bash -c "echo 'skip-grant-tables' >> /etc/mysql/my.cnf"

and Restart the Container. If you have not the Docker Image, edit the ini oder cnf File under [mysqld] Section

Upvotes: 0

LandiLeite
LandiLeite

Reputation: 613

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.

Upvotes: 39

Joshua
Joshua

Reputation: 615

MariaDB packages bind MariaDB to 127.0.0.1 (the loopback IP address) by default as a security measure using the bind-address configuration directive. Old MySQL packages sometimes disabled TCP/IP networking altogether using the skip-networking directive.

Steps to allow remote connections are provided in the MariaDB Knowledge Base at https://mariadb.com/kb/en/mariadb/configuring-mariadb-for-remote-client-access/

Upvotes: 7

Fidel
Fidel

Reputation: 7397

Mysql by default binds to 0.0.0.0 which is all interfaces on your system. Which means you can already connect from another computer. The issue is perhaps permissions. You can enable remote connections by running the following command:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.%' IDENTIFIED BY '' WITH GRANT OPTION;

Upvotes: 26

Related Questions