Can't connect to MariaDB on localhost using DBeaver

mysql mariadb dbeaver
user101289 picture user101289 · Jan 6, 2018 · Viewed 19.8k times · Source

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?

Answer

user101289 picture user101289 · Jan 8, 2018

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 = ::

Related questions

MySQL: Grant **all** privileges on database

I've created database, for example 'mydb'. CREATE DATABASE mydb CHARACTER SET utf8 COLLATE utf8_bin; CREATE USER 'myuser'@'%' IDENTIFIED BY PASSWORD '*HASH'; GRANT ALL ON mydb.* TO 'myuser'@'%'; GRANT ALL ON mydb TO 'myuser'@'%…

Read More
ERROR 1452: Cannot add or update a child row: a foreign key constraint fails

I have created tables in MySQL Workbench as shown below : ORDRE table: CREATE TABLE Ordre ( OrdreID INT NOT NULL, OrdreDato DATE DEFAULT NULL, KundeID INT DEFAULT NULL, CONSTRAINT Ordre_pk PRIMARY KEY (OrdreID), CONSTRAINT Ordre_fk FOREIGN KEY (KundeID) REFERENCES …

Read More
Cast int to varchar

I have below query and need to cast id to varchar Schema create table t9 (id int, name varchar (55)); insert into t9( id, name)values(2, 'bob'); What I tried select CAST(id as VARCHAR(50)) as col1 from t9; select CONVERT(…

Read More