Connect to MySQL database on vagrant machine in PhpStorm
Solution 1
In SSH/SSL tab, select Auth type Key pair
, then copy the path to private key file define in IdentityFile
. For instance C:/virtualM/deb56/puphpet/files/dot/ssh/id_rsa
$vagrant up
$vagrant ssh-config
Host local
HostName 127.0.0.1
User vagrant
Port 2222
UserKnownHostsFile /dev/null
StrictHostKeyChecking no
PasswordAuthentication no
IdentityFile "C:/virtualM/deb56/puphpet/files/dot/ssh/id_rsa"
IdentityFile "C:/Users/User/.vagrant.d/insecure_private_key"
IdentitiesOnly yes
LogLevel FATAL
Solution 2
Here is a really nice article on this subject:
That is:
- In PhpStorm click on View -> Tool Windows -> Database
- Click on the Database sidebar, click on new -> Datasource -> MySQL The configuration window will appear
- Open your terminal.
- Go to your project:
cd ~/path/to/your/project
- Run
vagrant ssh-config
command from the terminal - At PhpStorm configuration window for connection you are creating go to SSH/SSL tab
- Select "Use SSH tunnel" and enter data from the terminal. Auth type should be "Key pair (Open SSH)".
- Copy "Host name" to "Proxy host", "Port" to "port", "User" to "Proxy user" and "Identity file" to "Private key file"
- At "General" tab you should enter your database connection data as you would on virtual machine (i.e. copy from your project DB settings).
- Test your connection.
Or just visit the page which URL I posted at top.
Solution 3
If you're using Homestead, these settings worked just fine for my Vagrant box:
Host: 192.168.10.10
Port: 3306
Username: homestead
Password: secret
Then again, so did MilanG's answer, so pick whatever you feel comfortable with. Since it's just local for me I did this and then I won't have to update my keyfile path should I move my Vagrant box. But that's really minor so do whatever you feel is best.
Related videos on Youtube
gnardell
Updated on June 15, 2022Comments
-
gnardell almost 2 years
I can not create a connection to a MySQL database in a vagrant machine with PhpStorm.
My settings are:
DATABASE tab:
- Host: 127.0.0.1
- Port: 3306
- User: root
- Password: root_passswordSSH/SSL tab:
- Proxy host: 192.168.56.102
- Port: 22
- Proxy user: vagrant
- Proxy password: vagrantCan someone help me? Thanks
-
LazyOne almost 9 years
-
-
mfink about 8 yearsthanks, the
vagrant ssh-config
command helped me find which key to use in phpStorm.