[Koha] MySQL problem

[Joshua Ferraro]

Hey Michael,

I just did a google search on 'create new user in mysql' and found the answer
in the first hit, which took me to the MySQL manual.

Cheers,

Josh

On Fri, Jun 20, 2008 at 8:08 AM, Michael Sauers <msauers at nlc.state.ne.us> wrote:
> 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…?
>
>
>
> 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.
>
>
>
> ---------------------------------------------------------------
>
> Michael Sauers, Technology Innovation Librarian
>
> Nebraska Library Commission
> The Atrium, 1200 N Street, Suite 120
> Lincoln, NE 68508-2023
> 402-471-2045
> 800-307-2665 (NE only)
> Fax: 402-471-2083
> msauers at nlc.state.ne.us
>
> http://nlc.state.ne.us/
>
> http://www.travelinlibrarian.info/
> ---------------------------------------------------------------
>
>
>
>
>
> From: Matt Burkhardt [mailto:mlb at imparisystems.com]
> Sent: Thursday, June 19, 2008 4:44 PM
> To: Michael Sauers
> Subject: Re: [Koha] MySQL problem
>
>
>
> Hey Michael,
>
>     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:
>
> mysql -u username -p
>
> and it should ask you for the mysql password associated with the username.
> Enter that, and it will say
>
> mysql>
>
> just enter that line
>
> show variables where variable_name LIKE "character_set%" OR  variable_name
> LIKE "collation%";
>
> and you'll get the list.
>
>
> On Thu, 2008-06-19 at 13:38 -0500, Michael Sauers wrote:
>
> Ok, next question RE: http://wiki.koha.org/doku.php?id=encodingscratchpad
>
>
>
> 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.
>
>
>
> ---------------------------------------------------------------
>
> Michael Sauers, Technology Innovation Librarian
>
> Nebraska Library Commission
> The Atrium, 1200 N Street, Suite 120
> Lincoln, NE 68508-2023
> 402-471-2045
> 800-307-2665 (NE only)
> Fax: 402-471-2083
> msauers at nlc.state.ne.us
>
> http://nlc.state.ne.us/
>
> http://www.travelinlibrarian.info/
> ---------------------------------------------------------------
>
>
>
>
>
> _______________________________________________
>
> Koha mailing list
>
> Koha at lists.katipo.co.nz
>
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
> Matt Burkhardt, MSTM
> President
> Impari Systems, Inc.
> 401 Rosemont Avenue
> Frederick, MD  21701
> mlb at imparisystems.com
> www.imparisystems.com
> (301) 644-3911
>
>
>
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>



-- 
Joshua Ferraro                       SUPPORT FOR OPEN-SOURCE SOFTWARE
CEO                         migration, training, maintenance, support
LibLime                                Featuring Koha Open-Source ILS
jmf at liblime.com |Full Demos at http://liblime.com/koha |1(888)KohaILS