Linode Forum
https://forum.linode.com/

Can't connect to MYSQL server through SQLYog
https://forum.linode.com/viewtopic.php?f=19&t=5978		 Page 1 of 1
Author:  neode [ Fri Sep 03, 2010 5:19 am ]
Post subject:  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 "
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
Author:  hoopycat [ Fri Sep 03, 2010 6:30 am ]
Post subject: 
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
Author:  neode [ Fri Sep 03, 2010 6:48 am ]
Post subject: 
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
Author:  spaceguy [ Sat Aug 06, 2011 11:18 pm ]
Post subject: 
You can now connect to a MySql DB directly with SQLYog with the SSH tab in the Connection Dialog box. Much easier.
Page 1 of 1 All times are UTC-04:00
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/