why DBI always appends @'localhost' to the username?

From: Arne Götje (20030910antispam_at_gmx.net)
Date: 03/23/05 

To: dbi-users@perl.org
Date: Wed, 23 Mar 2005 15:00:12 +0800

Hi list,

please CC to me, I'm not on the list.

I have a problem using DBI on FreeBSD.
The mysql server is on a remote host and I can login with my username
manually.
However, the DBI module always appends a @'localhost' to the username,
even when I specify the username to be 'user@my_hostname'. The result
is, that the mysql server denies access. I don't have root permissions
on that server and access for me is only allowed from 'my_hostname'.

How do I tell DBI to *not* append @'localhost' to the username?

Cheers
Arne 

-- 
Arne Götje (高盛華) <20030910antispam@gmx.net> 
(Spam catcher.  Address might change in future!)
PGP/GnuPG key: 1024D/685D1E8C
Fingerprint: 2056 F6B7 DEA8 B478 311F  1C34 6E9F D06E 685D 1E8C
Key available at wwwkeys.pgp.net.   Encrypted e-mail preferred.

Relevant Pages

  • Re: fetching encrypted passwords for oracle username in Perl !
    ... I don't want to put my hardcoded username and password in my file. ... Instead of hard-coded passwords in my source code or an input file, ... Please let me know how to do that with Perl DBI? ... You focus on how to store datas into database, ...
    (perl.beginners)
  • Re: Simple Query Question
    ... > will look up the username. ... > the database, then what kind of value will MySQL or DBI return? ... There are many ways to invoke DBI, and your answer depends on which DBI ... the call may work but return no matching user. ...
    (perl.dbi.users)
  • Re: execute_array/execute_for_fetch (was: ANNOUNCE: Advanced DBI Tutorial Slides)
    ... changes to "Dynamically create the DBI Standard Interface" ... Yes, obvious, I was thinking from the app side (where ArrayTupleStatus ... My username is mjevans. ... Martin J. Evans ...
    (perl.dbi.users)
  • Re: Protecting a mod perl 1.3 site from slow MySql processes
    ... Recently during some maintenance on the MySql server, ... The perl module wasn't dying, so wrapping everything in evalwon't ... I tried setting alarm() around the DBI lines, ...
    (perl.dbi.users)
  • Re: sql and perl
    ... Then you could read the document for DBI, and try to program with it. ... I want to start learning about sql and how it interacts w/ perl. ... My rough idea is to install mysql server and read some books to start ...
    (perl.beginners)