Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Select an option

  • Save karthikselva/8ef31be213e472bb6ec0ddb139475c7b to your computer and use it in GitHub Desktop.

Select an option

Save karthikselva/8ef31be213e472bb6ec0ddb139475c7b to your computer and use it in GitHub Desktop.
Connecting to MySQL using MySQL Workbench

Mysql Inside Vagrant:

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

Mysql WorkBench:

Connection Method: Standard TCP/IP over SSH
SSH Hostname: <Local VM IP Address (set in PuPHPet)>
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: <MySQL Root Password (set in PuPHPet)>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment