Once you have a command line then you need to create the user, you can also create the database whilst you are here

Create the database

create database (database name);

Now create the user

create user 'username'@'localhost' identified by 'password';

create user 'username'@'%' identified by 'password';

grant all on databasename.* to 'username'@'localhost' with grant option;

grant all on databasename.* to 'username'@'%' with grant option;

To create a mysql dump there are a few options, output to a sql file that then can be user to create the database or straight to the remote data base. Cloning to a remote database can be found in the Duplicate Sugar CRM instance

I need a Master Master replication for an application where the users are several thousand miles away from each other, looking around there seems to be a few references. I have selected the following as a starter.