/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 vote261 views1 answer
Go install mysql
SQL
0 vote270 views1 answer
Duplicate value unique constraint mysql error
SQL
0 vote287 views1 answer
Java mysql swing example
SQL
0 vote287 views2 answers
How covert into int in maria db
SQL
0 vote285 views1 answer
List all permissions on a table in postgres
SQL
0 vote254 views1 answer
Sql from null to not null
SQL
0 vote245 views1 answer
Grant owner postgresql
SQL
0 vote250 views1 answer
Mysql earlier than date
SQL
0 vote261 views1 answer
ORACLE SUBSTRING SYNTAX
SQL
0 vote315 views1 answer
Alling a function from PL/SQL in a select statement in ORACLE
SQL