MySQL error number 1130 (privilege granting)
Posted: Thu Jan 28, 2010 1:15 am
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:
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.
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 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.