MySQL Forums
Forum List  »  Install & Repo

Re: Can't get MySQL 5.5 to install on Windows 7
Posted by: dreuzel dreuzel
Date: December 29, 2010 04:55AM

Mysql install Apply security Settings FAIL Authentication string does not have a default value

Instance configuration Wizard
Apply security Settings FAIL

envir Win7 x64 mysql 5.5.8

Authentication string does not have a default value

Situation DEAD LOCK
Reinstall with erase of registry and all files in mySQL directory Fail
introducing previous ibdata1 db file does not help
Error message explanation is unclear and seems not to help even after replacing the DB


PLease HELP, this problem has roots since all versions no clarity or information is given
it is the MYSQL HORROR, I refuse to install mysql anymore it behaves totaly unpredictable
with nothing left for the user to do
Reported as BUG before ....

there is hardly any need to explain any further it happens on every install
fully reproducable.... clearly the software was never tested or is this an attempt from Oracle
to kill mysql ????

there are notes of the problem from the release date
what is the latest working msql 5.5.8 is NOT USABLE the problem can not be bypassed!!!!!

what is the impact of the tools
native connection do they have a relation??
do they need to be cleaned before /after instance....)
The following patch gives it a one shot...
but as anything goes wrong
its back to erase all
and reinstall (definition of crappy software ?? a good introduction to beginners ???))

> login the DB :: using anonymous or root ??
> alter the table
mysql -u root
USE mysql;
alter table user change authentication_string authentication_string text;
UPDATE USER SET authentication_string = '' WHERE authentication_string IS NULL;

> creation of instance again

mysql -u root
USE mysql;
ALTER TABLE user CHANGE authentication_string authentication_string TEXT NOT NULL;

> execute the security again ??? and Your dead again

Options: ReplyQuote

Written By
Re: Can't get MySQL 5.5 to install on Windows 7
December 29, 2010 04:55AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.