Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index

Le 17/02/2013 10:16, Heinrich Stoellinger a écrit :

Hi all,

The IP-address has to be that of the SERVER, and - of course as Girvin
says -
access has to be granted to you on the server as mentioned. By the way -
I tend to use single apostrophies (') instead of ", if necessary on the
GRANT statements.
Regards and good luck

To add to what Girvin and Heinrich have written, you need to be aware that some Linux distribs forbid remote TCP access by default to a mysql server instance, because it is a potential remote attack point.

Look for the file my.cnf in /etc or /etc/mysql. In it, there should be a line that says "skip networking". Open up the file in your favorite text editor as superuser and comment out this line by putting a # as the very first character. Save and restart your mysql server instance. You should now be able to access your mysql server instance remotely via TCP.


For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.