mysql + vagrant + remote access

mysql.txt

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

Really nice. Thanks for sharing.

Will it work on host machine as mysql -u root -p ?

I use this:

sudo nano /etc/mysql/my.cnf
change:
bind-address = 0.0.0.0

use mysql;
update user set host='%' where user='root' and host='127.0.0.1';
flush privileges;
exit

sudo /etc/init.d/mysql restart

In ubuntu 15.04 the MySQL Server configure file is in:

/etc/mysql/mysql.conf.d/mysqld.cnf

Not working for me, it is like i can't access to :3306 from outside the vagrant

config.vm.network "forwarded_port",guest:3306, host:3306

Don't forget to connect to localhost and not to your VM's hostname.