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”’. "
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.