Monday, June 13, 2011

MySQL - Enable remote access

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.
        - 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;

No comments:

Post a Comment