MySQL Bugs: #18556: installer won't put password in, help file missing

Bug #18556	installer won't put password in, help file missing
Submitted:	27 Mar 2006 21:54	Modified:	11 Feb 2008 21:02
Reporter:	Jim Michaels	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S3 (Non-critical)
Version:	5.0.22, 5.0.19	OS:	Windows (Windows)
Assigned to:	Assigned Account	CPU Architecture:	Any

Description:
1. norton security appears to be blocking mysql server's installer from working at all, somehow, even though I've turned it off, the program is just having some network connectivity problems even by itself can't connect to the service.
2. when norton was on, installer hung tryng to register me on mysql.com and wouldn't die.
3. installation doesn't include the windows CHM manual anymore like 5.0.18 did. Sorely missed.
4. after providing a root password and pressing next and execute (firewall down), installer could not apply security settings: something about  not being able to apply localhost:root@password=NO or something like that.
5. when applying security settings fails, pressing the back button, next, and execute puts a red X on "start service" and fails with "cannot create Winsows service for MySQL. Error:0" instead of noticing that the service is already up and trying to apply the security settings.
6. if you deviate from the defaults on the installer, you're in trouble.

How to repeat:
install 5.0.18 with data on it and a password successfully using pretty much defaults all the way. remove it.
install 5.0.19 community edition using defaults.

Suggested fix:
I dunno. this is pretty bad.

MySQL Service won't start. "Error 1067: The process terminated unexpectedly"

deleted innodb datafiles dir. deleted data dir, bin dir, scripts dir to make it look like a clean install. reinstalled with norton firewall disabled. still get connection error 2003 "can't connect to mysql server on 'localhost' (10061) (10061 is a winsock error - WSAECONNREFUSED).  I noticed short activity on my outgoing internet connection.  Am wondering what's going on.

nt service starts, but nothing can connect to it. mysql.exe hangs and won't die.  no events in the event log.

"add bin directory to path" didn't. in fact, it deleted my existing one.

correction. path entry is there. (sorry)   it did get moved to the end.

Thank you for a problem report. Please, specify the exact binary you had used (give the URL). I have manual.chm in my 5.0.19 installation on XP with SP2, for example.

Have you installed it as local Administrator? Please, try again, if no, and inform about the results.

http://dev.mysql.com/get/Downloads/MySQL-5.0/mysql-essential-5.0.19-win32.msi/from/http://...
from the page
http://dev.mysql.com/downloads/mysql/5.0.html

yes, as a user with administrator privs.  tried 5 times.
C:\Program Files\MySQL\MySQL Server 5.0>dir/s *.chm
 Volume in drive C has no label.
 Volume Serial Number is ACB2-51DD
File Not Found
C:\Program Files\MySQL\MySQL Server 5.0>

msi installer log file

Attachment: LOG.ZIP (application/x-zip-compressed, text), 32.58 KiB.

after uninstalling 5.0.18 and installing 5.0.19 and uninstalling, I can't install 5.0.18 back in either. error 1045 at the "start service" step with the choice to skip or retry (only skip works). any ideas what to do to fix this?

got it to install. had to delete entire old mysql server directory.  this should be in the manual.
however, the manual still doesn't come with the package.
also, server disconnects itself during execution of a 7MB SQL file full of small inserts.  and now the mysql cmd line client is disallowed access to localhost
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: Y
ES)
. so I used query browser, which gives errors during the process (has BLOBs), and it was generated from MySQL Administrator Backup, and also with this, server disconnects itself during the script.

Please, check with a newer version, 5.0.20a, not "essential" (that contains only aboslutely needed components, by definition), but complete msi package. Manual should be included in it.

Your problems with Query Browser and/or Adinsitrator is a topic for another bug reports.

installed 5.020a full version GA. still get: the security settings could not be applied because the connection has failed with the following error:error 2003 can't connect to mywsql server on localhost (10061) (which means the connection was refused). if you are reinstalling after you just uninstalled the server please note that the data directory was not removed automatically. the old password from the last install is still needed to connect to the server.

I fed in the old password and all I did was an uninstall of the old version.  I thought it's because the my.ini backup files exist in the server install directory after an uninstall.  But I was wrong.  If I obliterate the data directory, the problem goes away.  but then that removes the chances of a lesser-version upgrade (or any upgrade), doesn't it?

Are you sure you provide exactly the same root password as in the previous version? Please, doublecheck. Do you really mean that if I install 5.1.19 I will not be able to uninstall and install 5.0.20a over it without completely removing data directory?

that is correct.

Yes, I verified (with 5.0.22) that after deinstallation of 5.0.x (using Control panel...), if data directory still contains mysql subdirectory with older tables etc you really get error 1045 when trying to apply security settings (last step of installation). So, it is a bug in MySQL Server Instance Config Wizard.

But you can just click Cancel, then use old passwords to connect. This is the reason to leave old data directory: to use old data with new binaries. So, it is S3 bug.

As previously noted, the CHM is included with the full install but not the essentials package.

The remaining bug is a duplicate of Bug#24215 so this is being marked Duplicate.