/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

0 vote122 views1 answer
Mql5 list all available symbols
SQL
0 vote124 views1 answer
Sql show all users
SQL
6 votes162 views1 answer
How to get the size of the database in postgresql
SQL
0 vote145 views1 answer
Recently updated stored procedure in sql server
SQL
0 vote93 views2 answers
Spring properties file for db
SQL
0 vote95 views1 answer
Mariadb list tables
SQL
0 vote180 views1 answer
Alternative for LIMIT sql
SQL
14 votes126 views3 answers
Delete all records from table except sql
SQL
4 votes155 views1 answer
Ms sql truncate table vs delete
SQL
0 vote128 views1 answer
Order by with where clause in mysql
SQL