/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 vote349 views1 answer
Illuminate/Database/QueryException with message 'SQLSTATE[42S02]
SQL
10 votes340 views2 answers
Select nextval from sequence oracle
SQL
0 vote339 views1 answer
Sql alter column name sql server
SQL
3 votes332 views2 answers
Sqlite print all column names
SQL
31 votes323 views4 answers
How to get duplicate records with multiple field in sql
SQL
0 vote347 views1 answer
Mysql disable triggers
SQL
0 vote332 views1 answer
Sql xampp gabungan nama awal dan akhir
SQL
2 votes352 views3 answers
Row number mysql
SQL
0 vote343 views1 answer
Shortcut run sql pgadmin
SQL
3 votes313 views2 answers
Funktion LOWER/UPPER sql
SQL