/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 votes354 views1 answer
How to insert string variable into sqlite database
SQL
0 vote366 views1 answer
Wp_query raw sql
SQL
-2 votes362 views2 answers
Union vs union all in sql
SQL
1 vote350 views1 answer
Xampp import sql file command line
SQL
0 vote367 views1 answer
Flexible search query delete table
SQL
1 vote363 views1 answer
Mysql check if string contains comma separated
SQL
0 vote363 views1 answer
Https://www.jitendrazaa.com/blog/sql/sqlserver/export-documents-saved-as-blob-binary-from-sql-server/
SQL
1 vote310 views1 answer
Postgres division by zero
SQL
0 vote336 views1 answer
How to check if there is no database schema
SQL
0 vote350 views2 answers
Postgres another version
SQL