jpgalea Posted May 11, 2007 Report Share Posted May 11, 2007 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 Quote Link to comment Share on other sites More sharing options...
Ric Posted May 11, 2007 Report Share Posted May 11, 2007 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.17I 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. Quote Link to comment Share on other sites More sharing options...
olajideolaolorun Posted May 11, 2007 Report Share Posted May 11, 2007 Well Ric you are right. But i think the version can be found on MySQL's website. Check their download achieve. Quote Best Regards Olajide Olaolorun The Uniform Server Development Team Link to comment Share on other sites More sharing options...
jpgalea Posted May 11, 2007 Author Report Share Posted May 11, 2007 so what is the easiest way to solve this, run the fix or update? thanks Quote Link to comment Share on other sites More sharing options...
olajideolaolorun Posted May 11, 2007 Report Share Posted May 11, 2007 Run the fix. Quote Best Regards Olajide Olaolorun The Uniform Server Development Team Link to comment Share on other sites More sharing options...
jpgalea Posted May 12, 2007 Author Report Share Posted May 12, 2007 could you give me some instructions on how to run this fix? thanks Quote Link to comment Share on other sites More sharing options...
olajideolaolorun Posted May 12, 2007 Report Share Posted May 12, 2007 Its a sql file, run it using phpMyAdmin. Quote Best Regards Olajide Olaolorun The Uniform Server Development Team Link to comment Share on other sites More sharing options...
jpgalea Posted June 2, 2007 Author Report Share Posted June 2, 2007 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? Quote Link to comment Share on other sites More sharing options...
olajideolaolorun Posted June 2, 2007 Report Share Posted June 2, 2007 Get 3.4 Quote Best Regards Olajide Olaolorun The Uniform Server Development Team Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.