manifoldcf-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nigel Thomas <>
Subject ManifoldCF 1.0.1 MySQL setup : Error getting connection: Access denied for user
Date Fri, 02 Nov 2012 15:21:21 GMT

I am having some problems configuring 1.0.1 to use a MySQL database, I
have followed steps here :

I have set the following db related properties in properties.xml:

  <property name="org.apache.manifoldcf.databaseimplementationclass"
  <property name="org.apache.manifoldcf.mysql.server"
  <property name="org.apache.manifoldcf.dbsuperusername" value="root"/>
  <property name="org.apache.manifoldcf.dbsuperuserpassword" value="password"/>
  <property name="" value="manfold_db"/>
  <property name="org.apache.manifoldcf.database.username" value="root"/>
  <property name="org.apache.manifoldcf.database.password" value="password"/>
  <property name="org.apache.manifoldcf.database.maxhandles" value="100"/>

On running, the following exception is thrown:

 org.apache.manifoldcf.core.interfaces.ManifoldCFException: Error
getting connection: Access denied for user 'root'@'%' to database
 	at org.apache.manifoldcf.core.database.DBInterfaceMySQL.createUserAndDatabase(
 	at org.apache.manifoldcf.core.system.ManifoldCF.createSystemDatabase(
 	at org.apache.manifoldcf.crawler.system.ManifoldCF.createSystemDatabase(
 	at org.apache.manifoldcf.crawler.InitializeAndRegister.doExecute(
 	at org.apache.manifoldcf.crawler.InitializeAndRegister.main(

I am able to connect to the MySQL instance using a command line MySQL
client from the same machine using the same credentials, this rules
out networking and credentials related issues.

Am not sure what I am missing with the setup, I have tried the
equivalent with a postgres setup, this seems to work just fine.


Nigel Thomas

View raw message