/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 votes343 views1 answer
Sql asynchronous stored procedure call
SQL
1 vote338 views1 answer
Get url of cpanel database hostname
SQL
1 vote353 views1 answer
How to between in sql
SQL
0 vote365 views1 answer
Sql server beginning of month
SQL
2 votes346 views1 answer
Oracle index size calculation
SQL
0 vote361 views1 answer
If column value is null then in mysql
SQL
0 vote370 views1 answer
Sql alter table add column if exists
SQL
0 vote363 views1 answer
How much space does sql server take per row
SQL
0 vote319 views1 answer
Mysql create table columns with spaces
SQL
1 vote353 views1 answer
Oracle convert run duration to number
SQL