Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling
 
PerlMonks  

Re^2: how to connect to mysql as anonymous user with perl

by oko1 (Deacon)
on Dec 30, 2010 at 18:46 UTC ( [id://879855]=note: print w/replies, xml ) Need Help??


in reply to Re: how to connect to mysql as anonymous user with perl
in thread how to connect to mysql as anonymous user with perl

Invoking MySQL without a username or a password defaults to the current login and no password:

perl -MDBI -we'my $dbh=DBI->connect("dbi:mysql:","","")' DBI connect('','',...) failed: Access denied for user 'ben'@'localhost +' (using password: NO) at -e line 1

...and there doesn't seem to be any way to force it to accept a blank username, either:

mysql --user="" --password="" ERROR 1045 (28000): Access denied for user 'ben'@'localhost' (using pa +ssword: NO)
-- 
Education is not the filling of a pail, but the lighting of a fire.
 -- W. B. Yeats

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://879855]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others musing on the Monastery: (7)
As of 2024-04-23 16:54 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found