/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 vote237 views1 answer
Except in sql
SQL
3 votes217 views1 answer
Pl sql check if variable is empty
SQL
0 vote274 views1 answer
Install mysql on bash
SQL
1 vote247 views1 answer
Sql upsert
SQL
-1 vote197 views1 answer
How to create script to connect to oracle database and run query
SQL
2 votes251 views1 answer
Merge firstname and lastname in sql oracle
SQL
0 vote229 views1 answer
Oracle sqlp update amount / quantity
SQL
25 votes254 views6 answers
Import mysql database command line
SQL
0 vote255 views1 answer
Show tables in cassandra cql
SQL
0 vote232 views4 answers
Forenkey code alchemy sql
SQL