/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

3 votes302 views1 answer
Postgres update column with value from another table
SQL
1 vote347 views2 answers
How to install mysql workbench in ubuntu 20.04
SQL
1 vote334 views1 answer
Dropping a constraint in ms sql
SQL
0 vote292 views1 answer
If null don't update
SQL
0 vote313 views3 answers
Sql drop all tables
SQL
0 vote322 views2 answers
FIND OUT THE NAME HIGHEST SALARY SQL
SQL
0 vote315 views1 answer
Write a query to peint the pattern P(20)
SQL
0 vote315 views1 answer
Mysql match in serialized data
SQL
2 votes311 views5 answers
SQL trigger
SQL
0 vote301 views1 answer
Sql offfset
SQL