/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

1 vote124 views2 answers
Update with inner join sql server
SQL
0 vote134 views1 answer
Tsql table column constraint must be uppercase
SQL
0 vote137 views1 answer
How to populate a table in MySQL from and existing csv file
SQL
0 vote131 views1 answer
How to delete python anywhere mysql database
SQL
0 vote132 views1 answer
Raiserror with nowait
SQL
-1 vote130 views1 answer
Sql set max value in column
SQL
0 vote130 views1 answer
Sqlites studio red exclamation mark when poening databse
SQL
2 votes141 views2 answers
Convert_tz mysql
SQL
0 vote124 views1 answer
Addition of 2 column value in mysql
SQL
0 vote116 views1 answer
Find largest table in mysql database
SQL