Re: Database access on your site, or "Where the hell is mysql?"

If you have mysql installed and running on your development system, and mysql is installed and running on the remote system, and the development box is able to ping the remote box, then you should be able to connect to the remote database using the "mysql" command line on your dev system:

 mysql -h remote.host.name -u useraccount -ppassword dbname
[download]

where the useraccount, password and dbname are whatever you're using for the db connection on the remote version of your website. This sort of remote server access with mysql is very common.

Comment on Re: Database access on your site, or "Where the hell is mysql?" Download Code

Replies are listed 'Best First'.
Re^2: Database access on your site, or "Where the hell is mysql?" by SkipHuffman (Monk) on Oct 02, 2005 at 15:58 UTC
That sounds like exactly what I need, but I suspect that I am blocked from that access. Here is what I tried: `mysql -h mysql2.america.net -u flying -p***** databasename` [download] And I get no response for quite some time. mysql appears to be waiting for something, it just sits and waits. Eventually it times out and I get "ERROR 2003 (HY000): Can't connect to MySQL server on 'mysql2.america.net' (110)" Thanks though! I guess I need to get the php admin working. Skip	[reply] [d/l]

Replies are listed 'Best First'.

Re^2: Database access on your site, or "Where the hell is mysql?"
by SkipHuffman (Monk) on Oct 02, 2005 at 15:58 UTC

That sounds like exactly what I need, but I suspect that I am blocked from that access. Here is what I tried:

mysql -h mysql2.america.net -u flying -p***** databasename
[download]

And I get no response for quite some time. mysql appears to be waiting for something, it just sits and waits. Eventually it times out and I get "ERROR 2003 (HY000): Can't connect to MySQL server on 'mysql2.america.net' (110)" Thanks though! I guess I need to get the php admin working.

Skip

[reply]
[d/l]