Help, how do i connect to MySQL remotely?

Question

User1659074768 posted

Hello.

Im a bit new to MySQL here. My friend wanted me to help him display some data on his site from his MySQL.

So he sent me his database username and password.

I would like to know, how can i connect to the database using the credentials he gave me.

Wich program do i use, I heard something like I should use wamp server or something?

All im looking for is just a program, or a way in wich I can connect to his database using the username and password he gave me.

How can i do this?

Thanks.

Answer 1

User-269404413 posted

Richard,

try this http://www.codeproject.com/KB/database/mysqlinaspnet.aspx

Answer 2

User1659074768 posted

Richard,

try this http://www.codeproject.com/KB/database/mysqlinaspnet.aspx

Hi, thanks for the reply.

It is not an asp.net site, it is in PHP, wich is why I need the MySQL

Any ideas?

Answer 3

User1824551582 posted

Do you want to connect to the database from PHP or just to have access to the database system?

Please clearify  

Answer 4

User1659074768 posted

Do you want to connect to the database from PHP or just to have access to the database system?

Please clearify  

Hi, all I want to do is to have access to the database.

So that i can create / modify tables etc.

Answer 5

User1824551582 posted

Is it hosted or running on local server?.

If hosted, then you can access the database via the controll panel (that is phpmyadmin)

but, if it is running on local server, u can try MySQL Workbench.

NB: MySQL workbench might not be able to work on remote host, as most service providers does not allow remote connection to the database

Answer 6

User1659074768 posted

It is running on a website host, and I would like to connect to it remotely via my desktop. As I do not have hosting access to the account. I was just given the database host, username and password, to do the work accordingly.

Is there any third party apps you know of that allows to connect to a database remotely, or any other ideas?

Thanks

Answer 7

User1824551582 posted

You can try SQL Yog or Mysql workbench.

But depends on the host provider to give you remote access.

Most linux servers have default configuration not to allow remote connection, which can be manually set to allow from a specified IP address.

Answer 8

User1659074768 posted

You can try SQL Yog or Mysql workbench.

But depends on the host provider to give you remote access.

Most linux servers have default configuration not to allow remote connection, which can be manually set to allow from a specified IP address.

Alright thanks, will try