Factory PMI can not connect to the MySQL database. I’ve set the connection to: jdbc:mysql://localhost:3306/test. test is the name of the database. Also, it cannot connect to IADemo that came with. I get the following message:
FAIL (next test in 7 seconds)
Message: (hide details)
Access denied for user ‘root’@‘localhost’ (using password: NO)
Access denied for user ‘root’@‘localhost’ (using password: NO)
means that MySQL is refusing the connection based on your permissions and you’re sending it a blank password. Did you have MySQL installed prior to running the unified installer?
If you go to the FPMI gateway configuration page, then Datasources->connections, you can edit that connection to have the correct username and password.
I’ve tried putting in the correct user name and password. The message always says “using password: NO”. The message for the IADemo connection (also FAILED) says “using password: YES”. Everything was installed with the unified installer.
Hmm, this is odd. For the “test” database, when you edit the datasource connection and put in your username and password, ensure that you are also checking the “Change Password” checkbox. It should say Using password: YES (assuming the password is not blank)
The next thing I would do is go into the MySQL Administrator application. If you can log into this, you can get to the “User Administration” section. But, if you can log into this, you should be able to use the same login for FactoryPMI. If you can log into this and the same login doesn’t work for FactoryPMI, ensure that the root user has permissions for the databases that you’re using.
Of course, the Unified Installer should take care of all of these details. If you could, please call us today and we can do an interactive GoToMeeting session to try and figure out what is going on.
Checking the “change password” box worked. (I assumed this allowed changing of the password at the database). Also, I had to reenter the password and check the box for IADemo. Thank for the help