I run this script:
DROP PROCEDURE IF EXISTS sp1;
|
CREATE PROCEDURE sp1()
|
GRANT ALL PRIVILEGES ON *.* TO 'foo'@'%' IDENTIFIED BY 'pass';
|
CALL sp1();
|
It seems to work fine.
However, if I call sp1() for the second time, it returns a strange warning:
CALL sp1();
|
SHOW WARNINGS;
|
+---------+------+--------------------------------------------------------------------------------------+
|
| Level | Code | Message |
|
+---------+------+--------------------------------------------------------------------------------------+
|
| Warning | 1366 | Incorrect string value: '\xA5\xA5\xA5\xA5\xA5\xA5...' for column 'Password' at row 1 |
|
+---------+------+--------------------------------------------------------------------------------------+
|