[TEST TEMPLATE] HOST ‘XXX.XX.XXX.XXX’ IS NOT ALLOWED TO CONNECT TO THIS MYSQL SERVER

By : binhluong Date Submitted : 28 -02 - 2019
Your Rate :

How to allow connect to MySql Server from your local

Possibly a security precaution. You could try adding a new administrator account:

mysql> CREATE USER 'monty'@'localhost' IDENTIFIED BY 'some_pass';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'
    ->     WITH GRANT OPTION;
mysql> CREATE USER 'monty'@'%' IDENTIFIED BY 'some_pass';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%'
    ->     WITH GRANT OPTION;

Although as Pascal and others have noted it’s not a great idea to have a user with this kind of access open to any IP. If you need an administrative user, use root, and leave it on localhost. For any other action specify exactly the privileges you need and limit the accessibility of the user as Pascal has suggest below



   Categories :      Tags : 

Share On FaceBook

Share On Google

Share On Twitter

Leave a Reply

avatar
  Subscribe  
Notify of