[ILUG] IRM and mysql

[Lars Hecking]

 Has anyone here ever played with irm (http://irm.stackworks.net/)?
 The install instructions are quite scant when it comes to database
 setup, so I used the irm_create.sql script from linuxbox-irm-1.3.9rc2.

 However, while mysql-administrator tells me that both the irm user and
 schemate exists, none of the tables have been created. Any advice?
 I'm using mysql 4.1.18 (are there any compatibility issues when upgrading
 to 5.x?) on RH"E"L3.

 Here's the irm_create.sql script, sans comments:

>>
CONNECT mysql;
 
REPLACE INTO user (host, user, password)
    VALUES (
        'localhost',
        'irm',
  -- WARNING: Change this password!
        password('irm')
    );
 
REPLACE INTO db (host, db, user, select_priv, insert_priv, update_priv,
                 delete_priv, create_priv, drop_priv)
    VALUES (
        'localhost',
        'irm',
        'irm',
        'Y', 'Y', 'Y', 'Y',
        'Y', 'Y'
    );
                                                                                
FLUSH PRIVILEGES;
                                                                                
CREATE DATABASE irm;
                                                                                
CONNECT irm;
                                                                                
GRANT ALL PRIVILEGES ON irm.* TO irm at localhost;
                                                                                
FLUSH PRIVILEGES;
>>