I could use a little guidance, please! I have been connecting to my database using phpMyAdmin, which I know is not secure, so thought I would try a more secure method. I have read the wiki and have done the following:
added my ip to allowable hosts
granted my user ssh access
installed putty (on Debian 6.0.6) and entered info as instructed
installed MySQL Administrator and entered info as instructed
I can log into my shell account through putty with no problem. When I try to connect to my database using MySQL Administrator, I get the following error message:
Could not connect to host ‘localhost’.
MySQL Error Nr. 2002
Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)
I have tried entering 3307 in the source port and MySQL Administrator port field, but still get the same error.
Could anyone advise on how to connect? I really do not want my username/password to be exposed in plain text using phpMyAdmin. Thanks in advance.