Re: Connection Problem from Localhost
GRANT ... TO root@'%' ... -- a security hole. You are letting anyone get at your database. Recommend you create a different login for your application and limit it to the database(s) it needs.
You could do root@'11.22.33.44', where that is the IP address of the client machine. This is relatively secure.
The problem you mentioned may be do to skip_name_resolve. However, using specific IP addresses avoids that problem.
Subject
Written By
Posted
Re: Connection Problem from Localhost
July 07, 2014 03:40PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.