/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

39 votes425 views4 answers
Select duplicates in sql
SQL
5 votes356 views1 answer
Oracle sysdate - 1 month
SQL
0 vote335 views1 answer
Oracle last character of string
SQL
2 votes346 views1 answer
Oracle list grants on package
SQL
0 vote376 views1 answer
Create synonym for dblink in oracle
SQL
7 votes357 views2 answers
Oracle sql drop index
SQL
1 vote353 views1 answer
Mysql data from file
SQL
0 vote398 views1 answer
Sql server synonym
SQL
0 vote369 views3 answers
Mysql regex replace
SQL
2 votes369 views1 answer
Q operator in sql
SQL