- #Settin gup mysql jdbc install
- #Settin gup mysql jdbc driver
- #Settin gup mysql jdbc archive
- #Settin gup mysql jdbc password
I have the MariaDB Connector/J 1.5 Series (v 1.5.7) installed.
#Settin gup mysql jdbc install
You can stop, start or re-start the MariaDB server as follows:ī) In Windows: Start | Find `Services` | Scroll down to `MySQL56` and right click on it for options to stop, restart, etc.Ģ) Download and install the MariaDB JDBC connector jar file from here. You’ll want to have the server stopped while editing these, especially if moving the path to the database files by changing the datadir parameter. (I think I like it better than phpMyAdmin.)ĭata base settings are in /etc/mysql/my.cfg (in Linux), and in C:\ProgramData\MySQL\MySQL Server 5.6\my.ini (in Windows). In Windows 10, I don’t know of a similar command line test, however you can use HeidiSQL.Īlso in Linux HeidiSQL works nicely under Wine. You should get a prompt, and enter something like: (I have the Debian Linux MariaDB 10.1 Series installed.)
#Settin gup mysql jdbc driver
But then I got stopped when I tried to open the database below after I had entered the correct info in, especially “”, but it comes back with the wrong driver class:ġ) If you don’t already have it installed, install MariaDB from here. I was able to manually type in the real address for it from the root.
#Settin gup mysql jdbc archive
First it wanted me to select the java class path archive in the home space rather than the root.
EDIT: I tried to get this to work on OpenOffice 4.1.3, but can’t. (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.
#Settin gup mysql jdbc 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)
