Koha - anyone do an install? MySQL question...

[Mark Komarinski]

On 09/13/2010 09:06 PM, Bruce Labitt wrote:
> /[mysql]/ = Command that needs to be typed from within the mysql program
>
> /A. [cmd]/mysqladmin -uroot -ppassword create kohadata
>
> /B. [cmd]/mysql -uroot -ppassword
>
> /C. [mysql]/grant all on kohadata.* to 'root'@'localhost' identified by
> 'password';
>
> /D. [mysql]/flush privileges;
>
> /E. [mysql]/quit;
>
> In particular, what goes in 'root' and 'password'? Am I giving root
> privilege to kohadata? Why would I want to do that? Right now, my spouse
> does not have admin privileges on the system. Can someone explain this
> to me?

The command in C should be something like:

grant all on kohadata.* to 'koha'@'localhost' identified by 'password';

That will create a non-root user (koha at localhost) that has a password of 
password.  When you set up the user in koha, make sure the username and 
hostname is set properly as koha at localhost is different from 
koha at foo.bar.com (or whatever domain you use).

Since you're using a grant statement, I don't think you need to run the 
command in D.

-Mark