/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 vote238 views1 answer
Oracle show running job
SQL
0 vote246 views3 answers
Select random sql
SQL
5 votes253 views2 answers
Oracle find all tables with column name
SQL
0 vote237 views1 answer
Product of a column in mysql
SQL
2 votes299 views3 answers
Mysql unix timestamp to date
SQL
10 votes256 views2 answers
Tsql merge example
SQL
1 vote234 views1 answer
Postgres start database on linux
SQL
1 vote224 views1 answer
Create temporal table in sql
SQL
0 vote235 views1 answer
How to connect sqlalchemy to mysql and deploy it
SQL
0 vote227 views1 answer
Mariadb LOAD DATA INFILE
SQL