CREATE USER nombre_usuario@localhost IDENTIFIED BY tu_contrasena;
GRANT ALL PRIVILEGES ON * . * TO nombre_usuario@localhost;
FLUSH PRIVILEGES;mysql> GRANT LOCK TABLES, SELECT ON *.* TO usuariobackup@%IDENTIFIED BY MiClaveEsSuperSecreta;my.cnf
[mysqldump]
user = usuariobackup
password = MiClaveEsSuperSecreta