Bug #59247 Installation failure and unable to connect to the database

• Submitted: 31 Dec 2010 19:51
• Modified: 31 Dec 2010 20:22
• Reporter: Araf Karsh Hamid
• Status: Duplicate
• Category: MySQL Server: Config Wizard
• Severity: S1 (Critical)
• Version: 5.5.8
• OS: Windows (Windows 7)
• CPU Architecture: Any
• Tags: Connection failure, Installation failure

[31 Dec 2010 19:51] Araf Karsh Hamid

Description:
While using MySQL Server Instance Configuration 
It fails at "Apply Security Settings" with the following Error
Error Nr. 1364
Field: 'authentication_string' doesn't have default value

OS: Windows 7
DB: MySQL 5.5.8 GA

Why is it critical?
This error stops the installation and unable to use the database.

How to repeat:
Start the Configuration Instance Wizard
1. Detailed Configuration
2. Server Machine
3. Transaction Database Only
4. InnoDB Table Space
5. Manual Settings for connection (10)
6. Enable TCP/IP Networking (Add Firewall exception checked) default Port (3306)
7. UTF8 (Character Set)
8. Install as Windows Service
9. Security Options (Checked Enable root access from remote machine)
10. Ready to Execute (Starts the Service and fails at 'Apply Security Settings')

[31 Dec 2010 19:55] Araf Karsh Hamid

MySQL Error 1364

Attachment: mysql_12.png (image/png, text), 341.47 KiB.

[31 Dec 2010 19:56] Peter Laursen

All these are about the same (same underlying reason - different symptoms)

http://bugs.mysql.com/bug.php?id=58962
http://bugs.mysql.com/bug.php?id=58965
http://bugs.mysql.com/bug.php?id=58954

Also read:
http://dev.mysql.com/doc/refman/5.5/en/news-5-5-7.html

Peter
(not a MySQL person)

[31 Dec 2010 20:00] Valeriy Kravchuk

This is a duplicate of Bug #59038.

[31 Dec 2010 20:04] Araf Karsh Hamid

Hey Peter,

Anyway to get out of this mess. I installed the 5.5.8 on a new system with 64 bit Windows 7.

K

[31 Dec 2010 20:08] Peter Laursen

Just either

1) don't select 'strict' mode in the wizard
and/or 
2) Don't allow root-connection from remote host and don't add anonymous user. 
.. the wizard will continue.  Use another client to add users and edit configuration manually

It is not critical that the wizard fails as long as you can start the server. You can edit configuration and add users manually.

[31 Dec 2010 20:22] Araf Karsh Hamid

I made it work. 
The only change I made was to un-check the "Enable Strict Mode"

The entire trouble shooting cost 4 hours. 

K

[31 Dec 2010 20:27] Araf Karsh Hamid

Un-Check 'Enable Strict Mode'

Attachment: mysql_06a.png (image/png, text), 65.28 KiB.