1146 - Table 'mysql.proc' doesnt exist

[jpgalea]

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

[Ric]

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.

[olajideolaolorun]

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

[jpgalea]

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

[olajideolaolorun]

Run the fix.

[jpgalea]

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

[olajideolaolorun]

Its a sql file, run it using phpMyAdmin.

[jpgalea]

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?

[olajideolaolorun]

Get 3.4