[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