You have syntax error...
;
is a command separator in MySQL (and other SQLs too)...
When you put an
;
at the end of the line you actually separates two independent commands...
create procedure rht_users_insert
(
IN p_user_id int,
IN p_client_id int,
IN p_first_name varchar(50),
IN p_last_name varchar(50),
IN p_login_id varchar(60),
IN p_password varchar(200),
IN p_status varchar(10)
);
BEGIN