PHPMyAdmin MySQL stored procedure not working - no response or errors

Other Questions MySQL
1

I’m having trouble with a MySQL stored procedure in PHPMyAdmin. I wrote this simple test procedure but it’s not working properly:

DELIMITER $$
CREATE PROCEDURE `test_counter` (IN num_start INT)
BEGIN
    WHILE num_start < 10 DO
        SELECT num_start;
        SET num_start = num_start + 1;
    END WHILE;
END $$
DELIMITER ;

When I try to execute this code in PHPMyAdmin, absolutely nothing happens. There are no error messages and no success notifications either. It just sits there like I never ran anything. Then when I attempt to call the procedure using CALL test_counter(3), I get an error saying the procedure doesn’t exist at all. I’m really confused about what could be going wrong here. Has anyone else run into this issue with stored procedures in PHPMyAdmin? Am I missing something obvious in my syntax or approach?

2

yeah, sounds like a delimiter issue to me. u should set it up properly - change the delimiter first, create the proc, then switch it back. also dbl check if ur on the right db and got the proper perms to create those procs.