/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 vote258 views1 answer
Mysql read row
SQL
1 vote212 views1 answer
Insert and initialize a SQL column with value dependent on another column data
SQL
0 vote251 views1 answer
Sql select by content lenght
SQL
14 votes270 views4 answers
Remove record from table sql
SQL
1 vote288 views1 answer
Mysql find most common value
SQL
1 vote243 views2 answers
How to check username in mysql command line
SQL
2 votes247 views4 answers
How to find 2nd highest salary in mysql
SQL
0 vote271 views1 answer
How to check database engine in mysql
SQL
3 votes252 views2 answers
Oracle synonym
SQL
4 votes289 views4 answers
Remove duplicate old value in mysql
SQL