Security settings won"t take during installation

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/win32?unsub=gcdmw-win32@m.gmane.org

Re: Security settings won"t take during installation

On 8/24/06, 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 "

The wizard tries to connect to "localhost", using user "root" with no
password, any change to this settings before you run the installer
cause that error. As you said, simple... Check the MySQL Manual for
"Recovering root password" and try it. Also try learningg the basics
of MySQL without trusting the wizards. Good luck.

--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Security settings won"t take during installation

Hi Adrian,

On 8/25/06, Adrian Greeman wrote:
> "The security settings could not be applied to the database because the ......

I am pasting here the text of one of my earlier posts to this list:
--------------------------------------------
I got MySQL 5.0.22 running successfully on Win-XP-SP2 as follows:

1) Download the no-install zip package of MySQL-5.0.22 from the website.
2) Unpack it in the directory of your choice (C:\mysql5 - for example)
3) Create a top-level folder - C:\mysql5Data for the data directory.
4) Cut the contents of C:\mysql5\data directory and paste the same
into C:\mysql5Data.
5) Delete C:\mysql5\data directory.
6) Create a copy of an appropriate mysql-xxx.ini file and rename it to MY.INI.
7) Change the value of the data-dir variable to C:/mysql5Data - NOTE
FORWARD INSTEAD
OF BACK-SLASHES.
8) Create another top-level C:\InnoDBData folder.
9) Change appropriate InnoDB data-directory variables in C:\my.ini
(with forward slashes!)
10) Right-click MY COMPUTER icon on the desktop and select properties
from the shortcut
menu. Goto the Advanced tab and select Environment [Variables].
Select PATH in the \
system variables and add C:\mysql5\bin; at the beginning of it.
Apply and OK.
11) Select RUN from the start menu, type CMD and press ENTER.
12) Right click the C:\InnoDBData folder, select Properties from the
shortcut menu and
add "LOCAL SERVICE" user-account in the security tab and give it
"Full Control" access.
13) Do the same as in 12) with the C:/mysql5Data folder.
12) type mysqld-nt --install YourServiceName
--defaults-file=C:\mysql5\my.ini --local-service
and press ENTER.
13) type NET START YourServiceName AND PRESS ENTER.

Now you have MYSQL-5.0.22 installed on WinXP-Pro-SP2.

Forget about the automatic installer. I got similar errors like yours.

Additionally, I have found that the MySQL ODBC driver installs best
when you do it manually - that is, hand-copy files into the Windows
System32 directory. In addition, as I have found, it complains that
some MSVCR7.dll is missing. When I searched for the file on Google,
the search engine led me to some DllFiles.com (or some similar
webpage) where I got the file, downloaded the same to my computer and
everything worked like a cinch!

--
Asif

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org

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:service@dennisyu.idv.tw]
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/win32?unsub=gcdmw-win32@m.gmane.org

RE: Security settings won"t take during installation

I did that already - uninstall and deleting the residual Program files - but
it still happens. But perhaps the port issue is one - how do you ensure the
port is open (I have Zone Alarm and it shows ticks for MySQL access but
maybe not that port?)

Thanks

-----Original Message-----
From: Greg Joss [mailto:gregjoss@gmail.com]
Sent: 24 August 2006 22:46
To: 'Adrian Greeman'
Subject: RE: Security settings won't take during installation

I ran into the same problem. I uninstalled MySQL and reinstalled it with the
same results. Then I uninstalled it and deleted the MySQL directory under
Program Files and it installed correctly. Also make sure port 3306 is open
before you do the install.

Good luck -

Greg

-----Original Message-----
From: Adrian Greeman [mailto:adrian.greeman@constructionplus.net]
Sent: Thursday, August 24, 2006 3:40 PM
To: win32@lists.mysql.com
Subject: Security settings won't take during installation

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/win32?unsub=gregjoss@gmail.com




--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org