Ask Your Question

How to connect to existing mysql database without errors? [closed]

asked 2013-08-09 13:46:32 +0200

eniac gravatar image

updated 2015-11-06 04:41:18 +0200

Alex Kemp gravatar image

I have Mint Olivia (Ubuntu 13.04)sistem. I have installed mysql server and i have created a database. I wanted to connect to that database through a "Libre Office base". It didn't let me do it. It keep warning me about Mysql connectors, so i downloaded mysql-connector-java-5.1.26-bin and installed. I restarted LibreOffice and started all over again. Still dont want to let me connect to my database i created previously with mysqladmin with this command $ mysqladmin -u root -p create testdatabase Database wizard in Libre Office is asking me to enter Database name, Server , and port number. I dont know what it means by "Server" (Is it requires just name or a full path). I have tested com.mysql.jdbc.Driver and it says it works. But when i open database it asks me to create new one!! I dont want new one i want my already creted one. So i created new database and then a popup warning shows up telling me that "The connection to the data source "TestDatabase" could not be established." "SQL Status: 08001 Cannot load connection class because of underlying exception: 'java.lang.NumberFormatException: For input string: "mysql:3306"'. "

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-06 04:41:39.101457

1 Answer

Sort by » oldest newest most voted

answered 2013-08-10 01:04:20 +0200

w_whalley gravatar image

updated 2013-08-10 01:09:48 +0200

The MySQL database you named testdatabase is different than the "database" that LibreOffice base is asking you to create. It is asking you to create a .odb file that will act as a front end to your MySQL database. The .odb file can have any name you want.

It sounds as though you did create an .odb file and the connector works but are still having connection problems. The connection properties for a MySQL database that is on the same computer and that is accessible using the MySQL root user are: Database name "testdatabase" (without the quotes, and case sensitive), Server localhost, User name root. You will be prompted for the root password when you attempt to use the database.

From your description one problem may be that you used the name testdatabase for MySQL and TestDatabase for LO base.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2013-08-09 13:46:32 +0200

Seen: 2,306 times

Last updated: Aug 10 '13