Unable to connect otk databse

[Anon Anon]

Hi Team,

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.

 

 

OTK 4.1

Policy manager 9.2

[didsi01]

can you upload the screenshot showing the jdbc connection settings please

[Derek Orr]

Hi

 

Try the following URL and driver:

 

URL = jdbc:mysql://localhost:3306/otk_db

 

Driver = com.l7tech.jdbc.mysql.MySQLDriver

 

Regards

[Zhijun He]

That means either the user 'root'@'localhost' had been removed, or the password of 'root'@'localhost' is not correct

[Barry Stern]

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

1. GRANT SELECT,UPDATE,DELETE,INSERT ON otk_db.* TO '<db_user>'@'%' identified by '<db_user_password>';
2. mysql> flush privileges;

[Anon Anon]

OTK 4.1

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

[Barry Stern]

Hello,

 

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 

[Anon Anon]

Thanks Barry