/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

8 votes217 views2 answers
Default sql server port
SQL
2 votes168 views1 answer
Q operator in plsql
SQL
1 vote177 views1 answer
Where not in array sql
SQL
1 vote188 views2 answers
Oracle leftmost characters
SQL
0 vote171 views1 answer
Bus source and destination equal to destination and source of another by sql query
SQL
17 votes176 views4 answers
Set mysql Password
SQL
-1 vote193 views1 answer
SQL SERVER microsoft How to Add Column at Specific Location in Table
SQL
5 votes174 views2 answers
Oracle find all tables with column name
SQL
0 vote193 views2 answers
Create-toys-table-with-toy_name-column
SQL
13 votes158 views2 answers
Check if value is null mysql
SQL