Hi Vijayaratha, Have you checked this answer[1] at stackoverflow. You could try adding a new administrator account:
[1] http://stackoverflow.com/questions/1559955/host-xxx-xx-xxx-xxx-is-not-allowed-to-connect-to-this-mysql-server On Wed, Feb 11, 2015 at 9:47 AM, Vijayaratha Vijayasingam <[email protected]> wrote: > I checked that option too. My setting is right..Attached screenshot > > On 11 February 2015 at 12:11, Bhathiya Jayasekara <[email protected]> > wrote: > >> 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 <%2B94715478185>* >> *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/>* >> > > > > -- > -Ratha > > _______________________________________________ > Dev mailing list > [email protected] > http://wso2.org/cgi-bin/mailman/listinfo/dev > > -- *Thanks and Regards,* Anuruddha Lanka Liyanarachchi Software Engineer - WSO2 Mobile : +94 (0) 712762611 Tel : +94 112 145 345 a <[email protected]>[email protected]
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
