mySQL connection by READ DATABASE operator in RapidMiner to RapidAnalytics

daradara Member Posts: 29 Contributor II
edited November 2018 in Help
Hello
We have installed both RapidMiner and Rapid Analytics. All is working well and locally on RapidMiner I could get some operations executing towards our final application.

However we would like to run a mySQL server on RapidAnalytics and we did install successfully with the url which is issued by the RapidAnalytics:

jdbc:mysql://localhost:3306/resume

I try to access it remotely from RapidMiner and set the Parameters for READ DATABASE AS FOLLOWS:

define connetion = url
database url = jdbc:mysql://localhost:3306/resume
username = resume  <<<< setup in Rapid Analytics
passowrd = ****    <<<< setup in Rapid Analytics

So we  get the connection but end up with the error on the Rapid Analytics :
com.rapidminer.operator.UserError: Database error occurred: Access denied for user 'resume'@'localhost' (using password: YES)

We are sure all the mySQL setup is correct on Rapid Analytics and access rights are set.

Thank you for your help

Dara
Tagged:

Answers

  • daradara Member Posts: 29 Contributor II
    I did more experiments and discovered that url like:

    jdbc:mysql://localhost:3306/resume

    works if the Rapid Miner is running on the same server hardware.

    If the Rapid Miner is running remotely then this url fails for some reason.

    The error message was posted in the head of this thread

    D
Sign In or Register to comment.