/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 vote133 views1 answer
Create-table-with-index-organization
SQL
0 vote130 views1 answer
Get record which is available in one table but not in another mysql
SQL
1 vote127 views1 answer
ORA-01950
SQL
2 votes152 views3 answers
Sql server: how to concatenate column data using comma
SQL
0 vote131 views1 answer
Basic structure of sql expression having clause
SQL
5 votes113 views2 answers
Oracle list columns schema
SQL
1 vote121 views2 answers
How to check username in mysql command line
SQL
2 votes156 views3 answers
Application.properties spring boot mysql
SQL
0 vote141 views1 answer
How to access to mysql without root
SQL
0 vote167 views1 answer
Call function sql oracle with output put line
SQL