[MKDoc-dev] Mysql 4.1.x problem with MKDoc 1.8 on FC4

[Chris Croome]

Hi

When using the MKDoc 1.8 site install script on FC4
(mysql-4.1.12-2.FC4.1) with SELinux is non-enforcing mode I get this
error:

  DBD::mysql::db do failed: Access denied for user 'mkd'@'localhost' to database 'mkd' at /usr/lib/perl5/site_perl/5.8.6/MKDoc/SQL/MySQL.pm line 28, <STDIN> line 34.
  DBD::mysql::db do failed: Access denied for user 'mkd'@'localhost' to database 'mkd' at /usr/lib/perl5/site_perl/5.8.6/MKDoc/SQL/MySQL.pm line 28, <STDIN> line 34.

This is after creating the database like this:

  INSERT INTO user (Host, User, Password) VALUES ('localhost', 'mkd', password ('mkd'));
  CREATE database mkd;
  INSERT INTO db (Host, Db, User, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv,Drop_priv, Grant_priv, References_priv, Index_priv, Alter_priv) VALUES ('localhost', 'mkd', 'mkd', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y');
  flush privileges;

I do have old_passwords=1 in /etc/my.cnf and connecting to the database
works fine on the command line:

  mysql -umkd -pmkd mkd

The line that is causing the problem is this:

  $dbh->do ("LOCK TABLES $name LOW_PRIORITY WRITE");

I *think* the problem might be with the commands used to create the mkd
database, although this works with MySQL 4.0.x on FC2 perhaps it needs
to change for 4.1.x? 

I have these DBD packages installed:

  perl-DBD-MySQL-2.9007-1
  perl-DBI-1.48-4
  libdbi-0.7.2-2
  libdbi-devel-0.7.2-2
  libdbi-dbd-mysql-0.7.1-3
  libdbi-drivers-0.7.1-3

Anyone have any ideas?

Chris

-- 
Chris Croome                               <chris at webarchitects.co.uk>
web design                             http://www.webarchitects.co.uk/ 
web content management                               http://mkdoc.com/