Ask Your Question
0

Problems setting up a connection to a MySQL Database [closed]

asked 2014-01-17 16:22:54 +0100

rhogg4653 gravatar image

I am trying to get MySQL and LibreOffice Base working on a stand alone PC.

I have tried ODBC (errors installing MySQL ODBC so gave up), JDBC and connect directly both give "Communications Link Failure".

I can connect via MySQL Workbench and create and modify tables etc. So I believe MySQL is up and working.

Are there any log files which would shed more light on what is causing the error?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-18 14:26:21.240753

2 Answers

Sort by » oldest newest most voted
0

answered 2014-01-17 18:11:15 +0100

Alex Thurgood gravatar image

Hi,

http://stackoverflow.com/questions/2121829/mysql-jdbc-communications-link-failure

http://forums.mysql.com/read.php?39,191966,206313#msg-206313

Basically, for one reason or another, your network connection attempts to the db server are either timing out (this can happen when using a remote, internet based host) or else firewalls are blocking the traffic or something else is hogging the bandwidth.

Alex

edit flag offensive delete link more
0

answered 2014-01-18 11:37:01 +0100

rhogg4653 gravatar image

Hi Alex,

I have partly solved the problem. What the unhelpful error message really meant was "Invalid Hostname". Once I corrected this I have been able to create tables etc in LibreOffice base which do appear in the MySQL database. So far so good.

What does not work is actually getting any real data into the system. When I try drag and drop from either another base window or from a calc spreadsheet all I get is "CREATE command denied to user xxxx@localhost for table x". Yet I am able to create tables willy nilly from within base OK.

Is this a bug or a limitation?

edit flag offensive delete link more

Comments

I would check out the user's rights on the mysql server first. If those are all OK, then it might be a bug. My thinking, which could be completely wrong, of course, is that you require absolute GRANT privileges on the server for the user connecting to MySQL via LO in order to be able to copy/drag/drop from another source. Like I said, I could be wrong, and it could be a bug with the windows version.

Alex Thurgood gravatar imageAlex Thurgood ( 2014-01-18 18:23:29 +0100 )edit

Yes I made sure in the first place that the user had all rights including GRANT.

rhogg4653 gravatar imagerhogg4653 ( 2014-01-18 18:29:37 +0100 )edit

Problem solved. The schema prefix was missing.

rhogg4653 gravatar imagerhogg4653 ( 2014-01-21 17:36:01 +0100 )edit

Question Tools

2 followers

Stats

Asked: 2014-01-17 16:22:54 +0100

Seen: 1,262 times

Last updated: Jan 18 '14