[Koha-bugs] [Bug 7443] New: Change the mysql commands in the INSTALL.* files

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7443

             Bug #: 7443
           Summary: Change the mysql commands in the INSTALL.* files
    Classification: Unclassified
 Change sponsored?: ---
           Product: Koha
           Version: master
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Documentation
        AssignedTo: nengard at gmail.com
        ReportedBy: magnus at enger.priv.no
         QAContact: ian.walls at bywatersolutions.com


Currently the instructions in INSTALL.debian, INSTALL.ubuntu and
INSTALL.ubuntu.lucid for setting up the database looks like this: 

 103     $ mysqladmin -uroot -p<password> create <kohadatabasename>
 104     $ mysql -uroot -p<password>
 105 
 106     Welcome to the MySQL monitor.  Commands end with ; or \g.
 107     Your MySQL connection id is 22
 108     Server version: 5.0.51a-24 (Debian)
 109 
 110     Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
 111 
 112     mysql> grant all on <kohadatabasename>.* to
'<kohadatabaseuser>'@'localhost' identified by '<kohadatabaseuserpassword>';
 113     Query OK, 0 rows affected (0.00 sec)
 114 
 115     mysql> flush privileges;
 116     Query OK, 0 rows affected (0.00 sec)

Speaking as a not overly experienced Linux user, I think this would be slightly
easier to understand: 

--------------------------------------------------------

$ mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 22
Server version: 5.0.51a-24 (Debian)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create database <kohadatabasename>; 
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)

--------------------------------------------------------

This would: 
- avoid the constrct -uroot, which might be mistaken for a long option with one
dash
- use the mysql command for everything, and not drag mysqladmin into it
- avoid putting the password on the commandline and thence potentially into the
output of commands like top and ps, and the bash history file

Opinions?

Not so sure about these:
- INSTALL.fedora7 has "mysql-u root-p" which i assume is a typo for "mysql -u
root -p"? 
- INSTALL.opensuse has "mysqladmin -uroot create koha -p" which i think might
be re-written in the way i suggest above?

-- 
Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are watching all bug changes.