| Subject: | MySQL config suggestions to test under Win32 |
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 mysql.com)