(Also below are some tips for possibly using MySQL). This is tested to work for Mariadb 10.1 running on a dual boot Linux Debian 8.6/Windows 10. Then tested with JDBC directly and confirmed “Relationship” problem. Signed up but even when asking to v1.5.3 only 1.5.7 was offered.Ĭopied MySQL connector from Mint 18 - Connector/J 5.1.36, localhost:3306 & my “test” DB and connection worked immediately. Tried to get v1.5.3 but they wanted a sign in. Downloaded mariadb-java-client-1.5.7.jar - it would not work no matter what was done. Moved over JRE 8u102 from Mint 18 and pointed to it in LO. show tables and show databases proved they were created. Luckily the next page of instructions provided the creation of a DB & some tables here. Not even the “test” database stated in the instructions here.
Mysql jdbc driver ubuntu password#
Then prompted for password from the installation step. You just need mysql -u root -p for first time sign-in. Signing on was a bit of a pain - mentioned instructions were overly stated. During the installation part, you will be asked for a password (for root account). Using Synaptic Package Manager, installed MariaDB-server and all recommended affliates. Start with almost newly installed OS of Debian 8.6 using Cinnamon v2.2.16 (almost because a few months back I installed LO v5.2.3.3). I attempted to perform an installation based upon the instructions presented by with the following results:
If all entered OK, you’re up and running.Īlthough subtle, there seems to be some differences between MariaDB and MySQL. This is where you enter the connection properties: Once installed you create a new Base file selecting Connect to an existing database and select MySQL. The Class Path is discussed but is nothing more than pointing to (using Add Archive) the connector. This page ( click here) contains instructions for connection of Base and MySQL and a link to the JDBC connector. I have been using the MySQL JDBC connector(with MySQL) for quite some time now and have had no problems. You don’t need JDK - JRE is fine but I would think about upgrading to version 8.
0 kommentar(er)
