distal-attribute
distal-attribute
distal-attribute
distal-attribute

Newbie - How to create a remote connection?

User, date Message
Written by djpilot
3 years ago
Category: Creating a connection
3 posts since Tue, 05 Apr 11
Hi, I am trying to use HeidiSQL to connect to my web hosting.
I can connect using my web hosts CP and edit/create/delete my databases & tables, but haven't been able to work out how to make HeidiSQL connect.
I would apprecate some assistance.

Thanks
Written by ansgar
3 years ago
4967 posts since Fri, 07 Apr 06
How did you manage to edit/create/delete a database and tables without a MySQL connection? Or did you do that with a different client than HeidiSQL?

To create a connection in HeidiSQL you set up a new session in the session dialog (starting screen). Hostname, User, Password should all be intuitive. What is unclear?
Written by djpilot
3 years ago
3 posts since Tue, 05 Apr 11
Hi anse,
I used MyPHPAdmin through my hosting providers control panel (as mentioned in my original post) to create the database and table.

When heidisql starts, I have tried entering the IP address of my host, using my username and password, And it wont connect.
I get an error message 'SQL Error(1045): Access denied for user '.....' (using password: YES).

So, still no success unhappy
Written by ansgar
3 years ago
4967 posts since Fri, 07 Apr 06
Well the error is highly informative. Means you have probably mistyped user and/or password, or the server does not allow external connections. However, there are tons of other causes, see http://dev.mysql.com/doc/refman/5.1/en/access-denied.html .
Written by Plasm
3 years ago
72 posts since Fri, 10 Sep 10
As anse said, most hosting provider disallow a connection from another IP than the webserver-/database-server IP.
If you like to use HeidiSQL, you can backup your tables (phpMyAdmin), manipulate them locally (HeidiSQL) and upload them afterwards (phpMyAdmin).
Written by djpilot
3 years ago
3 posts since Tue, 05 Apr 11
Hi Anse, thanks for your comments. It's not really that informative as it could be 1 of 'tons' of causes!... But I will assume that its because the hosting provider won't allow external connections which means the only real option is to do what Plasm suggests (Thanks Plasm). I was hoping for a simple interface/application rather than a 3 step process. Maybe I am just too fussy as I don't like using web interfaces.

Regards and thanks to all.
Written by ansgar
3 years ago
4967 posts since Fri, 07 Apr 06
I'm still unsure because the error message says nothing about the fact that the server is not reachable from outside. I'm nearly sure now your user account is restricted to internal access, not the server itself. You could ask your provider to allow connections from user xyz from "%".
 

Please login to leave a reply, or register at first.