Re: DBI Access Denied with blank password

[rodion]

From the MySQL documentation of access-denied

If you get the following error, it means that you are using an incorrect root password:

shell> mysqladmin -u root -pxxxx ver
Access denied for user 'root'@'localhost' (using password: YES)

If the preceding error occurs even when you have not specified a password, it means that you have an incorrect password listed in some option file. Try the --no-defaults option as described in the previous item.

Also note that it's somtimes necessary to include a specific entry for "localhost" in the authroiztion tables, even though there is a wild-card entry that you think should cover the "localhost" case. It has to do with precedence and interactcion between tables, I think, but I can't find the spot in the documentation that mentions it, from where I am right now.

[Grey_Magus]

Current testing suggests our problem is a Perl issue, as I've strayed from The Path and created a simple test case in a different language that is able to connect both as a user with and without a password.

As an added clue, while I can connect to the database using the DBI and a user with a password, the user seems to time out doing select queries. It can do inserts and updates, but sending select statements seem to cause the connection to hang.

[Anonymous Monk]

Try a different driver (DBD)

[Grey_Magus]

We tracked the problem down to Net::MySQL which is being used by our mysqlPP driver. Switching from Version 0.9 back to 0.8 'fixed' our problem, which seems related to the way in which the module handles older (this database is running the v4.1.10 of MySQL) databases.