mysqlmariadbdbeaver

Can't connect to MariaDB on localhost using DBeaver

I've just installed mariadb on Ubuntu 

mysql Ver 15.1 Distrib 10.0.31-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

I can connect to the DB using PHP through a local webserver and can connect over the command line. However, I can't get DBeaver to connect from the GUI. I set up a connection using the MariaDB drivers, for localhost on port 3306 with the root user / pass I use from the cli.

I get this error:

Could not connect to address=(host=localhost)(port=3306)(type=master) : Connection refused (Connection refused)

Any idea if that's a my.cnf setting that needs to be changed or is there another setting I'm missing in DBeaver?

Solution

  • This answer helped: https://serverfault.com/questions/808977/mariadb-refuses-remote-connections

    But specifically the comment that pointed out you may need to restart your machine-- running sudo /etc/init.d/mysql restart showed that the server had restarted, but the altered IP bindings apparently did not get refreshed until I rebooted the machine.

    I changed the line:

    bind-address = 127.0.0.1

    to

    bind-address = ::