MySQL Bugs: #59094: Error 1364 during install in MySQL Instance Configuration Wizard

Bug #59094	Error 1364 during install in MySQL Instance Configuration Wizard
Submitted:	21 Dec 2010 16:31	Modified:	21 Dec 2010 19:06
Reporter:	Justin Cranford	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S3 (Non-critical)
Version:	5.5.8	OS:	Windows (Windows 7 Enterprise x64)
Assigned to:		CPU Architecture:	Any

Description:
The MySQL 5.5.8 x64 essentials installer launches the MySQL Instance Configuration Wizard. If you check the option to allow remote access to the root account, you get error 1364. The error is "Connection failed with the following error - Error Nr 1364 - Field authentication-string doesn't have a default value".

Clicking "Skip" on the error prompt allows you to go back and uncheck the "allow remote access for root account", but moving forward the installer displays an error "cannot add MySQL server because it already exists" and hangs for a long time.

I had to cancel the install, remote the "C:\Program Files\MySQL" and "C:\ProgramData\MySQL" directories, and do a new install all over again.

How to repeat:
Run the MySQL 5.5.8 x64 essentials installer on Windows 7 Enterprise x64. In the MySQL Instance Configuration Wizard, check the box to "enable remote access to the root account". When you get to the Execute step, it will give you an error 1364. If you try to click "Skip" and go back to uncheck the "remote root access" option, you can try to move forward but it will fail.

Suggested fix:
Fix the MySQL Instance Configuration Wizard to be more resilient when re-executing after a partial success.

Better yet, fix the root cause of the error. The wizard fails to add a row to the mysql.user table because the authentication-string column does not have a DEFAULT value in the schema. Add a default value to that table, and change the Instance Configuration Wizard to specific that value when inserting a value into mysql.user.

Lots of identical or similar reports exist already - including:

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

(follow links in the reports and also understand that if you upgrade from before 5.5.7 you will need to start mysqld from command line with --skip-grant-tables option, run mysql_upgrade after what the server can be started as a service).

Peter
(not a MySQL person)

This is a duplicate of Bug #59038.

Thanks Justin, install finally completed! :)

mysql 5.5 bug apply security settings
mysql server instance configuration wizard apply security settings
authentication string doesn't have a default value
enable root access from remote machines
grant user error
mysql 5.5 reset root password ( password true but not login )
windows 2008 server

Mysql port açma kısmını otomatik olarak halletmektedir.

Mysql instance namelerden birini ekleyip silerseniz.
Yeni bir tane eklemek istediğiniz sizden eski şifreyi isteyecektir.
Doğru girseniz bile hata verir.Bu hatalardan kurtulup Mysql'dışarıya açmak için
bazı ayarlar yapmak gerekir.

ilk önce mysql kaldırın.
program files'dan dosyaların tamamını silin.
sonra mysql 5.5.8 kurun.

"mysql server instance configuration wizard" yönetici olarak çalıştırın.
sağ click Administrator Run gibi.

Add Port Firewall seçin eklesin.

Dışarıdan bağlantıya izin vermek için seçilecek olan
"enable root access from remote machines" bu kısmı seçmeyin.

Mysql kurulumunu bitirin.

MySQL Workbench kurun.
Server Administration kısmından
kurduğunuz mysql instance name'ini seçin.

Manage Security Diyin
ordan üst menüden Accounts seçin.

root user görürsünüz.
root user tıklayın
özellikler bölümünden
"Limit Connectivity to Host Matching" bölümüne %
işaretini koyun.

ENGILISH :

Mysql add port auto. ( no user manual add )

Mysql instance remove and new instance name.(password error)
But password true :D old password , but new instalation. Result not login , and error message.

Now not error step

Step 1. Mysql Server uninstall
Step 2. Program Files Mysql Server directory delete ( all files )
Step 3. New MySql Server Instalation. ( or restart computer and install )
Step 4. Exit instance configration wizard.
Step 5. Mysql Server instance configuration wizart run Administrator. ( right click select menu )
Step 6. Installation select Add Port Firewall
Step 7. Not selected "enable root access from remote machines" ( beacuse error :D config workbench )
Step 8 Finish Mysql Server Instalation

Goto php.net , download Mysql Workbench and install.

Step1. Administration site , select instance name.
Step2. Select Manage Security.
Step3. Select Accounts
Step4. select left side root user, select or click
Step5. Right side root user options , "Limit Connectivity to Host Matching"
Step6. write % only ( Limit Connectivity to Host Matching=% ( all machine )
Step.End :D Finished mission complate.