How to fix ERROR 1106: Unknown procedure in MySQL

Run this query to check if the procedure exists:

SELECT * FROM information_schema.ROUTINES 
WHERE ROUTINE_NAME = 'your_procedure_name' 
AND ROUTINE_SCHEMA = DATABASE();

If no results are returned, the procedure does not exist in the current database. You need to create it using a CREATE PROCEDURE statement.

MySQL procedure names are case-sensitive on Linux and case-insensitive on Windows by default. Verify:

SHOW PROCEDURE STATUS WHERE Db = DATABASE();

This displays all procedures in the current database. Check that the procedure name matches exactly (including case) with what your application is trying to call.

Ensure you're connected to the correct database:

SELECT DATABASE();

If procedures are in a different database, qualify the call with the database name:

CALL `database_name`.`procedure_name`(arguments);

Verify the calling user has EXECUTE privilege on the procedure:

SHOW GRANTS FOR CURRENT_USER;

Look for EXECUTE privilege. If missing, grant it using:

GRANT EXECUTE ON `database_name`.`procedure_name` TO 'username'@'hostname';
FLUSH PRIVILEGES;

If the procedure is missing or corrupted, recreate it from your backup or source code:

DELIMITER //
CREATE PROCEDURE procedure_name (parameter_type parameter_name)
BEGIN
  -- Your procedure logic here
END//
DELIMITER ;

After creation, test with:

CALL procedure_name();

If upgrading from MySQL 5.7 to 8.0, MySQL no longer uses the mysql.proc table. The data dictionary now stores procedure information in mysql.routines and mysql.parameters (not directly queryable).

If using a connector or ORM that checks mysql.proc, update your connection string with:

CheckParameters=false

For example in JDBC:

jdbc:mysql://hostname:3306/database?CheckParameters=false