/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
Oracle last character of string
SQL
0 vote142 views1 answer
Systemverilog unique constraint unique values
SQL
1 vote138 views1 answer
Oracle stop job
SQL
0 vote143 views1 answer
Primary key multiple colums
SQL
0 vote146 views1 answer
Sql remove last 2 digit
SQL
0 vote175 views1 answer
Mysql 3 months ago
SQL
3 votes144 views3 answers
How to add month in update sql
SQL
2 votes134 views1 answer
Plsql block
SQL
1 vote160 views1 answer
Check current sequence value postgres
SQL
3 votes183 views2 answers
Oracle drop column
SQL