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 "". 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:

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

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

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

_________________

/* TODO: need to add signature to posts */

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

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