MySQL - Clarifying about Remote Access Security <p>I have installed a mysql instance on a linux machine. I am concerned over potential security issues. Some tables should not be changed by users and some tables should. At present, the following comes up when I write:</p> <pre><code>SELECT host FROM mysql.user WHERE User = 'root'; +--------------------+ | host | +--------------------+ | % | | 127.0.0.1 | | ::1 | | localhost | | 'myname' | +--------------------+ </code></pre> <p>Is the presence of the '%' something to be concerned about? How would I go about setting up the DB so that the data integrity is not compromised? </p>