/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

18 votes194 views4 answers
Foreign key mySql
SQL
0 vote230 views1 answer
Sql order by number not ordered
SQL
1 vote191 views1 answer
Database Queries
SQL
0 vote207 views1 answer
To_date sql
SQL
0 vote266 views1 answer
Sql pivot table
SQL
0 vote278 views1 answer
What does the -p flag do in mysql cli
SQL
0 vote188 views1 answer
Mysql money value
SQL
0 vote275 views1 answer
Sql get table last modified time
SQL
0 vote247 views1 answer
Trigger stock phpmyadmin
SQL
2 votes198 views1 answer
SQLSTATE[HY000] [1049] Unknown database
SQL