PDA

View Full Version : need some help with MySQL stuff



Omega
02-10-2009, 12:47 PM
I figured "hey, TBCS is full of geeks, so I'll ask here". And it's in the chatterbox because more people will see it this way.

Right, so, I'm fiddling around with a MySQL installation through a phpMyAdmin interface on Yahoo small business hosting, and it keeps asking me to run the script "mysql_fix_privilege_tables" so I can get the privilege table version to match the MySQL version number.

It says the script should be included in the MySQL server distribution, but I just got onto this case and I can't find ****.

Help me out, please?

SgtM
02-10-2009, 01:34 PM
A quick google search turned up this:
http://dev.mysql.com/doc/refman/5.0/en/mysql-fix-privilege-tables.html

I don't know if you have shell access to the server, but you'll need it.

Omega
02-10-2009, 08:24 PM
where can I download a MySQL server distribution, version 4.1.14? if I can get to the .sql file for mysql_fix_privilege_tables in there, copy the text and run it as a query in phpMyAdmin, it should run it and fix my issue, right?

SgtM
02-10-2009, 09:26 PM
http://www.mysql.com/