Skip Menu |

This queue is for tickets about the Class-DBI-Sweet CPAN distribution.

Report information
The Basics
Id: 15890
Status: open
Priority: 0/
Queue: Class-DBI-Sweet

Owner: Nobody in particular
Requestors: m.romani [...]

Bug Information
Severity: Unimportant
Broken in: (no value)
Fixed in: (no value)

Subject: MySQL config suggestions to test under Win32
Download (untitled) / with headers
text/plain 819b
The tests try to connect to database 'test' with no username and no password. The resulting error under Win32 is access deined for user 'ODBC'@'localhost'. The fix is obvious: create database test; grant select,insert,update,delete,create,drop on test.* to 'ODBC'@'localhost'; flush privileges; but it doesn't work. The reason is that the parameter sql-mode is, by default: sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" The option NO_AUTO_CREATE_USER prevents you from creating passwordless accounts. If you remote it and restart mysql, the previous statements work fine, and the mysql tests can run. (The parameter is in my.ini, whose default location is the MySQL Server subdir. To find out which config file you are using I recommend you install mysql-administrator from
I'd be happy to fix this if you could provide a patch against the latest stable version.

This service is sponsored and maintained by Best Practical Solutions and runs on infrastructure.

Please report any issues with to