/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

1 vote198 views2 answers
Sql where is not number
SQL
3 votes190 views3 answers
C# sql select
SQL
2 votes226 views1 answer
Show max_allowed_packet mysql
SQL
1 vote184 views1 answer
Sql get missing id
SQL
0 vote232 views1 answer
Mysqlimport
SQL
0 vote173 views1 answer
Sequelize postgresql schema
SQL
0 vote254 views1 answer
Compare two tables to find unmatched records
SQL
1 vote189 views1 answer
Rermove categories woocommerce sql
SQL
0 vote191 views1 answer
Sql query for select from specific columns in a table
SQL
3 votes202 views1 answer
Laravel paginate raw sql
SQL