proper way to run mysql_fix_privilege_tables.sql

[DamnSkippy]

What is the proper way to run this command? Give an exact example please.

I am having problems getting this to run for some reason. It throws a bunch of errors depending on which one I run. phpMyadmin still tels me I need to run it. I read to run it then restart mysql then run it again, makes no difference.

I have these:
/usr/share/man/man1/mysql_fix_privilege_tables.1.gz
/usr/share/mysql/mysql_fix_privilege_tables.sql
/usr/bin/mysql_fix_privilege_tables
/usr/local/directadmin/scripts/mysql_fix_privilege_tables

some give a ton of errors like this:
ERROR 1046 (3D000): No database selected
Query OK, 0 rows affected (0.00 sec)

some give this:
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 '--bindir=*) bindir=`echo "$arg" | sed -e "s;--bindir=;;"`
prin' at line 1
ERROR:
No query specified

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 '*)
if test -n "$pick_args"
then


' at line 1
ERROR:
No query specified

 

[DamnSkippy]

Well it seems I was going about it wrong I saw the .sql on the end and ran it using mysql not the shell.