Has anyone connected to a remote server using SP? Local connections
work fine.
Todd
offtopic mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options
Yes I use it, locally and remotely.
On 11 Jan 2009, at 8:36 pm, Todd wrote:
Has anyone connected to a remote server using SP? Local connections work fine.
David Owen ::
Freeway Friendly Web Hosting and Domains
http://www.ineedwebhosting.co.uk
Are you using SSH by chance? I can’t connect no matter what I try.
T.
On Jan 11, 2009, at 2:39 PM, David Owen wrote:
Yes I use it, locally and remotely.
On 11 Jan 2009, at 8:36 pm, Todd wrote:
Has anyone connected to a remote server using SP? Local connections work fine.
Works fine here as well. Remember, you need firewall open on port
3306, and you also have to have a MySQL user on the server you’re
connecting to bound to either host % (any host) or to the host you
will be connecting from.
Walter
On Jan 11, 2009, at 3:39 PM, David Owen wrote:
Yes I use it, locally and remotely.
On 11 Jan 2009, at 8:36 pm, Todd wrote:
Has anyone connected to a remote server using SP? Local connections
work fine.David Owen ::
Freeway Friendly Web Hosting and Domains
http://www.ineedwebhosting.co.uk
offtopic mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options
offtopic mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options
Yep, worked for me. It’s looking for your mysql user name and password, not your site user name and password.
offtopic mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options
Well I can’t get it working. Must have incorrect creds.
T.
On Jan 11, 2009, at 2:43 PM, Walter Lee Davis wrote:
Works fine here as well. Remember, you need firewall open on port
3306, and you also have to have a MySQL user on the server you’re
connecting to bound to either host % (any host) or to the host you
will be connecting from.Walter
On Jan 11, 2009, at 3:39 PM, David Owen wrote:
Yes I use it, locally and remotely.
On 11 Jan 2009, at 8:36 pm, Todd wrote:
Has anyone connected to a remote server using SP? Local
connections work fine.
offtopic mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options
I don’t quite follow this.
On Jan 11, 2009, at 2:43 PM, Walter Lee Davis wrote:
and you also have to have a MySQL user on the server you’re
connecting to bound to either host % (any host) or to the host you
will be connecting from.
offtopic mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options
Each user that you create in MySQL has a host attribute, along with the usual login and password. By default, this will be set to localhost. If you want to use the same login from many different hosts, then you would set that to the wildcard, which is %. The safer thing to do is have a different login for each host you will be connecting from.
So if you were logging in from my laptop to a server on my in-office net, you would need a login that was bound to al.local. But if you were running a script on that server, you would need a login that was good for localhost.
Walter
offtopic mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options
One other thing. When I tried this the first time I didn’t include the database name. Although I did make the mysql connection, SQL Pro did not open a database nor did it show a list of available databases. It wasn’t until I included the database name did it actually open one up.
offtopic mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options
Thanks for the explanation. I got it working just before you posted.
As it applies to this example I’m connecting from a single computer to
my own server/db.
I went into my cPanel and under Remote MySQL I added my home IP
address as an access host, then I was able to connect using Sequel.
I still need to access some clients servers so I assume that I’ll need
to go into their control panels respectively and add my IP as an
access host. Correct?
Chuckamuck: For me SP did show a list of db names without having
specified one in the setup.
Todd
On Jan 11, 2009, at 7:49 PM, waltd wrote:
Each user that you create in MySQL has a host attribute, along with
the usual login and password. By default, this will be set to
localhost. If you want to use the same login from many different
hosts, then you would set that to the wildcard, which is %. The
safer thing to do is have a different login for each host you will
be connecting from.So if you were logging in from my laptop to a server on my in-office
net, you would need a login that was bound to al.local. But if you
were running a script on that server, you would need a login that
was good for localhost.
offtopic mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options