RE: Security settings won't take during installation

Thanks for the reply. I did c heck it but put the originally entered
password and then the same one again for the new password,
But the problem occurs anyway when I first run the configuration at the
first install so it is not one of changing the configuration.

I have uninstalled seveal times and deleted the program files remainning and
restarted before reinstalling but still get the same issue. The confugration
does the first three of the four tasks but fails on the securtiy settings.

It maybe a firewall issue but I also did this with the firewall off and got
the same.

The firewall is Zone Alarm (free issue). OS is Win  XP SP2.

Thanks Adrian G

 

-----Original Message-----
From: Dennis Yu [mailto:[email protected]] 
Sent: 25 August 2006 02:34
To: Adrian Greeman
Subject: Re: Security settings won't take during installation

I think you've put a check mark in the box of "Modify Security Settings" 
when in MySQL Server Instance Configuration Wizard.  Which changed your
original root password (if you're upgrading from previous version).

Try use "mysql" client from command prompt, login root with blank(empty)
password, or the one you last assigned, or do below remove and reinstall.

If you try reinstall MySQL, first stop MySQL service from Windows, go to
Control Panel remove it, then reinstall it.  If your old mysql database
  exists, it means user account of root already exists, then when arrive
above point, do not check the box of "Modify Security Settings", then you'll
be allowed to login root with old original password.

Try it, :)

Good Luck
Dennis Yu.

Adrian Greeman wrote:
> I am sure this is a very basic thing
> 
> I ran the setup programme for MySQL 5 (I have done this previously on 
> another computer with no problems). When I tried to go through the 
> configuration wizard all went well and the server service started up 
> but at the end I got the following:
> 
> "The security settings could not be applied to the database because 
> the connection has failed with the following error
> 1045 access denied for user root@localhost etc "
> 
> So I cannot connect of course or do anything to the permissions and so on.
> 
> I have Win XP SP2 with all the security updates and Apache 1.3 running.
> 
> I cannot understand what is happening - I am using a different 
> firewall on this computer ZoneAlarm - whereas previously I had Kerio - 
> but it lists MySql as granted permissions to access and to act as a 
> server. I even turned off ZoneAlarm before installing but still get 
> this result.  Reconfiguing just produces the same.
> 
> This must be a common problem - and I realise it may have been 
> answered before but do not know where to look. Please may I request a 
> small amount of time from someone to point me at the answer?
> 
> Thanks
> 
> Adrian
> 
> 
> 




-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]