/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

0 vote287 views1 answer
Update using case in mysql
SQL
0 vote311 views2 answers
Postgresql variable in query
SQL
0 vote280 views1 answer
Postgres: Create Column add constraint to the column with Query Output
SQL
4 votes337 views1 answer
Mysql store ip address
SQL
0 vote300 views1 answer
Sql count null values in all columns
SQL
0 vote301 views1 answer
Oracle archivelog usage
SQL
5 votes280 views1 answer
Oracle get nls settings
SQL
0 vote277 views1 answer
Go install mysql
SQL
7 votes294 views2 answers
Mysql db size
SQL
0 vote289 views1 answer
Sql get guid
SQL