I am on linux mint using xampp version 8.1.10-0, ran into a problem. I type the following MySQL code:
- Code: Select all
DELIMITER $$
CREATE PROCEDURE employee_info(IN p_em_id INT)
BEGIN
SELECT * FROM mentorships WHERE mentor_id = p_em_id;
SELECT * FROM mentorships WHERE mentee_id = p_em_id;
SELECT * FROM employees WHERE id = p_em_id;
END $$
DELIMITER ;
I get the following error message.
- Code: Select all
MariaDB [companyHR]> DELIMITER $$
MariaDB [companyHR]> CREATE PROCEDURE employee_info(IN p_em_id INT)
-> BEGIN
-> SELECT * FROM mentorships WHERE mentor_id = p_em_id;
-> SELECT * FROM mentorships WHERE mentee_id = p_em_id;
-> SELECT * FROM employees WHERE id = p_em_id;
-> END $$
ERROR 1558 (HY000): Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100108, now running 100425. Please use mysql_upgrade to fix this error
MariaDB [companyHR]>
It tells me to use my_sql upgrade to fix this problem.
But when I try to upgrade on the command line with the following:
- Code: Select all
root@Dell-Inspiron-5515:/opt/lampp/bin# /mysql_upgrade -u root -p
It throws the following error message
The mysql_upgrade client is now deprecated. The actions executed by the upgrade client are now done by the server.
To upgrade, please start the new MySQL binary with the older data directory. Repairing user tables is done automatically. Restart is not required after upgrade.
The upgrade process automatically starts on running a new MySQL binary with an older data directory. To avoid accidental upgrades, please use the --upgrade=NONE option with the MySQL binary. The option --upgrade=FORCE is also provided to run the server upgrade sequence on demand.
It may be possible that the server upgrade fails due to a number of reasons. In that case, the upgrade sequence will run again during the next MySQL server start. If the server upgrade fails repeatedly, the server can be started with the --upgrade=MINIMAL option to start the server without executing the upgrade sequence, thus allowing users to manually rectify the problem.
Very confused with all of this. First it tells to upgrade using mysql_upgrade. When I try that, it says that mysql_upgrade is deprecated.
and by the way, how am I supposed to upgrade MySQL? I am running xampp.
Will I have to uninstall xampp, download the latest file and then install it? Will it solve the problem? Is there a way to upgrade without uninstall?
Any help will be deeply appreciated. thanks.
