MySQL 5.0. 17 is now available from FTP-mirrors. Note this from the changelogs:
QUOTE
* The syntax for CREATE TRIGGER now includes a DEFINER clause for specifying which access privileges to check at trigger invocation time. See Section 18.1, “CREATE TRIGGER Syntax†for more information.
*Added a DEFINER column to the INFORMATION_SCHEMA.TRIGGERS table.
That means that you should remember to run the mysql_fix_privilege_tables.sql -script (as explained here: http://dev.mysql.com/doc/refman/5.0/en/mys…ge-tables.html) when you update from a previous MySQL 5.0.x. I you don't you may get into problems with triggers. And maybe even more privilege related problems ….
And there even seems to be a bug with this version of the script. 'No dabase selected' it displays, when following the procedure described in the docs. So I think you should issue a 'use mysql;' before the SOURCE ….. mysql_fix_privilege_tables.sql. That worked for me here!
And a tip: I always copy the file to c:/. The MySQL command-line client does not like blanks/spaces in file name paths! Then you only need to do
CODE
SOURCE c:mysql_fix_privilege_tables.sql
The easiest way I think! Also if you use the installer-version of MySQL, the command-line client is accessible from start-menu.
