/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

3 votes136 views2 answers
Postgres show table schema
SQL
0 vote124 views2 answers
Django.db.utils.OperationalError: (1698, "Access denied for user 'root'@'localhost'")
SQL
0 vote145 views1 answer
Time mysql w3
SQL
0 vote128 views1 answer
T-SQL Never ending DELETE
SQL
0 vote77 views1 answer
FindAllBy
SQL
10 votes136 views4 answers
SELECT FROM WHERE
SQL
0 vote170 views1 answer
Stop and start mysql
SQL
0 vote125 views1 answer
How to connect postgresql database with java
SQL
18 votes156 views3 answers
Get the list of all tables in sql server
SQL
1 vote152 views2 answers
Create a unqie constraint mysql
SQL