hi im trying to connect to my databases on uniserver using navicat however i am getting the following error when i do this, how can i fix it? thanks

 

1146 - Table 'mysql.proc' doesnt exist

I think you have one of two problems!

 

1) If you are running a version of MySQL below version 5 you need to upgrade to 5.

 

2) OK so you are running UniServer 3.3 and MySQL is version 5.0.17

I ran a quick test and can confirm the mysql.proc error.

I think you need to run mysql_fix_privilege_tables.sql script to fix the problem.

 

Almost sure you need the correct version of the script to match 5.0.17

 

The script is not included with UniServer 3.3 and I could not find one on the net.

 

I pass this one over to Olajide I could be totally wrong.

Well Ric you are right. But i think the version can be found on MySQL's website. Check their download achieve.

so what is the easiest way to solve this, run the fix or update? thanks

Run the fix.

could you give me some instructions on how to run this fix? thanks

Its a sql file, run it using phpMyAdmin.

Its a sql file, run it using phpMyAdmin.

 

i tried using the sql in phpmyadmin but gave me error:

 

SQL query:

 

mysql_fix_privilege_tables.sql

 

MySQL said: Documentation

#1064 - 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

 

what did i do wrong?

Get 3.4