Use the MySQL monitor to grant privileges.
Start the MySQL monitor with this command:
/usr/local/mysql/bin/mysqlYour shell prompt should now look like this:
mysql>Run this command:
GRANT ALL PRIVILEGES ON *.* TO USERNAME@IP IDENTIFIED BY "PASSWORD";USERNAME is the username that you would like to create.
IP is the public IP address of your remote connection. See examples
PASSWORD is the password you would like to use for this username. You now must flush MySQL's privileges. Run this command:
FLUSH PRIVILEGES;Run this command to exit MySQL:
exit;You can find your I.P. address by visiting these sites(opens a new window):