Host ‘*.*.*.*’ is not allowed to connect to this MySQL server

  1. Connect to your Linux server in Terminal and execute:
    mysql -uroot -p
  2.  Enter password and execute next queries:
    USE mysql;
    SELECT user,host FROM user;
  3. GRANT ALL PRIVILEGES ON *.* TO [email protected]_ip IDENTIFIED BY ‘root_password‘ WITH GRANT OPTION;
  4.  Now connect to your MySQL server will succeed, you can change the user to anyone or you can create a new one grant with any IP address.