/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 vote178 views1 answer
Oracle array
SQL
2 votes186 views1 answer
Add default sql server
SQL
3 votes165 views1 answer
Select nextval from sequence sql
SQL
27 votes190 views6 answers
Sql update record
SQL
0 vote180 views1 answer
PSQL qith variables
SQL
0 vote196 views1 answer
Get initial in sql
SQL
0 vote188 views1 answer
Oracle procedure teamplate
SQL
9 votes182 views6 answers
Replace sql
SQL
2 votes179 views1 answer
How to make insert script from table in SQL server
SQL
0 vote185 views2 answers
How to set global time_zone in mysql
SQL