How to connect to Mysql Server inside VirtualBox Vagrant

Question

I mounted a new VirtualBox Machine with Vagrant  and inside that VM I installed Mysql Server  How can I connect to that server outside the vm  I already forward the port 3306 of the Vagrantfile   but when I try to connect to the mysql server  it s resposts with the error    reading initial communication packet   ERROR 2013  HY000   Lost connection to MySQL server at  reading initial communication packet   system error  0

User · Answer

For anyone trying to do this using mysql workbench or sequel pro these are the inputs:

Mysql Host: 192.168.56.101 (or ip that you choose for it)
username: root (or mysql username u created)
password: **** (your mysql password)
database: optional
port: optional (unless you chose another port, defaults to 3306)

ssh host: 192.168.56.101 (or ip that you choose for this vm, like above)
ssh user: vagrant (vagrants default username)
ssh password: vagrant (vagrants default password)
ssh port: optional (unless you chose another)

source: https://coderwall.com/p/yzwqvg

User · Answer

Well  since neither of the given replies helped me  I had to look more  and found solution in this article   And the answer in a nutshell is the following   Connecting to MySQL using MySQL Workbench  Connection Method  Standard TCP IP over SSH SSH Hostname   lt Local VM IP Address  set in PuPHPet  gt  SSH Username  vagrant  the default username  SSH Password  vagrant  the default password  MySQL Hostname  127 0 0 1 MySQL Server Port  3306 Username  root Password   lt MySQL Root Password  set in PuPHPet  gt    Using given approach I was able to connect to mysql database in vagrant from host Ubuntu machine using MySQL Workbench and also using Valentina Studio

User · Answer

Make sure MySQL binds to 0 0 0 0 and not 127 0 0 1 or it will not be accessible from outside the machine  You can ensure this by editing your my conf file and looking for the bind-address item--you want it to look like bind-address   0 0 0 0   Then save this and restart mysql   sudo service mysql restart   If you are doing this on a production server  you want to be aware of the security implications  discussed here  https   serverfault com questions 257513 how-bad-is-setting-mysqls-bind-address-to-0-0-0-0

User · Answer

This worked for me  Connect to MySQL in Vagrant  username  vagrant password  vagrant  sudo apt-get update sudo apt-get install build-essential zlib1g-dev git-core sqlite3 libsqlite3-dev sudo aptitude install mysql-server mysql-client   sudo nano  etc mysql my cnf change  bind-address              0 0 0 0   mysql -u root -p  use mysql GRANT ALL ON     to root  33 33 33 1  IDENTIFIED BY  jarvis   FLUSH PRIVILEGES  exit   sudo  etc init d mysql restart       - - mode  ruby - -   vi  set ft ruby    Vagrant  Config run do  config     config vm box    lucid32     config vm box url    http   files vagrantup com lucid32 box      config vm boot mode    gui      Assign this VM to a host-only network IP  allowing you to access it     via the IP  Host-only networks can talk to the host machine as well as     any other machines on the same network  but cannot be accessed  through this     network interface  by any external networks      config vm network  hostonly   192 168 33 10       Assign this VM to a bridged network  allowing you to connect directly to a     network using the host s network device  This makes the VM appear as another     physical device on your network      config vm network  bridged      Forward a port from the guest to the host  which allows for outside     computers to access the VM  whereas host only networking does not      config vm forward port 80  8080    config vm forward port 3306  3306    config vm network  hostonly   33 33 33 10    end

User · Answer

Here are the steps that worked for me after logging into the box   Locate MySQL configuration file     mysql --help   grep -A 1  Default options   Default options are read from the following files in the given order   etc my cnf  etc mysql my cnf    my cnf   On Ubuntu 16  the path is typically  etc mysql mysql conf d mysqld cnf  Change configuration file for bind-address   If it exists  change the value as follows  If it doesn t exist  add it anywhere in the  mysqld  section   bind-address   0 0 0 0   Save your changes to the configuration file and restart the MySQL service   service mysql restart   Create   Grant access to database user   Connect to the MySQL database as the root user and run the following SQL commands   mysql gt  CREATE USER  username      IDENTIFIED BY  password    mysql gt  GRANT ALL PRIVILEGES ON mydb   TO  username

User · Answer

Log in to your box with ssh vagrant 127 0 0 1 -p 2222  password vagrant   Then  sudo nano  etc mysql my cnf and comment out the following lines with     skip-external-locking   bind-address   save it  amp  exit  then  sudo service mysql restart  Then you can connect through SSH to your MySQL server

User · Answer

I came across this issue recently  I used PuPHPet to generate a config   To connect to MySQL through SSH  the  vagrant  password was not working for me  instead I had to authenticate through the SSH key file   To connect with MySQL Workbench  Connection method  Standard TCP IP over SSH  SSH  Hostname  127 0 0 1 2222  forwarded SSH port  Username  vagrant Password   do not use  SSH Key File  C  vagrantpath puphpet files dot ssh insecure private key                Locate your insercure private key    MySQL  Server Port  3306 username   root  or username  password   password    Test the connection

[mysql] How to connect to Mysql Server inside VirtualBox Vagrant?

Examples related to mysql

Examples related to virtualbox

Examples related to vagrant