/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 vote214 views1 answer
How to get initials in sql
SQL
2 votes215 views1 answer
Oracle apex list connected users
SQL
2 votes231 views1 answer
Mysql create user with remote access
SQL
0 vote234 views1 answer
Oracle webcenter content search enginer
SQL
3 votes207 views1 answer
Oracle user quota unlimited
SQL
0 vote231 views1 answer
What is initial catalog in sql connection string
SQL
3 votes207 views1 answer
Oracle apex warning message
SQL
6 votes221 views2 answers
Sql query to get the number of rows in a table
SQL
1 vote219 views1 answer
How to use db.execute
SQL
0 vote202 views1 answer
How to access to mysql without root
SQL