[computergenius]

Quote:

I remember that there are two .exe distributions of mysql for windows:

a small one (“windows essentials”) and a “complete” one. Maybe it's the “windows essentials” distribution that you got ?

No, if I remember, mine was complete (allegedly!), because I needed the installer, because I am using an old version of windows.

Thanks for the file…

[computergenius]

Quote:

It's in the /scripts directory placed in the directory tree under your mysql installation directory.

/program files/mysql/mysql server 4.1/scripts with a typical mysql installation.

Not on my standard “from the .exe” installation it isn't… 🙁

Although I have read in a number of places that that is where it should be, I have also read in a number of places that other people do not have it.

Any chance of a copy by email?

[computergenius]

Quote:

It could be an issue with your mysql installation. If you upgraded your present version from an earlier version, you should remember to run the script provided by nysql to reformat the user grant tables.

I have this problem on my MySQL 4.1.10 on Windows, with SQLYog 4.02 after a MySQL upgrade – and can see that I need to run mysql_fix_privilege_tables.sql – however, I have no idea where to find this file. It doesn't seem to be available on the internet as a single .sql file, and it appears that it should have been installed in binscripts, but it wasn't – there is no bin/scripts folder. Can anyone let me have the .sql file?

[Author]

Posts