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

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

36 votes267 views6 answers
Change column data type sql
SQL
13 votes148 views1 answer
Views in sql
SQL
18 votes138 views3 answers
Mysql add column with default value
SQL
2 votes185 views2 answers
Mysql search for column name in all tables
SQL
0 vote157 views1 answer
How to add unique key constraint in mysql
SQL
0 vote143 views1 answer
How to convert DateTime to VarChar SQL
SQL
0 vote169 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
0 vote138 views1 answer
Initcap in sql
SQL
13 votes160 views4 answers
Mysql access denied for user 'root'@'localhost'
SQL
1 vote193 views1 answer
Sql oracle update multiple rows
SQL