MySQL/possible Perl trickery? Hints required...
'afternoon all I have a niggling problem with Koha installation. The environment: MacOS 10.3.7, MySQL 4.0.22-max, perl 5.8.1-RC3. Installer is run as root, with root MySQL access. Net::Z3950 and Yaz are not present, Date::Manip is installed by force, DBD::MySQL is present, after correcting a minor makefile issue by hand. All other modules installed fine. The problem: When the installer attempts to create the MySQL database, it creates the user, but then does not give the user enough access to the Koha database: Creating the MySQL database for Koha... 0/usr/local/mysql/bin/mysqladmin: CREATE DATABASE failed; error: 'Access denied for user: 'testkoha@localhost' to database 'koha'' ..and dies, unable to create the Koha database. Any ideas would be welcome - from Perl changes upward... Thanks! Adam. -- adam steer adam@adstereo.net :: http://adstereo.net [adam.steer@alia.org.au :: http://alia.org.au]
On Tue 08 Feb, adam wrote:
'afternoon all
I have a niggling problem with Koha installation.
The environment: MacOS 10.3.7, MySQL 4.0.22-max, perl 5.8.1-RC3. Installer is run as root, with root MySQL access.
This may be related to the problem I was having. After a lot of trial and error I discovered that Mysql seems not to work properly if it is run from the linux root account. ie if I log onto the mysql root account from my linux root account and then try grant to all on rubbish.* to 'roger'@'localhost' identified by 'horne' (as suggested in the MYSQL Cookbook) mysql responds "OK". If I then quit and log on using mysql -phorne -uroger Mysql is happy and lets me do so. If however I then try from that account to create database rubbish; it tells me that it cannot create the database. Using mysqladmin has exactly the same result. Roger -- Roger Horne, 11 New Square, Lincoln's Inn, London WC2A 3QB mailto:roger@hrothgar.co.uk
participants (2)
-
adam -
Roger Horne