Cannot connect to MySQL

Questions and answers regarding general SQL and backend databases

Cannot connect to MySQL

Postby bevil » Tue Jan 14, 2014 4:19 pm

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
Attachments
Screen Shot 2014-01-14 at 09.35.25.png
Screen Shot 2014-01-14 at 09.35.25.png (1008.81 KiB) Viewed 2831 times
bevil
 
Posts: 163
Joined: Thu Oct 18, 2012 7:31 pm

Re: Cannot connect to MySQL

Postby bevil » Tue Jan 14, 2014 4:35 pm

I have just downloaded the latest jdbc driver and installed. Makes no difference.
bevil
 
Posts: 163
Joined: Thu Oct 18, 2012 7:31 pm

Re: Cannot connect to MySQL

Postby bevil » Tue Jan 14, 2014 5:20 pm

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?
bevil
 
Posts: 163
Joined: Thu Oct 18, 2012 7:31 pm

Re: Cannot connect to MySQL

Postby bevil » Tue Jan 14, 2014 5:26 pm

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..
bevil
 
Posts: 163
Joined: Thu Oct 18, 2012 7:31 pm


Return to SQL Databases

Who is online

Users browsing this forum: No registered users and 5 guests

cron