By 20 Maggio 2016 0 Comments

Is not allowed to connect to this MySQL serverConnection closed by foreign host.

Una volta ho ricevuto questo errore in collegamento da un server WEB ad un Mysql 5.7

is not allowed to connect to this MySQL serverConnection closed by foreign host.

Per la risoluzione, ho utilizzato questi comandi, per la creazione di un utente dedicato a quel server (linux130) e l’assegnazione dei permessi:

CREATE USER ‘linux130’@’localhost’ IDENTIFIED BY ‘password’;
GRANT ALL PRIVILEGES ON *.* TO ‘linux130’@’localhost’ WITH GRANT OPTION;
CREATE USER ‘linux130’@’%’ IDENTIFIED BY ‘password’;
GRANT ALL PRIVILEGES ON *.* TO ‘linux130’@’%’ WITH GRANT OPTION;

host is not allowed to connect to this mysql server, Is not allowed to connect to this MySQL serverConnection closed by foreign host,is not allowed to connect to this MySQL server

Posted in: Mysql

About the Author:

shared on wplocker.com