/SQL/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

5 votes228 views2 answers
Oracle tables with column name
SQL
0 vote185 views1 answer
How to get last client id sql
SQL
-1 vote225 views1 answer
How to open blade file from blade in laravel
SQL
0 vote236 views2 answers
How to login to mysql as normal user in ubuntu
SQL
0 vote239 views1 answer
Monthly Birthday SQL Query
SQL
0 vote240 views1 answer
Geopoint from json mysql function
SQL
5 votes248 views1 answer
Oracle sysdate - 1 month
SQL
2 votes253 views3 answers
Install mysql workbench ubuntu 20.04 terminal
SQL
1 vote226 views2 answers
End mysql command
SQL
0 vote257 views1 answer
Get the next column of a table in mysql
SQL