mysql –host=localhost –user=myname –password mydb

mysql -u {username} -p'{password}’ \<br /> -h {remote server ip or name} -P {port} \<br /> -D {DB name}

mysql> CREATE USER ‘monty’@’localhost’ IDENTIFIED BY ‘some_pass’;<br /> mysql> GRANT ALL PRIVILEGES ON *.* TO ‘monty’@’localhost’<br /> -> WITH GRANT OPTION;<br /> mysql> CREATE USER ‘monty’@’%’ IDENTIFIED BY ‘some_pass’;<br /> mysql> GRANT ALL PRIVILEGES ON *.* TO ‘monty’@’%’<br /> -> WITH GRANT OPTION;<br />