/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 vote162 views1 answer
Postgres duplicate database in same server while other session is using source database
SQL
0 vote142 views1 answer
Mysql select inside sum
SQL
0 vote199 views1 answer
ORA-01400
SQL
0 vote122 views1 answer
Difference between cross apply and inner join
SQL
1 vote123 views1 answer
Can not connect to mysql server
SQL
4 votes133 views2 answers
Dbms_scheduler stop job
SQL
0 vote123 views1 answer
Get only first row mysql
SQL
1 vote137 views1 answer
Table information in sql server
SQL
0 vote142 views1 answer
Hibernate with springboot mysql
SQL
2 votes130 views1 answer
Oracle calculated column
SQL