mysql_fix_privilege_tables

Hi all,

I am trying to get started, but get the following error message in my
phpMyAdmin:

Warning: Your privilege table structure seems 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!
I have searched the folders in MySql and can't find this script, anyone
know where it should be?

MySql version - 4.0.4-beta-max-nt. Also how do you find the path to the
socket? I need this to complete the configuration of phpMyAdmin.

Final question is there anyway I can:

a. check how much ram MySql is using, and
b. set a limit for this, I think its using about 650meg, because its
going somewhere, and I've only lost it since MySql was installed.

Kind Regards

D.G


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: mysql_fix_privilege_tables

The script should be at MySQL/scripts folder, if you don't have it,
either your dist (4.0) doesn't come with it (I guess that's because
4.1 added the script) or your installation is incomplete (my bet is in
the first one).

I don't know what version of Windows you're using, but at NT and XP,
you can get the ammount of memory in use checking the task list
(CTRL+ALT+DEL) process tab. You should check the Manual for variables
at the config file (there are some for memory management), but I
trully doubt its using that much (mine is memory resident "no swap"
and its using about 30MB).

Sorry, but I never worked with sockets, but I'm sure someone at the
list will help you with that.

Hope that helps,

----
Daniel da Veiga
Computer Operator - RS - Brazil

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org