MySQL error number 1130 (privilege granting)

[cah]

When a new MySQL is created, the connection is usually denied until the privileges are granted.

Log in as root or admin user first, then try the following command:

Code: Select all

GRANT ALL PRIVILEGES ON *.* TO '<username>'@'%' IDENTIFIED BY '<password>' WITH GRANT OPTION;

Note the hostname is '%' which gives blanket permission to allow logging in from anywhere.

NOTE 1: IDENTIFIED BY '<password> must be given then remote login is possible.
NOTE 2: IDENTIFIED BY '<password> must be given before WITH GRANT OPTION then remote login is possible.