/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

2 votes205 views1 answer
Mysql trigger after update
SQL
0 vote243 views1 answer
Delete from table where length sql
SQL
1 vote212 views1 answer
Right outer vs left outer join
SQL
0 vote211 views1 answer
Sql query to return field name of a table
SQL
1 vote227 views1 answer
How to get the date diff on once field in sql server
SQL
1 vote203 views1 answer
Declare variables sql
SQL
4 votes195 views1 answer
Check database name postgresql
SQL
0 vote191 views2 answers
Azure sql-datenbank
SQL
1 vote190 views1 answer
Neo4j display all nodes and relationships
SQL
0 vote231 views1 answer
Oracle string length
SQL