MySQL Forums
Forum List  »  MySQL Workbench

Access to database remote with workbench
Posted by: Michael Freitter
Date: April 07, 2019 12:57AM

Hello,

I have installed a new virtual machine with VirtualBox with the operation system ubuntu 18.04.
Then I habe installed LAMP with "sudo apt-get install lamp-server^"

MySQL database works fine!

Also I have a portforwarding 10.0.2.15:3306 to 127.0.0.1:3306

Now I want to access to the database in the virtual machine with workbench.
I have read that I must change the bind to "0.0.0.0" in the file /etc/mysql/my.cnf

The content from my folder /etc/mysql is:

drwxr-xr-x 2 root root 4096 Apr 7 06:29 conf.d
-rw------- 1 root root 317 Apr 7 06:30 debian.cnf
-rwxr-xr-x 1 root root 120 Jan 21 18:25 debian-start
lrwxrwxrwx 1 root root 24 Apr 7 06:29 my.cnf -> /etc/alternatives/my.cnf
-rw-r--r-- 1 root root 839 Aug 3 2016 my.cnf.fallback
-rw-r--r-- 1 root root 682 Jan 12 2018 mysql.cnf
drwxr-xr-x 2 root root 4096 Apr 7 06:30 mysql.conf.d

The file my.cnf is a link.

Where must I change the parameter, that I can access from outside my virtual machine?

Thank you!
Michael

Options: ReplyQuote


Subject
Views
Written By
Posted
Access to database remote with workbench
564
April 07, 2019 12:57AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.