mySQL connection by READ DATABASE operator in RapidMiner to RapidAnalytics
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
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