/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 vote215 views1 answer
Oracle case
SQL
1 vote236 views1 answer
Round one decimal place mysql
SQL
0 vote273 views1 answer
Dialect undefined does not support db:create / db:drop commands
SQL
0 vote211 views1 answer
Plpgsql if statement
SQL
16 votes220 views4 answers
Mysql import from sql file
SQL
6 votes234 views1 answer
Oracle pl sql source
SQL
0 vote236 views1 answer
SQL Server dynamic pivot unknown number of columns
SQL
0 vote220 views1 answer
Oracle array
SQL
6 votes233 views3 answers
Update with inner join postgres
SQL
0 vote218 views1 answer
Postgres week number
SQL