/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 vote287 views1 answer
Convert .mdf to .bak
SQL
6 votes280 views2 answers
Mysql version check cmd
SQL
22 votes278 views3 answers
Sql cheat sheet
SQL
0 vote302 views1 answer
Sqlite löschen einer tabelle
SQL
0 vote280 views1 answer
Create or replace view postgress
SQL
1 vote274 views2 answers
Mysql does sentance contain word
SQL
0 vote258 views1 answer
Mysql earlier than date
SQL
0 vote284 views1 answer
Get yesterday date ISO in psql
SQL
8 votes307 views2 answers
Mysql grant all privileges to user from any host
SQL
2 votes281 views1 answer
Oracle list grants on procedure
SQL