I have a hard time remembering this stuff, I'm spoiled by GUI tools. For anyone who needs it I posted some mysql cli stuff here. Nothing new or earth shattering, just notes for the lazy.

-------------------------------------------------------------------------------------

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

GRANT SELECT ON database.* TO 'user'@'%' IDENTIFIED BY 'password'

SET PASSWORD FOR 'username'@'%' = OLD_PASSWORD('password');

mysqldump -u USER -pPASSWORD DATABASE > filename.sql

mysqldump --user="user" --password="pass" --opt --compact --quick --verbose --host="server.fqdn" --databases MyFavDB --result-file=/root/outfile.sql

mysqldump --opt --extended-insert --single-transaction --create-options --default-character-set=utf8 --user="root" --password="*****" --host="server.fqdn" --databases dbname > "/data/backup.sql"

mysql dbname < filename.sql