

It has support for everything I need with the plugins and the integration with Git is amazing. After watching some more tutorial videos I noticed that everyone was using Visual Studio Code. In such cases the remote ip(in this case 192.128.11.120) wont work. One thing to keep in mind is that most of the time the bind address is set to localhost/127.0.0.1 in MySql to make it secure on the remote servers to enable only ssh connections. PhpStorm is kind of slow, I found that Prettier was taking a long time to format my code, and it just was lagging a lot so I was looking for alternatives. 3 - Go to 'General' Tab to add the MySQL related entries. This was amazing all the features in PhpStorm I loved, the debugging features, and the control click feature when you click on a dependency or linked file it will take you to that file. Both are bare metal machines and I am the only one who can access it. The new setup is an AMD Ryzen 9 5950X with 128G RAM, no load and only MySQL 8 running on Ubuntu 20.04. I finally converted over to PhpStorm as I was working with Magento and Magento as you know is mainly #PHP based. The old setup is a Ubuntu 16.04 Server on bare metal Intel i7 64G RAM and MySQL 5.7 and is under medium load with many services running.
DATAGRIP MYSQL FULL
I find Sublime Text lacks some functionality, after all it is just a text editor rather than a full fledged IDE. I kept using Sublime Text for about 4-5 years. I found the speed amazing compared to some other tools at the time. I started coding in Sublime Text because all of the tutorials I was doing back then everyone was using it.

If you dont get any error, enter the following info. Try to ssh into your server from OSX like this: ssh -L 3306:localhost:3306 your-ssh-useryour-remote-host.

It looks like DataGrip fails to access the server via ssh. I've been in the #frontend game for about 7 years now. What you need to do is tell DataGrip to open a ssh port forward to the server (a tunnel) and then open a connection to MySQL.
