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
In Section
Seekers of Perl Wisdom