<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.18.2">
</HEAD>
<BODY LINK="#0000ff">
It says later on that it works with root, so give the root a try.<BR>
<BR>
Are you installing this on a Linux server or a Windows server? Are you working on the server or from a client machine? If it's Linux, what flavor?<BR>
<BR>
On Fri, 2008-06-20 at 07:08 -0500, Michael Sauers wrote:
<BLOCKQUOTE TYPE=CITE>
Ok, next question. I recall creating a root password for MySQL after installing it but these instructions say to not log in as root. So, as far as I know I’ve not yet created any MySQL users/passwords. I’m assuming I need to do this first…?<BR>
<BR>
<BR>
<BR>
Sorry for the noob questions but this is a giant experiment to see how easy (or not) this is for someone of extensive Windows experience and beginner-level Linux experience (i.e. Me) so we can tell our librarians across the state how “easy” it is to install.<BR>
<BR>
<BR>
<BR>
---------------------------------------------------------------<BR>
<BR>
Michael Sauers, Technology Innovation Librarian<BR>
<BR>
Nebraska Library Commission<BR>
The Atrium, 1200 N Street, Suite 120<BR>
Lincoln, NE 68508-2023<BR>
402-471-2045<BR>
800-307-2665 (NE only) <BR>
Fax: 402-471-2083<BR>
<A HREF="mailto:msauers@nlc.state.ne.us">msauers@nlc.state.ne.us</A><BR>
<BR>
<A HREF="http://nlc.state.ne.us/">http://nlc.state.ne.us/</A><BR>
<BR>
<A HREF="http://www.travelinlibrarian.info/">http://www.travelinlibrarian.info/</A><BR>
---------------------------------------------------------------<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
<B>From:</B> Matt Burkhardt [mailto:mlb@imparisystems.com] <BR>
<B>Sent:</B> Thursday, June 19, 2008 4:44 PM<BR>
<B>To:</B> Michael Sauers<BR>
<B>Subject:</B> Re: [Koha] MySQL problem<BR>
<BR>
<BR>
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
<BR>
<BR>
Hey Michael,<BR>
<BR>
It just means to run some commands within the mysql shell. There are several different ways to do this. Perhaps the easiest is to get to the command line - just open a terminal window (in Linux) or a DOS command window (in Windows) and type:<BR>
<BR>
mysql -u username -p<BR>
<BR>
and it should ask you for the mysql password associated with the username. Enter that, and it will say <BR>
<BR>
mysql><BR>
<BR>
just enter that line<BR>
<BR>
show variables where variable_name LIKE "character_set%" OR variable_name LIKE "collation%";<BR>
<BR>
and you'll get the list.<BR>
<BR>
<BR>
On Thu, 2008-06-19 at 13:38 -0500, Michael Sauers wrote: <BR>
<BR>
Ok, next question RE: <A HREF="http://wiki.koha.org/doku.php?id=encodingscratchpad">http://wiki.koha.org/doku.php?id=encodingscratchpad</A> <BR>
<BR>
<BR>
<BR>
MySQL – Server Configuration – I’ve added the four lines listed to the my.cnf file. It now says to “connect to mysql ad the (non-root) user and type:” I have no idea how to do this.<BR>
<BR>
<BR>
<BR>
---------------------------------------------------------------<BR>
<BR>
Michael Sauers, Technology Innovation Librarian<BR>
<BR>
Nebraska Library Commission<BR>
The Atrium, 1200 N Street, Suite 120<BR>
Lincoln, NE 68508-2023<BR>
402-471-2045<BR>
800-307-2665 (NE only) <BR>
Fax: 402-471-2083<BR>
<A HREF="mailto:msauers@nlc.state.ne.us">msauers@nlc.state.ne.us</A><BR>
<BR>
<A HREF="http://nlc.state.ne.us/">http://nlc.state.ne.us/</A><BR>
<BR>
<A HREF="http://www.travelinlibrarian.info/">http://www.travelinlibrarian.info/</A><BR>
---------------------------------------------------------------<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
<BLOCKQUOTE>
<PRE>
_______________________________________________
Koha mailing list
<A HREF="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</A>
<A HREF="http://lists.katipo.co.nz/mailman/listinfo/koha">http://lists.katipo.co.nz/mailman/listinfo/koha</A>
</PRE>
</BLOCKQUOTE>
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<TR>
<TD>
Matt Burkhardt, MSTM<BR>
President<BR>
Impari Systems, Inc.<BR>
401 Rosemont Avenue<BR>
Frederick, MD 21701<BR>
<A HREF="mailto:mlb@imparisystems.com">mlb@imparisystems.com</A><BR>
<A HREF="http://www.imparisystems.com">www.imparisystems.com</A><BR>
(301) 644-3911<BR>
<BR>
<BR>
<BR>
<BR>
</TD>
</TR>
</TABLE>
<BR>
<BR>
<BR>
<BR>
</BLOCKQUOTE>
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<TR>
<TD>
Matt Burkhardt, MSTM<BR>
President<BR>
Impari Systems, Inc.<BR>
401 Rosemont Avenue<BR>
Frederick, MD 21701<BR>
<A HREF="mailto:mlb@imparisystems.com">mlb@imparisystems.com</A><BR>
<A HREF="http://www.imparisystems.com">www.imparisystems.com</A><BR>
(301) 644-3911<BR>
<BR>
<BR>
</TD>
</TR>
</TABLE>
</BODY>
</HTML>