Access denied for user 'root'@'localhost' (using password: NO)

win7 32位系统

mysql 5.1

 

debug信息:

ODS: ExecuteSql Exception: [MySQL][ODBC 5.1 Driver][mysqld-5.1.40-community]Incorrect datetime value: '2012/2/3 insert into sys_logs (happend_date, log_type, host, sys_type, username, sub_type, content) values(:time, :LogType, :Host, :SysType, :UserName, :SubT Process DMS.exe (4048)
ODS: Query Exception: [MySQL][ODBC 5.1 Driver]Access denied for user 'root'@'localhost' (using password: NO) Process DMS.exe (4048)
ODS: Query Exception: [MySQL][ODBC 5.1 Driver]Access denied for user 'root'@'localhost' (using password: NO) Process DMS.exe (4048)
ODS: Query Exception: [MySQL][ODBC 5.1 Driver]Access denied for user 'root'@'localhost' (using password: NO) Process DMS.exe (4048)

 

过程:

一样的程序, 在XP和2003下运行正常, 后面在win7下运行时出现之上的错误, 头很大. 百度和google一圈之后无果.

有的说要改密码, 有的说安装不正确, 按照所有的方法尝试后都没解决.

后面'2012/2/3'看了下, 是否是时间格式的问题, 于是修改了下2012-2-3居然就好了.

看来有些问题真的挺个性的.

转载于:https://www.cnblogs.com/doorsky/archive/2012/02/05/2338952.html