Hi Ratha, In MySQL server, *skip-networking* setting must have been enabled. You have to disable it to allow remote connections. More infor here [1].
[1] http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html Thanks, Bhathiya On Wed, Feb 11, 2015 at 9:35 AM, Vijayaratha Vijayasingam <[email protected]> wrote: > Hi all; > Trying to connect remote mysql server which in windows box. But getting[1]; > > I can ping to that machine and firewall is off. Root user has all > privileges. > > Anyone knows the cause, what type of security settings i need to do in > mysql? > > [1]Caused by: > com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could > not create connection to database server. Attempted reconnect 3 times. > Giving up. > > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) > > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > > at java.lang.reflect.Constructor.newInstance(Constructor.java:526) > > at com.mysql.jdbc.Util.handleNewInstance(Util.java:377) > > at com.mysql.jdbc.Util.getInstance(Util.java:360) > > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) > > at com.mysql.jdbc. > > Caused by: java.sql.SQLException: null, message from server: "Host > '192.168.50.62' is not allowed to connect to this MySQL server" > > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996) > > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:935) > > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:924) > > at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1037) > > > thanks > -- > -Ratha > > _______________________________________________ > Dev mailing list > [email protected] > http://wso2.org/cgi-bin/mailman/listinfo/dev > > -- *Bhathiya Jayasekara* *Software Engineer,* *WSO2 inc., http://wso2.com <http://wso2.com>* *Phone: +94715478185* *LinkedIn: http://www.linkedin.com/in/bhathiyaj <http://www.linkedin.com/in/bhathiyaj>* *Twitter: https://twitter.com/bhathiyax <https://twitter.com/bhathiyax>* *Blog: http://movingaheadblog.blogspot.com <http://movingaheadblog.blogspot.com/>*
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
