[libreoffice-users] Re: MySQL on a network

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.


Alex










--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted