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

[emsik1001]

Hi

http://dev.mysql.com/doc/query-browser/en/mysql-query-browser-connection.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

[mwasif]

Did you GRANT priviliges to your mysql user to connect remotely?

[emsik1001]

I'm using admin with password which seems to have access to everything.

[emsik1001]

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