Re: [PHP] Re: mysql_connect noob question

2013-04-21 Thread Glob Design Info
As shown in the OP I am already doing that in the PHP scipt: $host = "instance43490.db.xeround.com:8904"; And then passing that as the 1st param to mysql_connect On 4/21/13 4:23 PM, Stuart Dallas wrote: On 22 Apr 2013, at 00:14, Glob Design Info wrote: However, I may have found the problem:

Re: [PHP] Re: mysql_connect noob question

2013-04-21 Thread Stuart Dallas
On 22 Apr 2013, at 00:14, Glob Design Info wrote: > However, I may have found the problem: the port. As a security measure the > BaaS provider appears to have changed MySQL to a non-standard port. > So > > On the command line: > > sudo mysql --host=instance43490.db.xeround.com --p

Re: [PHP] Re: mysql_connect noob question

2013-04-21 Thread David Robley
Glob Design Info wrote: > On 4/21/13 3:27 PM, Stuart Dallas wrote: >> On 21 Apr 2013, at 20:29, Glob Design Info wrote: >> >>> If that is the case then why does logging in with exactly the same >>> params from a UNIX shell work fine? Command line login supposedly would >>> be adding the @localhos

Re: [PHP] Re: mysql_connect noob question

2013-04-21 Thread Glob Design Info
On 4/21/13 3:27 PM, Stuart Dallas wrote: On 21 Apr 2013, at 20:29, Glob Design Info wrote: If that is the case then why does logging in with exactly the same params from a UNIX shell work fine? Command line login supposedly would be adding the @localhost or @IP_address as well but isn't. Onl

Re: [PHP] Re: mysql_connect noob question

2013-04-21 Thread Stuart Dallas
On 21 Apr 2013, at 20:29, Glob Design Info wrote: > If that is the case then why does logging in with exactly the same params > from a UNIX shell work fine? Command line login supposedly would be adding > the @localhost or @IP_address as well but isn't. Only when I pass the > variables to the

Re: [PHP] Re: mysql_connect noob question

2013-04-21 Thread Glob Design Info
This for a commercial app - the client wants both an API connect via PHP and a web portal in which they can login from a web page and view the tables in the DB. Right now I am just trying to get the form/PHP interaction to work. On Apr 21, 2013, at 6:42 AM, tamouse mailing lists wrote: > On S

Re: [PHP] Re: mysql_connect noob question

2013-04-21 Thread Glob Design Info
If that is the case then why does logging in with exactly the same params from a UNIX shell work fine? Command line login supposedly would be adding the @localhost or @IP_address as well but isn't. Only when I pass the variables to the script is that happening. I am doing exactly as you stated:

Re: [PHP] Re: mysql_connect noob question

2013-04-21 Thread tamouse mailing lists
On Sun, Apr 21, 2013 at 5:20 AM, Glob Design Info wrote: > I am aware of the security implications. I will deal with that later. Right > now I am just trying to get the WS architecture working. I'm wondering, if you can get it to work with the creds in the script, why do you have to have them co

Re: [PHP] Re: mysql_connect noob question

2013-04-21 Thread Stuart Dallas
On 21 Apr 2013, at 11:20, Glob Design Info wrote: > I don't understand why mysql_connect should append something in the case of a > passed variable but not in the case of a local variable. Unless there is > something in the form parsing machinery I am unaware of. Nothing is being added by anyt

[PHP] Re: mysql_connect noob question

2013-04-21 Thread Glob Design Info
Thanks Geoff, I am aware of the security implications. I will deal with that later. Right now I am just trying to get the WS architecture working. I am logging in with the creds the hosting provider gave me (xeround.com) When I use those creds on the mysql command line, or hard-code them in the

[PHP] Re: mysql_connect noob question

2013-04-21 Thread Glob Design Info
Thanks for that great response Geoff. That very well may be what is wrong, however, my problem is I don't have admin access to this server - it hosted in a BaaS site where they do all the admin. They do provide mysql command line access and it works, but it won't let me log in as root, not even