/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 vote121 views1 answer
Install squirrel sql ubuntu
SQL
11 votes120 views3 answers
Change column name sql server management studio
SQL
1 vote117 views1 answer
Round function in sql oracle
SQL
0 vote130 views3 answers
Joins and views sql
SQL
2 votes124 views3 answers
Mysql pass command from command line
SQL
6 votes128 views4 answers
Mysql group by month
SQL
0 vote78 views2 answers
Avg() sql
SQL
3 votes121 views2 answers
Host is not allowed to connect to this mysql server
SQL
0 vote155 views2 answers
SQLSTATE[HY000]: General error: 3780 Referencing column 'role_id' and referenced column 'id' in foreign key constraint 'user_role_id foreign' are incompatible.
SQL
0 vote121 views1 answer
Sqlite3 update select
SQL