/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

2 votes195 views1 answer
Oracle apex list connected users
SQL
0 vote259 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL
0 vote182 views1 answer
Save single sql query result boolean spring boot
SQL
0 vote204 views1 answer
Get date from timestamp in mysql
SQL
0 vote199 views1 answer
Soql queries for not contact related account records in salesforce
SQL
0 vote197 views1 answer
Mysql docker image arjun
SQL
0 vote198 views2 answers
Error while setting value 'ONLY_FULL_GROUP_BY,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'
SQL
0 vote221 views1 answer
Influxdb list all tags for a measurement
SQL
2 votes180 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL
1 vote194 views3 answers
Get all tables postgres
SQL