/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

2 votes374 views4 answers
Mysql get all tables row count
SQL
4 votes365 views3 answers
How to describe a table in sqlite3
SQL
0 vote406 views1 answer
Sqlcl format
SQL
3 votes348 views1 answer
Mysql replace string in table
SQL
0 vote366 views2 answers
Tsql row number
SQL
0 vote369 views1 answer
Multiple left join mysql
SQL
0 vote382 views1 answer
Oracle locked objects
SQL
0 vote353 views1 answer
Sql track modification
SQL
4 votes362 views2 answers
Linq join
SQL
0 vote344 views1 answer
Original Query
SQL