Skip to content

Instantly share code, notes, and snippets.

View maronl's full-sized avatar

Luca Maroni maronl

View GitHub Profile
@maronl
maronl / gist:55ea308073371dfba3e6
Last active March 1, 2016 09:15
create mysql database for testing
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';
@maronl
maronl / gist:17f92e3a3d39460419d3
Created July 1, 2015 12:44
Load your new identity into the ssh-agent management program using the ssh-add command
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.