maronl

Open a terminal window and enter the ps -e | grep [s]sh-agent command to see if the agent is running:

myhost:~ manthony$ ps -e  | grep [s]sh-agent
 9060 ??         0:00.28 /usr/bin/ssh-agent -l
If the agent isn't running, start it manually with the following command:

myhost:~ manthony$ ssh-agent /bin/bash
Load your new identity into the ssh-agent management program using the ssh-add command.

maronl

create DATABASE DB_XXXXXXX CHARACTER SET = utf8;
create user 'USER_XXX'@'localhost' identified by 'PWD_XXX';
grant all on DB_XXXXXXX.* to 'USER_XXX'@'localhost';

mysqldump -u root -p --single-transaction dbname | gzip > filename.sql.gz

grant all on dbname.* to 'username'@'%' identified by 'xxxxxx' with grant option;

UPDATE `mysql`.`proc` p SET definer = 'root@%’ WHERE definer=’xxxxxx@%’ AND db='dbname';