All geek questions in one place

Connect to Vagrant Mysql with mysql Workbench

I have a tramp running around the Laravel estate. How can I create a mysql workbench connection (workbench outside the VM) with my roaming mysql? I tried:

Standard TCP / IP over SSH

ssh host: 192.168.10.10 // (same as my Homestead.yaml file) ssh user: vagrant ssh password: // (I've tried blank or vagrant) ssh key file: ~/.ssh/id_rsa mysql host: 127.0.0.1 mysql port: 3306 user: root password: <mypassword>

I have tried every combination that I can understand. What am I missing? I have an effective web developer who already works locally. I wanted to try a virtual virtual server. I just do not have enough local connection to roaming mysql. I have been doing this for 3 days.

Vagrantfile:

 require 'json' require 'yaml' VAGRANTFILE_API_VERSION = "2" homesteadYamlPath = File.expand_path("~/.homestead/Homestead.yaml") afterScriptPath = File.expand_path("~/.homestead/after.sh") aliasesPath = File.expand_path("~/.homestead/aliases") require_relative 'scripts/homestead.rb' Vagrant.configure(VAGRANTFILE_API_VERSION) do |config| if File.exists? aliasesPath then config.vm.provision "file", source: aliasesPath, destination: "~/.bash_aliases" end Homestead.configure(config, YAML::load(File.read(homesteadYamlPath))) if File.exists? afterScriptPath then config.vm.provision "shell", path: afterScriptPath end end

Homestead.yaml:

 --- ip: "192.168.10.10" memory: 2048 cpus: 1 authorize: ~/.ssh/id_rsa.pub keys: - ~/.ssh/id_rsa folders: - map: ~/projects/ to: /home/vagrant/projects/ sites: - map: test1.local to: /home/vagrant/projects/test1 - map: test2.local to: /home/vagrant/projects/test2 databases: - homestead variables: - key: APP_ENV value: local

Note:

To work, I decided to connect using Standard TCP / IP instead of Standard TCP / IP via SSH using the Mysql Workbench. Settings used by me:

 Hostname: localhost Port: 33060 Username: homestead Password: secret
+6
source share
1 answer

Show us your `Vagrantfile and check if you have port forwarding, and recommend setting a second fix IP address for it.

  config.vm.network "forwarded_port", guest: 3306, host: 3306 config.vm.network :private_network, ip: "192.168.10.50"

Then in mysql-workbench connect to 192.168.10.50 with port 3306

+6
source

Source: https://habr.com/ru/post/979763/

More articles:


All Articles