/SQL/SqlMessage: "Host '192.168.64.1' is not allowed to connect to this MariaDB server

SqlMessage: "Host '192.168.64.1' is not allowed to connect to this MariaDB 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

SqlMessage: "Host '192.168.64.1' is not allowed to connect to this MariaDB server

CREATE USER 'username'@'%' IDENTIFIED BY 'password';

GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' WITH GRANT OPTION;

FLUSH PRIVILEGES;

EXIT;

Similar codes

0 vote341 views1 answer
Redshift running queries
SQL
0 vote278 views1 answer
Version_info, _mysql.version_info, _mysql.__file__ NameError: name '_mysql' is not defined
SQL
0 vote271 views1 answer
Create mysql pool connection python flask
SQL
1 vote281 views1 answer
Mysql strict_trans_tables
SQL
0 vote275 views1 answer
Case insensitive sql
SQL
0 vote304 views1 answer
Insert into table with only identity column
SQL
2 votes288 views2 answers
Postgres trigger insert into another table
SQL
0 vote255 views1 answer
Backup a table in sql
SQL
0 vote304 views1 answer
Primary key start from number
SQL
0 vote271 views1 answer
Dump multiple tables mysql
SQL