change mysql db from local host to ip

[Popleys]

Hi There,

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.

[Mahesh.nagane]

Hi,

 

 

 

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.

 

 

 

 

 

Regards,

 

Mahesh

[Popleys]

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.

 

[Zhijun He]

You need to set DNS properly for gateway server, or you may need to put it in /etc/hosts file.

[Zhijun He]

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'

[Joe Dascole]

Hi Sharath,

 

You need to set the grants for that user in MySQL

 

ie:

 

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.

 

Regards,

Joe