[Koha] MySQL server

Bernardo Gonzalez Kriegel gonzalez at famaf.unc.edu.ar
Wed Mar 10 07:09:05 NZDT 2010


Andrew,
if your question is how to allow remote access to koha database, put

bind-address = 0.0.0.0

on /etc/mysql/my.cnf, then restart mysql.

AND

mysql> grant "SELECT/ALL" on koha.* to 'koharemoteuser'@'192.168.1.XXX'
identified by 'XYXYXY';
mysql> flush privileges;

where you must specify the exact privileges you need to grant, the
ip_address of the remote machine, and the username/password.

Regards

bgk


2010/3/9 Andrew Buxton <A.Buxton at ids.ac.uk>

>  When you do an installation of Koha (on Debian Linux) what port is mySQL
> on?  Do you need to change anything to access it from another machine?  (I’m
> sure I managed to access it before …)
>
>
>
> Thanks,
>
> Andrew
>
> ---
> Andrew Buxton,  Library Web and Information Systems Manager
> Direct line: 01273 915795   -  International +44 1273 915795
> IDS website: http://www.ids.ac.uk/ Library website: http://blds.ids.ac.uk/
>
>
>
> This message is for the addressee only and may contain privileged or
> confidential information. If you have received it in error, please notify
> the sender immediately and delete the original. Any views or opinions
> expressed are solely those of the author and do not necessarily represent
> those of IDS. Institute of Development Studies at the University of Sussex,
> Brighton BN1 9RE Tel: +44 (0)1273 606261; Fax: +44 (0)1273 621202 IDS, a
> charitable company limited by guarantee: Registered Charity No. 306371;
> Registered in England 877338; VAT No. GB 350 899914
>
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20100309/032095b6/attachment.htm 


More information about the Koha mailing list