Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

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

by oko1 (Deacon)
on Dec 30, 2010 at 18:46 UTC ( #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? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (4)
As of 2021-10-24 01:28 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    My first memorable Perl project was:







    Results (88 votes). Check out past polls.

    Notices?