Description:
I have run the server setup 3 times on win2k and once on XP - every time I get this dialog (ignore the ocr errors):
The security settings could not be a__Iied to the database because the
connection has failed with the following error ,
Error Nr , 1045
Access denied hr user 'root '_ 'localhost ' (using password : No )
If a personal firewall is running on your machine, please make sure you
have o_ened the TCP _ort 3306 hr connections , Otherwise no client
a__Iication can connect to the server , A_er you have o_ened the _ort
_Iease _ress IRetry _ to a__Iy the security settings ,
If you are re_installing a_er you just uninstalled the MySQL server _Iease
note that the data directory was not removed automatically , Therehre
the old _assword hom your last installation is still needed to connect to
the server , In this case _Iease select ski_ now and re_run the
Con_guration Wi_ard hom the start menu ,
Access denied for user 'root '_ 'localhost ' (using password : No )
Retry/Skip
I hit "Retry" and it works.
I am guessing the wiz starts the server then tries to connect, but the server hasn't finished starting yet.
How to repeat:
2.Get the server: http://www.mysql.com/ Downloads, Current Release, Windows Essentials 15.9M, Pick a mirror, Register (name and address) "[Hoobly Classifieds / Chicago, IL] HTTP"
3.mysql-essential-5.0.22-win32.msi – double click it.
4.Welcome next, Typical next, Install – create an account (just do it)
5.[x] Configure Server Now, next
6.Welcome next, Detailed next, Developer next, Multi Functional Database, Select path next, “Decision Support (DSS/OLAP) 20 connections Next,
7.[x] Enable TCP/IP Networking (this does create a security issue.) [x] Enable Strict Mode, Next
8.Standard Character Set Next
9.[x] Install as Windows Service, [x] Launch the MySQL server automatically Next
10.[x] modify security setttings – New root password – make something up: fudg, don't forget it. (do not enable root from other machines.) next
11.Execute – watch it do stuff, You may get a dialog saying cant connect to port – I think this is because the wizard tells the server to start, then tries to connect to it before it is done starting.
