Amusing localhost while configured gateway database and OTK database for both the database is mysql.I want to change from localhost to the ip address of the server.At what places i should update this from localhost to ip?
Essentially i want to connect mysql database using a SQL developer tool so that I can have a clear view about the tables and the data.pls advice.
For Gateway Database, Change in node.properties file.
For OTK Database, change in JDBC connection.
Note - otk_user is having access only via localhost. Allow otk_user to connect via server IP.
Am getting the following exception changed from localhost to the hostname of the machine.If it was localhost it works but not with the hostname.pls advice.
You need to set DNS properly for gateway server, or you may need to put it in /etc/hosts file.
Sorry, it's not a connection problem, it's "Access denied" which means a permission problem. As Joe Dascole said below, you need to grant proper permissions to 'otk_user1'@'ssg91pri.mydmn.com'
You need to set the grants for that user in MySQL
GRANT SELECT,UPDATE,DELETE,INSERT ON otk_db.* TO 'otk_user1'@'ssg91pri.mydmn.com' identified by 'PASSWORD';
where PASSWORD is to be changed to the otk_user1 password.