/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 vote432 views1 answer
Create view in sql server that contain multiple select statements
SQL
0 vote351 views1 answer
Top frequency in sql server
SQL
0 vote336 views3 answers
Joins and views sql
SQL
0 vote359 views1 answer
Top 3 salary in sql
SQL
0 vote343 views1 answer
Sql stored procedure update if parameter is not null
SQL
0 vote322 views1 answer
1 column values in to 1 single row in sql
SQL
0 vote382 views1 answer
Update mysql from paypal shopping cart and ipn
SQL
0 vote340 views1 answer
Mysql not defined
SQL
0 vote303 views1 answer
Connection error in mysql workbench
SQL
3 votes316 views1 answer
Index using in query plsql
SQL