Context: I am learning Stored Procedures with the help of PHPmyAdmin as a school project. Since yesterday I have been fighting the annoying error #1558.
The exact error is as follows:
Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100145, now running 100415. Please use mysql_upgrade to fix this error
This error pops up whenever I tried to set a stored procedure via the ‘Routine’ function or write a procedure query directly on the SQL field via the ‘SQL’ function. The query I tried to enter was just error-free as all my other teammates have no problem generating the result we wanted. They have had no 1558 error either. FYI I am the lone Mac user and all the others are Windows users. According to this website, the error seems to be a unique one to the MacOs. What do you all think about that?
In the meantime, I have been searching StackOverFlow and other sites and trying out commands but it led me to another problem: every time I enter all those commands into my Mac Terminal it gives me
no such directory exists or ‘command not found’ like the one pictured below:
I am pretty sure I am missing a basic in resolving the command errors. I appreciate any inputs or advice.