#1558 - Column count of mysql.proc is wrong. Expected 20, found 16. Created with MySQL 50156, now running 50158. Please use mysql_upgrade to fix this error.
This error is encountered by me when i try to do anything with stored procedures...
I can't do anything on stored procedures.
Even 'show procedure status' fails giving error
#1558 - Column count of mysql.proc is wrong. Expected 20, found 16. Created with MySQL 50156, now running 50158. Please use mysql_upgrade to fix this error.
Please Help
Isaac.
Script to import the procedure i used was
create procedure getlogindetails()
begin
select count(*) from user;
end
This gives me an error like
#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 ''...