Andrew,<br>
if your question is how to allow remote access to koha database, put<br>
<br>
bind-address = 0.0.0.0<br>
<br>
on /etc/mysql/my.cnf, then restart mysql.<br>
<br>
AND<br>
<br>
mysql> grant "SELECT/ALL" on koha.* to 'koharemoteuser'@'192.168.1.XXX' identified by 'XYXYXY';<br>
mysql> flush privileges;<br>
<br>
where you must specify the exact privileges you need to grant, the ip_address of the remote machine, and the username/password.<br><br>
Regards<br>
<br>
bgk<br>
<br><br><div class="gmail_quote">2010/3/9 Andrew Buxton <span dir="ltr"><<a href="mailto:A.Buxton@ids.ac.uk">A.Buxton@ids.ac.uk</a>></span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div link="blue" vlink="purple" lang="EN-GB">
<div>
<p class="MsoNormal"><span style="color: black;">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 …)</span></p>
<p class="MsoNormal"><span style="color: black;"> </span></p>
<p class="MsoNormal"><span style="color: black;">Thanks,</span></p>
<p class="MsoNormal"><span style="color: black;">Andrew</span></p>
<p class="MsoNormal"><span style="font-size: 7.5pt; color: purple;" lang="EN-US">---</span><span style="font-size: 12pt; font-family: "Times New Roman","serif"; color: black;"> <br>
</span><span style="font-size: 10pt; color: purple;" lang="EN-US">Andrew Buxton, Library Web and Information Systems Manager</span><span style="font-size: 12pt; font-family: "Times New Roman","serif"; color: black;"> <br>
</span><span style="font-size: 8pt; color: purple;" lang="EN-US">Direct line: 01273 915795 - International +44
1273 915795</span><span style="font-size: 8pt; font-family: "Times New Roman","serif"; color: black;"> <br>
</span><span style="font-size: 8pt; color: purple;" lang="EN-US">IDS website: <a href="http://www.ids.ac.uk/" target="_blank"><span style="color: blue;">http://www.ids.ac.uk/</span></a></span><span style="font-size: 8pt; font-family: "Times New Roman","serif"; color: black;" lang="EN-US"> </span><span style="font-size: 8pt; color: rgb(112, 48, 160);" lang="EN-US">Library
website:</span><span style="font-size: 8pt; color: black;" lang="EN-US"> <a href="http://blds.ids.ac.uk/" target="_blank"><span style="color: blue;">http://blds.ids.ac.uk</span></a>/</span><span style="font-size: 8pt; color: rgb(0, 112, 192);"></span></p>
<p class="MsoNormal"> </p>
</div>
<br clear="all"> 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
</div>
<br>_______________________________________________<br>
Koha mailing list<br>
<a href="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a><br>
<a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>
<br></blockquote></div><br>