Check whether root user can access the machine with IP 192.168.1.187.
Check whether root user can access the machine with IP 192.168.1.187 It is not trying to connect to 192.168.1.187. 'root'@'192.168.1.187' in the exception means a user with user name "root" in the machine with IP '192.168.1.187' trying to access the database server. Therefore 192.168.1.187 is the client IP.
Database servers restricts the access based on user and the IP of the machine user use to connect. Therefore if you want to connect to the database server from a IP '192.168.1.187', you should grant permission to access the user to access from that specific IP. Check MySQL GRANT for more details.
Exactly what I was thinking. +1. –?
Jan 5 at 4:21 thanks for the help...its working now. Root doesn't have access to 192.168.1.187 IP... – user1010280 Jan 5 at 4:24 I wanted to know how can I get to know that which database is accessible to which user? – user1010280 Jan 5 at 4:25 In mysql database server, there is a schema named "mysql".
In that schema, there is a table named "User". You can find the mysql user details and granted permissions in that table. And see the "db" table for database specific users and user privileges.
Please note that "%" in "host" field means that user can access from any IP. – Manjula Weerasinge Jan 5 at 4:34 thanks manjula.... – user1010280 Jan 5 at 4:38.
To be more secure, you need to assign the root password and try it again. The page below contains Java code to connect to mysql database: worldbestlearningcenter.com/index_files/....
I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.