CODEWITHSUNDEEP
javamysqlwindowsubuntudbeaver
AlJw
AlJw

Reputation: 71

Connect dbeaver to mysql-server inside vmware machine

Please help me, I'm try to connect client dbeaver to mysql-server inside vmware ubuntu 20.04.

[enter image description here](https://i.sstatic.net/Y5IvF.png)

Ip host client: 172.25.3.65 - Windows Ip host server : 192.168.11.128 - Ubuntu 20.04 LTS

Y try edit mysql.cnf: [enter image description here](https://i.sstatic.net/f3TBy.png)

And create users with privilges:

CREATE USER ctdb@'172.25.3.65' IDENTIFIED BY 'password';

GRANT ALL PRIVILEGES ON ctdb_bq.* TO 'ctdb'@'172.25.3.65' WITH GRANT OPTION;

FLUSH PRIVILEGES;

[enter image description here](https://i.sstatic.net/nTU4A.png)

But, when I try connect with dbeaver show this error;

[enter image description here](https://i.sstatic.net/DdkDS.png)

Upvotes: 1

Views: 653

Answers (2)

JumpThere
JumpThere

Reputation: 17

You can try telnet VM 3306 in local cmd, if telnet failed, you could find a in VM path /etc/mysql/mysql.conf.d to modify a file named mysqld.cnf. There is a variable named bind-address and modify its value from 127.0.0.1 to 0.0.0.0 then restart mysql, you will connect VM MySQL by local Dbeaver.

Upvotes: 0

AlJw
AlJw

Reputation: 71

This works for me:

> mysql
SELECT user,authentication_string,plugin,host FROM mysql.user;
> mysql
ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'password';
> mysql
FLUSH PRIVILEGES;

And in Ubuntu configuring the ufw firewall:

sudo nano /etc/ufw/ufw.conf
sudo ufw allow ssh
sudo ufw allow 22
sudo ufw enable
sudo ufw status
sudo ufw disable 
sudo ufw enable

IN DBEAVER

And I can establishing connection with ssh.

In general options: 
user: root
pass:**

and tunel ssh options with credencials to OS.

Note: Is important install openssh in Ubuntu server to enable this connection type.

Upvotes: 1

Related Questions