Manage user MySQL 5.1 Command line

#create user
CREATE USER 'user'@'localhost' IDENTIFIED BY 'Passwordxxx**';
GRANT SELECT, LOCK TABLES, CREATE, DROP, INSERT, UPDATE, EVENT ON * . * TO 'user'@'localhost';
FLUSH PRIVILEGES;

#drop user
DROP user 'user'@'localhost';

#change password user MySql
SET PASSWORD FOR 'user'@'localhost' = PASSWORD('user@localhost234#');    #mysql under 8
ALTER USER 'user'@'localhost' IDENTIFIED BY 'user'@localhost234#';    #mysql 8

#change definer
UPDATE `mysql`.`proc` p SET definer = 'user@%' WHERE definer='user@%' AND db='dbname';

#show grant for user
SHOW GRANTS FOR 'user'@'localhost;

#dump procedure only
mysqldump --single-transaction -u username -p db > db.sql

#find definer
select v.TABLE_SCHEMA, v.TABLE_NAME, v.`DEFINER`
from information_schema.VIEWS v
where v.TABLE_SCHEMA not in ('sys');

#revoke user
REVOKE DELETE ON `dbname`.* FROM 'user'@'localhost';
FLUSH PRIVILEGES;

#grant procedure or function only
GRANT EXECUTE ON PROCEDURE `dbname`.`procName` TO 'user'@'localhost';
GRANT EXECUTE ON FUNCTION `dbname`.`funcName` TO 'user'@'localhost';
FLUSH PRIVILEGES;