To deploy the procedure via terminal in mysql you need to change the delimiter! So this is a sample step that you could follow to do it!
DELIMITER //
CREATE PROCEDURE ChangeInventory(in InventoryID INT, in Quantity INT)
BEGIN
UPDATE INVENTORY SET IN_QTY = Quantity WHERE IN_P_ID = InventoryID;
END //
DELIMITER ;
