By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,836 Members | 2,059 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,836 IT Pros & Developers. It's quick & easy.

How to connect remotely to Linux/MySQL using MySQL Query Browser

P: 93
Hi

http://dev.mysql.com/doc/query-brows...onnection.html

I'm trying to connect from my Windows based PC to a dedicated server which is running on Linux system.

I type server host and port 3306 user name admin + password and default schema and I get access denied message.

I use putty to connect to the server using IP and port 22 and it connects to the server.


What settings do I need to use to connect to MySQL using query browser?

Many thanks in advance.
Emil
Apr 12 '09 #1
Share this Question
Share on Google+
3 Replies


mwasif
Expert 100+
P: 801
Did you GRANT priviliges to your mysql user to connect remotely?
Apr 14 '09 #2

P: 93
I'm using admin with password which seems to have access to everything.
Apr 14 '09 #3

P: 93
Hi

Thanks I didn't understand what you exactly mean but finally I was able to find instructions how to add my IP address to the user table in MySQL so I can connect remotely--- didn't work first time but after

flush priviliges;

worked perfectly

Thanks
Apr 17 '09 #4

Post your reply

Sign in to post your reply or Sign up for a free account.