/SQL/Host is not allowed to connect to this mysql server

Host is not allowed to connect to this mysql server

CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';

GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' WITH GRANT OPTION;

CREATE USER 'username'@'%' IDENTIFIED BY 'password';

GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' WITH GRANT OPTION;

FLUSH PRIVILEGES;

Source: stackoverflow.com

Host '' is not allowed to connect to this MySQL server

GRANT ALL PRIVILEGES ON *.* TO root@my_ip IDENTIFIED BY ‘root_password‘ WITH GRANT OPTION;

Source: confluence.atlassian.com

Similar codes

0 vote163 views1 answer
Monthly Birthday SQL Query
SQL
1 vote498 views1 answer
Mysql event last execution
SQL
0 vote173 views1 answer
Sql max min
SQL
0 vote179 views1 answer
Exectuer myssql .sql
SQL
0 vote182 views1 answer
Warning: pdostatement::execute(): sqlstate[hy093]: invalid parameter number: number of bound variables does not match number of tokens
SQL
1 vote181 views1 answer
Oracle sql pad left zeros
SQL
10 votes212 views6 answers
Mysql set root password
SQL
2 votes131 views1 answer
Latest record in sql
SQL
1 vote153 views1 answer
Delete triger pl pg sql
SQL
0 vote179 views1 answer
Alter check command
SQL