/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 vote294 views1 answer
Postgres float to int
SQL
0 vote264 views1 answer
Update sql join multiple tables
SQL
0 vote339 views1 answer
DELETE DUPLICATE VALUES FROM A TABLE IN SQL SERVER
SQL
0 vote352 views1 answer
Dataframe lambda elif
SQL
0 vote299 views1 answer
Oracle query to see what scema i am working in
SQL
0 vote301 views2 answers
Show slave status mysql
SQL
0 vote309 views1 answer
Change schema of all tables postgres
SQL
0 vote338 views1 answer
#1231 - Variable 'sql_mode' can't be set to the value of 'NULL'
SQL
3 votes505 views6 answers
Sql unique select
SQL
0 vote325 views2 answers
Search stored procedures
SQL