/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 vote187 views1 answer
Login failed for user sql server
SQL
0 vote153 views1 answer
Inspecting a column unique/distinct values in SQL
SQL
0 vote180 views1 answer
How to get button for every record from mysql
SQL
0 vote228 views1 answer
Sqlite schema structure of a relational database
SQL
2 votes105 views1 answer
Sql select in list
SQL
10 votes148 views6 answers
Mysql delete duplicates
SQL
0 vote158 views1 answer
Null column as zero in mysql
SQL
0 vote163 views1 answer
How to check replication lag in mySQL
SQL
0 vote174 views1 answer
Sparql list all graphs
SQL
10 votes161 views2 answers
Sql rtrim
SQL