There is a problem with xampp Host is not allowed to connect to this MariaDB server

check that I found an error with http://localhost/ error:

Host is not allowed to connect to this MariaDB server

all of a sudden, I don"t know why! What is the problem with
?
I also restarted mysql with xampp, just the same!
I found a problem with remote connections

because I use server IP (linode)
to access the database, I have made the following instructions

MariaDB [mysql]> GRANT ALL PRIVILEGES ON *.* TO "root"@"xxx.xxx.xx.xx" IDENTIFIED BY "xxx" WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)

xxx.xxx.xx.xx is the IP of my server
, but I"m going to call

next.

MariaDB [mysql]> GRANT ALL PRIVILEGES ON *.* TO "root"@"%" IDENTIFIED BY "xxx" WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)

I got the data from localhost or license
Host is not allowed to connect to this MariaDB server

Xampp error error_messages mysql macos

Mar.15,2021

when you are using mysql or mariadb, you need to execute

in mysql after operating on the user rights class.

flush privileges;

flush privileges; is used to reload the permission table to make the permission operation you just did take effect

Previous: MobX combined with ES6 Class function is a business implementation problem!

Next: Why is select in (select) querying a