Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

use Perl Log In

Log In

[ Create a new account ]

Purdy (2383)

Purdy
  jasonNO@SPAMpurdy.info
http://purdy.info/
AOL IM: EmeraldWarp (Add Buddy, Send Message)
Yahoo! ID: jpurdy2 (Add User, Send Message)

Bleh - not feeling creative right now. You can check me out on PerlMonks [perlmonks.org].

Journal of Purdy (2383)

Friday November 02, 2001
10:51 AM

Found out what was going on w/ MySQL!

[ #1147 ]
For some reason, MySQL ignores your port specification unless you specify a hostname. It assumes without a hostname that you're wanting to connect to the localhost AND through the UNIX socket instead of TCP/IP. I'm no networking genius, so I don't know if that summed it up right, but to fix it, I just had to put in the DSN:

DBI:mysql:database=$db;hostname=www.myhost.com;port=3309

Then I had to grant privs to the username connecting from the host and voila! I had a script if placed on one place in the server connected to a development db server and if it were somewhere else, connected to the production db server.

happy happy joy joy!

As always, thanks go out to the fine chaps @ PerlMonks!

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.