/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 vote243 views1 answer
How to check replication lag in mySQL
SQL
21 votes281 views3 answers
Sql server search column name in all tables
SQL
1 vote285 views2 answers
Oracle leftmost characters
SQL
0 vote312 views1 answer
Best practive to pass multiple table to stored procedure in sql server
SQL
0 vote264 views1 answer
Empty table sqlite
SQL
0 vote276 views1 answer
SQL FROM-Klausel
SQL
9 votes255 views4 answers
Add primary key to existing table sql
SQL
0 vote257 views2 answers
Php convert dbf to mysql
SQL
0 vote246 views1 answer
Create api project in visual studio 2019 and sql server
SQL
0 vote266 views1 answer
Postgresql remove new line from string
SQL