/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 vote212 views1 answer
Create database like
SQL
2 votes212 views1 answer
When matched in sql server
SQL
0 vote234 views1 answer
Finding leap year in sql
SQL
3 votes223 views5 answers
No module named 'MySQLdb'
SQL
1 vote203 views1 answer
Mysql query where in select
SQL
4 votes199 views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL
3 votes207 views2 answers
Laravel tosql with bindings
SQL
0 vote205 views1 answer
Sql database connectivity
SQL
1 vote211 views3 answers
Getdate function in postgresql
SQL
46 votes217 views4 answers
Create column sql
SQL