/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 votes155 views1 answer
Postgresql create schema in specific database
SQL
1 vote141 views1 answer
Apex ORA-20999
SQL
0 vote171 views1 answer
Sql today at midnight
SQL
2 votes151 views2 answers
Sql strip non alphanumeric characters
SQL
0 vote158 views2 answers
How to add CHECK constraint to a column in postgres
SQL
1 vote138 views1 answer
Duplicating a MySQL table with all the data Command
SQL
0 vote153 views1 answer
Create table in dbms cmds
SQL
4 votes251 views1 answer
What are the data types
SQL
2 votes148 views1 answer
Mysql create user with mysql_native_password
SQL
0 vote332 views1 answer
Power bi connect to postgresql
SQL