/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 vote176 views1 answer
Selecting from a view SQL
SQL
3 votes175 views4 answers
Order by desc postgres
SQL
0 vote168 views1 answer
Where in clause tsql
SQL
0 vote136 views2 answers
Postgresql could not start server mac
SQL
10 votes224 views4 answers
Join multiple tables in sql
SQL
0 vote189 views1 answer
Python mysql check if database exists
SQL
0 vote170 views2 answers
Get top 1 row of each group
SQL
0 vote177 views1 answer
Mssql disable foreign key constraint
SQL
0 vote163 views1 answer
Wordpress sql change site url
SQL
0 vote181 views2 answers
Python mysql create table if not exists
SQL