<div dir="ltr"><div>Now perform the mysql permissions grant step from 2.2 of the INSTALL.debian document:<br> </div><blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;" class="gmail_quote">
mysql -uroot -p<password> <br> </blockquote><blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;" class="gmail_quote">mysql> grant all on <kohadatabasename>.* to '<kohadatabaseuser>'@'localhost' identified by '<kohadatabaseuserpassword>';<br>
mysql> flush privileges;<br></blockquote><div><br>In this case you'll be using the same values from the KOHA_CONF file, though ideally your mysql root password should be different than the mysql password for the koha user. <br>
<br>--Joe <br> </div><div class="gmail_quote">On Tue, Oct 21, 2008 at 9:40 AM, Scott Kushner <span dir="ltr"><<a href="mailto:skushner@mplmain.mtpl.org">skushner@mplmain.mtpl.org</a>></span> wrote:<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-US">
<div>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);">Now I can connect as user root, but not as user koha. Must be a
rights issue. Get error 1045 (28000) access denied for koha@localhost (using
password: YES)<br></span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);">Any ideas, thanks! </span></p><div class="Ih2E3d">
<p><span style="font-size: 10pt; color: rgb(31, 73, 125);">Scott Kushner</span><span style="font-size: 10pt; color: rgb(31, 73, 125);"><br>Information Technologies</span><span style="font-size: 10pt; color: rgb(31, 73, 125);"><br>
Middletown Public Library</span><span style="color: rgb(31, 73, 125);"></span></p>
</div><div style="border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; border-width: 1pt medium medium; padding: 3pt 0in 0in;">
<p><b><span style="font-size: 10pt;">From:</span></b><span style="font-size: 10pt;"> Joe Atzberger
[mailto:<a href="mailto:ohiocore@gmail.com" target="_blank">ohiocore@gmail.com</a>] <br>
<b>Sent:</b> Monday, October 20, 2008 10:47 AM<br>
<b>To:</b> Jesse Weaver<br>
<b>Cc:</b> Scott Kushner; <a href="mailto:koha@lists.katipo.co.nz" target="_blank">koha@lists.katipo.co.nz</a><div class="Ih2E3d"><br>
<b>Subject:</b> Re: [Koha] Koha error/fatal error</div></span></p>
</div>
<p> </p>
<div>
<p style="margin-bottom: 12pt;">If the database is on the same
system, then the IP is typically something like localhost's <a href="http://127.0.0.1" target="_blank">127.0.0.1</a>. If the DB is on the same system,
try setting your <hostname> to "localhost" rather than an
external IP.</p><div><div></div><div class="Wj3C7c"><br>
<br>