connect to remote mysql server

1mysql --host=localhost --user=myname --password mydb

1mysql> CREATE USER 'monty'@'localhost' IDENTIFIED BY 'some_pass';
2mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'
3    ->     WITH GRANT OPTION;
4mysql> CREATE USER 'monty'@'%' IDENTIFIED BY 'some_pass';
5mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%'
6    ->     WITH GRANT OPTION;
7

1GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' IDENTIFIED BY 'password';