I have a Gateway installed on my local machine , and i am using Mysql Databse,whihc is installed on my machine,
When i try connecting the database i see the following issue.
Policy manager 9.2
can you upload the screenshot showing the jdbc connection settings please
Try the following URL and driver:
URL = jdbc:mysql://localhost:3306/otk_db
Driver = com.l7tech.jdbc.mysql.MySQLDriver
That means either the user 'root'@'localhost' had been removed, or the password of 'root'@'localhost' is not correct
First please confirm you created the otk_db on the local mysql? If you did then I recommend creating a seperate user in mysql to use for the connection and not use mysql root user.
You can use the following to create the user with the necessary privileges and set the password for the user
POLicy manager 9.2
1287 Using GRANT for creating new user is deprecated and will be removed in future release. Create new user with CREATE USER statement. 0.015 sec
this is from the current OTK documentation, I am sure in future versions it will be updated accordingly.
MySQL Database - CA API Management OAuth Toolkit - 4.2 - CA Technologies Documentation