/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

13 votes102 views2 answers
Mysql order by multiple columns
SQL
2 votes101 views1 answer
Get first 3 letters name in sql
SQL
2 votes103 views1 answer
Check isolation level in mysql
SQL
0 vote98 views1 answer
Postgresql remove new line from string
SQL
0 vote123 views1 answer
Postgres reorder columns
SQL
5 votes113 views1 answer
Sql table columns
SQL
0 vote108 views1 answer
Time in sql server
SQL
1 vote110 views1 answer
How to copy data of a table from another database to table of anaother database
SQL
0 vote256 views1 answer
Hue hive UploadingTextFiletoHive
SQL
2 votes108 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly. 11:04:35 PM [mysql] This may be due to a blocked port, missing dependencies,
SQL