Can't connect to MYSQL server through SQLYog

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

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

3 Replies

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">http://library.linode.com/databases/mysql/mysql-ssh-tunnel

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.

Reply

Please enter an answer
Tips:

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (https://www.google.com)

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Community Code of Conduct