/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

4 votes160 views1 answer
Is there any command to change postgres password
SQL
3 votes135 views4 answers
Order by desc postgres
SQL
0 vote137 views1 answer
Jenkins SQLCMD run
SQL
0 vote158 views1 answer
Oracle current date minus 1 day
SQL
1 vote143 views1 answer
Host 127.0 0.1 is not allowed to connect to this mysql server
SQL
0 vote147 views1 answer
Mysql c commands
SQL
1 vote150 views1 answer
Mysql query bulk insert
SQL
5 votes132 views2 answers
Postgres update with if condition query
SQL
1 vote156 views1 answer
Oracle sequence last_number
SQL
0 vote137 views1 answer
Oracle service name view
SQL