I will connect to MySQL on ubuntu cloud server everyday with
Mysql Administrator and
Mysql Query Browser GUI tools and I feel very slow in responding. I know it is possible to connect with ssh entering the below command in the terminal and then using the Mysql GUI tools.
ssh -L 3307:127.0.0.1:3306 mysql-server-ip
But this is not easy for everybody to run the above command in the terminal and then using the gui tools.
The above ssh command is also good and I felt as if I'm working on local databases but it would be best and easy for everybody if it had an option to specify that ssh command in the mysql gui tools itself.
Moreover I'm thinking to remove ip based restrictions as I'm using iptables rules only to allow mysql and other ports for the specific IPs on cloud server.
Is there any best and easy way of connecting to mysql like using certificate along with mysql gui tools?.
Finally what I'm expecting is, with Mysql GUI tools(Administrator & Query Browser):
- I want to easily connect to mysql with some certificate/key
- I want to remove ip based restriction so that whoever having key/certificate could connect to mysql
Anybody has any idea?. Thank you!