Bug #5680 no connection granted to new installations
Submitted: 21 Sep 2004 6:58 Modified: 13 Oct 2004 17:59
Reporter: Timor Hatamy Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Installing Severity:S1 (Critical)
Version:4.0.21 OS:Windows (windows)
Assigned to: Matthew Lord CPU Architecture:Any

[21 Sep 2004 6:58] Timor Hatamy
Description:
Installing mysql versions from 3.24.xx databases till now cannot be reached on windows systems.
There is no default user privileges table installed with them, so mysql stays locked without enabling the user to add or alter users or user privileges or reach any table.
There are scripts in the script directory to create them but as you surly know they cannot be run in windows environment.
This is like trying to get into a secured locked house but the key is also inside ;))

How to repeat:
Delete the previous mysql directory and reinstall mysql new.
hmmm... afterwards... wish you lots of fun ....

Suggested fix:
You have to supply a default user privileges table which pre-installed with the installation to access and administrate mysql.

I have an idea to solve this for me, since till you will fix this it will take long.

a) installing an older version and creating the access table and users (I hope it will be compatible with the last version) 
b) installing the new version without deleting the old access tables

I hope it will work :(
[13 Oct 2004 17:59] Matthew Lord
Hi,

Thank you for your bug report!  I do agree that this is not a smooth an easy process on windows.
It is described in the manual here: http://dev.mysql.com/doc/mysql/en/Windows_upgrading.html

Starting with 4.1 which should be ga (4.1.6) this month, there is a mysql_fix_privilege_tables.sql 
file that you can execute to accomplish the task.

We appreciate your feedback and are addressing the problem.

Thank you for using MySQL!