Linode Forum

[neode]

Hello All,

I am a new Linode user and signed up to Linode just yesterday and have installed LAMP for my environment. After installation, I am able to login using winscp and putty successfully.

When I am trying to connect to MySQL through SQLYog, I am receiving " Quote: Error no. 2003 can't connect to MYSQL server on 'My IP' (10061) ". But I am able to connect to mysql through putty and have created a database and given rights using the following queries, as given in Linode Library:

Code: create database mydatabase;
grant all on mydatabase.* to 'myusername' identified by 'mypassword';
flush privileges;

Do I have to set any rights or privileges?

I am completely stuck up... please help to solve my issue.

Thanks in advance.

Cheers

[hoopycat]

For obvious security reasons, MySQL is not accessible to the Internet by default. Take a look at:

http://library.linode.com/databases/mysql/mysql-ssh-tunnel

[neode]

Hello Hoopycat,

Thanks for the imm. reply :). As per your instruction, I have tried with SSH Tunnel and now things are working fine. I am able to login with sqlyog.

Cheers

[spaceguy]

You can now connect to a MySql DB directly with SQLYog with the SSH tab in the Connection Dialog box. Much easier.