/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

9 votes173 views1 answer
No sql
SQL
1 vote153 views2 answers
Mysql SELECT
SQL
2 votes161 views1 answer
Check isolation level in mysql
SQL
0 vote175 views1 answer
Sql server udf performance
SQL
0 vote156 views1 answer
INSERT INTO table using OpenQuery
SQL
0 vote165 views1 answer
Sql create table with datetime automatically
SQL
10 votes165 views2 answers
Forgot my mysql password mac
SQL
3 votes173 views2 answers
Sql paging query
SQL
7 votes195 views2 answers
Phpmyadmin change password
SQL
11 votes179 views4 answers
Update row in mysql
SQL