win7 安装mysql 5.5.8最后Apply security settings 报错:
The security settings could not be applied to the database because the connection has failed with the following error.Error Nr. 1364
Field 'authentication_string' doesn't have a default valueIf a personal firewall is running on your machine, please make sure you have opened the TCP port 3306 for connections. Otherwise no client application can connect to the server. After you have opened the port please press [Retry] to apply the security settings.If you are re-installing after you just uninstalled the MySQL server please note that the data directory was not removed automatically. Therefore the old password from your last installation is still needed to connect to the server. In this case please select skip now and re-run the Configuration Wizard from the start menu.不知各位有没有碰到过？如何解决？
The security settings could not be applied to the database because the connection has failed with the following error.Error Nr. 1364
Field 'authentication_string' doesn't have a default valueIf a personal firewall is running on your machine, please make sure you have opened the TCP port 3306 for connections. Otherwise no client application can connect to the server. After you have opened the port please press [Retry] to apply the security settings.If you are re-installing after you just uninstalled the MySQL server please note that the data directory was not removed automatically. Therefore the old password from your last installation is still needed to connect to the server. In this case please select skip now and re-run the Configuration Wizard from the start menu.不知各位有没有碰到过？如何解决？
解决方案 »
- mysql订单表主键的自动生成
- 如何使用一条sql语句实现下面功能
- 哪有PostgreSQL odbc驱动下载
- 关于mysql数据库文件转移到另外一台Mysql服务器上
- 如何给一个用户授权，使他只能看到某一个表？
- 请问哪里可以找到mysql建表的插件,用sql语句会死人啊~~?
- mysql为何不能修改密码
- 我用我的WINDOWS下的MYSQL连上我边上一台RED HAT 7。2上的MYSQL，总是提示不充许我连它，但是它可以连上我的WINDOWS下的MYSQL呀，并且可
- 找人安装调试apache和mysql
- 关于hibernate添加纪录的问题
- mysqldump不锁表备份，怎么设置为好？
- mysql数据库 表中的字段类型 为什么会无缘无故的自动改变呢？
MySQL 5 uses a strict mode which needs to be disabled.
In Windows, Goto Start-->Programs-->MySQL->MySQL Instance Config Wizard. Follow through the Reconfigure Instance option-->Detailed Configuration-->Continue Next a few screens.
At the bottom under Enable TCP/IP option there is 'Enable Strict Mode'. Deslect this option (no tick). Save changes and MySQL will restart.