Page 1 of 1

Cannot connect to MySQL

PostPosted: Tue Jan 14, 2014 4:19 pm
by bevil
I have a Servoy (4.1.7) solution which has a connection to both Sybase and Mysql simultaneously.

My solution was running unusably slowly whenever mysql data was being accessed. I have uninstalled and reinstalled the MySQL back end, and now cannot connect to it from within Servoy. Both a direct connection in the terminal, as well as a connection from SequelPro work fine connecting to MySQ. Only Servoy will not connect or create the database. I have tried with each of the Mysql drivers, but all of them have the error "Communications link failure" with the exact same username, password and port. This install of Servoy worked with mysql before I reinstalled mysql (although glacially slowly)

Anyone have any suggestions?

See attached screenshot of my error, plus a terminal connection to mysql database, as well as a Sequel Pro connection to the database.

Thanks

Bevil

Re: Cannot connect to MySQL

PostPosted: Tue Jan 14, 2014 4:35 pm
by bevil
I have just downloaded the latest jdbc driver and installed. Makes no difference.

Re: Cannot connect to MySQL

PostPosted: Tue Jan 14, 2014 5:20 pm
by bevil
One thing.. Mysql is not running on the default mysql port, it is running on 8889. How do I identify that in the url ? Is that where I am going wrong?

Re: Cannot connect to MySQL

PostPosted: Tue Jan 14, 2014 5:26 pm
by bevil
I have changed the mysql port to 3306 and it works.

Is it possible to identify to Servoy that MySQL is not running on the default port? I tried in the url when it was still 8889, and it also did not work..