/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

1 vote109 views1 answer
Sql restore backup query
SQL
0 vote154 views1 answer
Ms sql print more than 1 variable
SQL
0 vote110 views1 answer
"SET SQL_AUTO_IS_NULL = 0" query problem
SQL
0 vote114 views1 answer
Sql contains numeric characters
SQL
0 vote118 views1 answer
Query to get all primary keys and foreign key
SQL
0 vote119 views1 answer
Mysql select row with min date
SQL
18 votes115 views2 answers
Sql inner join
SQL
0 vote131 views1 answer
SQL Server date literal
SQL
20 votes118 views4 answers
Sqlite create table if not exists
SQL
-1 vote116 views1 answer
Partial search in sql
SQL