/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 vote250 views1 answer
Postgres delete where id in
SQL
0 vote302 views1 answer
Sql delimiter to columns
SQL
0 vote265 views1 answer
Mysql earlier than date
SQL
0 vote284 views1 answer
No suitable driver found for sqlite
SQL
0 vote337 views1 answer
Oracle chain step succeeded
SQL
1 vote306 views1 answer
Expression number 1 of select list is not in group by clause
SQL
3 votes300 views2 answers
Get current year sql
SQL
0 vote314 views2 answers
How to retrive image from sql to picturebox usinf image location
SQL
18 votes272 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
SQL
1 vote298 views1 answer
Postgresql datetrunc too slow
SQL