/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

8 votes350 views2 answers
Between operator
SQL
0 vote319 views1 answer
Sp in sql server
SQL
5 votes331 views1 answer
Oracle list days between two dates
SQL
5 votes354 views2 answers
Mysql dump mysql db cli
SQL
0 vote333 views1 answer
How to remove quotes from a string in ssis load file
SQL
1 vote323 views1 answer
Continue in sql
SQL
0 vote349 views1 answer
Create user faunadb
SQL
3 votes301 views1 answer
Oracle limit user tablespace
SQL
0 vote354 views1 answer
Space not removing from column in sql
SQL
2 votes347 views2 answers
Sqlalchemy return id after insert
SQL