MySQL problems

[Pirate]

Oh i'm having a fun day. I'm trying to get a database to work on the work server here. It's running unix from what Im told and my problem is this.

I can create a database but I can't enter data into it from webform. I've tested the same form on the zgeek server and it works fine. From what I've read the problems are based on the permissions my account in mysql.

I checked this in phpmyadmin and I see this error. Warning: Your privilege table structure seem to be older than this MySQL version!
Please run the script mysql_fix_privilege_tables that should be included in your MySQL server distribution to solve this problem! Now the bummer is I can't run this myself as I have to get the IT guys to do this so Im trying to fix this by proxy. When they do run it they get this error.mysql> mysql_fix_privilege_tables;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql_fix_privilege_tables' at line 1.I've looked all around the net for any help on this but I can't find anything. Does anyone know anything about this or have clue where I should go to next?

[Vardsy]

I have used this reference before a few times

http://dev.mysql.com/doc/mysql/en/index.html

This page in particular may help

http://dev.mysql.com/doc/mysql/en/upgrading-grant-tables.html

[Vardsy]

Another one that may help

http://forums.mysql.com/read.php?102,20302

[Pirate]

Thanks man, that second one looks like a winner. I've sent those to the IT guy.. now I wait and twiddle my fingers.

[Vardsy]

Here is the full reference manual in PDF

http://mysql.ausgamers.com/Downloads/Manual/manual-a4.pdf