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


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

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b37e99-2c0ca.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b37e99-2c0ca.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?