/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

3 votes107 views1 answer
Mysql insert on dupèlicate
SQL
14 votes121 views1 answer
Sql value of string
SQL
1 vote120 views1 answer
Are NULL values in a database the same as that of blank space or zero?
SQL
1 vote121 views1 answer
How to copy data of a table from another database to table of anaother database
SQL
3 votes110 views3 answers
Mysqldump: couldn
SQL
0 vote142 views2 answers
Check if sql temp table exists
SQL
0 vote107 views1 answer
Http://challenge01.root-me.org:58036/wsasd
SQL
23 votes122 views3 answers
Sql where contains part of string
SQL
1 vote118 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
0 vote124 views1 answer
Check database restore status sql script
SQL