If the phpMyAdmin login is provided with SSO, the Store Procedure is not added.
and
and error message : #1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation
If I log in with a database username and password via a phpmyadmin that I have installed on my computer, not SSO via PhpMyAdmin Directadmin, the stored procedure is added without any problems.
SQL:
CREATE TABLE messages (
id INT AUTO_INCREMENT,
message VARCHAR(100) NOT NULL,
PRIMARY KEY (id)
);and
SQL:
DELIMITER $$
CREATE DEFINER = database_username@localhost PROCEDURE InsertMessage(
msg VARCHAR(100)
)
SQL SECURITY DEFINER
BEGIN
INSERT INTO messages(message)
VALUES(msg);
END$$
DELIMITER ;and error message : #1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation
If I log in with a database username and password via a phpmyadmin that I have installed on my computer, not SSO via PhpMyAdmin Directadmin, the stored procedure is added without any problems.