/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 vote263 views1 answer
Linebreak sql
SQL
0 vote280 views1 answer
Create table split string function in sql server
SQL
0 vote258 views1 answer
Sql remove decimal places
SQL
0 vote266 views1 answer
What is the difference between the LIKE and REGEXP operators in mysql?
SQL
0 vote263 views1 answer
Ubuntu connect to mssql database
SQL
0 vote275 views1 answer
Check user sql password from command line
SQL
2 votes245 views1 answer
Import database in mysql command line xampp
SQL
0 vote253 views1 answer
Oracle sql generate list of days
SQL
1 vote257 views1 answer
Postgresql contains
SQL
0 vote295 views1 answer
VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE
SQL