Re: Can't get MySQL 5.5 to install on Windows 7
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
WHat do I do REGENERATE THE WHOLE SYSTEM AS WELL
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
workbench
odbc
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
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.