Re^2: DBI Access Denied with blank password

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.

Comment on Re^2: DBI Access Denied with blank password

Replies are listed 'Best First'.
Re^3: DBI Access Denied with blank password by Anonymous Monk on Apr 16, 2007 at 10:20 UTC
Try a different driver (DBD)	[reply]
Re^4: DBI Access Denied with blank password by Grey_Magus (Initiate) on Apr 18, 2007 at 23:39 UTC
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.	[reply]
Re^5: DBI Access Denied with blank password by ivancho (Hermit) on Apr 19, 2007 at 00:27 UTC
unless you have no compiler handy, I would heartily recommend switching from DBD::mysqlPP to DBD::mysql. It solved all my hanging/timing out/slowing down problems.	[reply]