Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

How to connect to existing mysql database without errors?

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"'. "

How to connect to existing mysql database without errors?

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"'. "