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
Ricardo, thanks for your assistance as this makes perfect sense. However, my frustration level has just gone through the roof and I think I need the weekend to relax before coming back to this project. Here's why: I'm following the instructions in the document you're referring to (INSTALL.debian) as I've just installed the current Debian release on the respective computer. (The plan is to install Koha 3.) I'm at step 1.2, Set up your locale, which says that I "_MUST_" follow all the steps outlined there [http://wiki.koha.org/doku.php?id=encodingscratchpad]... BEFORE you install Koha." Ok, that's what I'm trying to do. Those instructions then tell me to log into MySQL using an account that INSTALL.debian doesn't tell me to create until step 2.2! So, basically the instructions are telling me to do something based on the results of something I haven't been told to do yet. I'll admit I'm a n00b to this but I do consider myself ready, willing and able to follow most technical instructions. Having those instructions in the correct order generally helps. Josh, I see you're the author of INSTALL.debian. Might this be something that can be correct for future users? --------------------------------------------------------------- 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@nlc.state.ne.us http://nlc.state.ne.us/ http://www.travelinlibrarian.info/ --------------------------------------------------------------- -----Original Message----- From: newsgroup.posts@gmail.com [mailto:newsgroup.posts@gmail.com] On Behalf Of Ricardo Dias Marques Sent: Friday, June 20, 2008 8:04 AM To: Michael Sauers Cc: mlb@imparisystems.com; koha@lists.katipo.co.nz Subject: Re: [Koha] MySQL problem Hi Michael, On Fri, Jun 20, 2008 at 1:08 PM, Michael Sauers <msauers@nlc.state.ne.us> wrote: librarians
across the state how "easy" it is to install.
Given that you mention "beginner-level Linux experience", I'm assuming that you're trying to install Koha in a Linux distribution. What version of Koha are you trying to install? What Linux distribution are you using? Your assumption is correct: you should create a non-root MySQL user for Koha. The way of doing that is described, for example, in the INSTALL.debian file of the Koha distribution, that is also available online (for the current Koha 3 snapshot version) at: http://git.koha.org/cgi-bin/gitweb.cgi?p=Koha;a=blob;f=INSTALL.debian The relevant section of that INSTALL.debian file, for this problem, is section "2.2 Create the Koha database": ____________________ 2.2 Create the Koha database Create the database and user with associated privileges: $ mysqladmin -uroot -p<password> create <kohadatabasename> $ mysql -uroot -p<password> Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 22 Server version: 5.0.32-Debian_7etch3-log Debian etch distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> grant all on <kohadatabasename>.* to '<kohadatabaseuser>'@'localhost' identified by '<kohadatabaseuserpassword>'; Query OK, 0 rows affected (0.00 sec) mysql> flush privileges; Query OK, 0 rows affected (0.00 sec) mysql> quit ____________________ You should replace <kohadatabasename> above by the name of your koha database (usually "koha", without the quotes), <kohadataseuser> by the name of the MySQL user that you want to create (usually "kohaadmin", also without the quotes) and <kohadatabaseuserpassword> by the password that you want to assign to that user. The "grant all" command above creates the specified MySQL user. I hope this helps you. Best wishes, Ricardo Dias Marques lists AT ricmarques DOT net