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

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> CREATE USER 'username'@'%' IDENTIFIED BY 'password';

mysql> GRANT ALL PRIVILEGES ON mydb.* TO 'username'@'%';

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

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

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

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

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

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

Examples related to mysql

Examples related to virtualbox

Examples related to vagrant