[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[libreoffice-users] Re: Installing MySQL Connector
- Subject: [libreoffice-users] Re: Installing MySQL Connector
- From: Alexander Thurgood <email@example.com>
- Date: Sun, 01 Apr 2012 19:27:08 +0200
- To: firstname.lastname@example.org
Le 08/02/12 20:02, Pertti Rönnberg a écrit :
What exactly is the issue you have had with using the MySQL JDBC
connector on Windows ?
Prerequisites : a JDK or JRE, access to a running mysql server instance,
either locally or via the network (beware that internet connections to
externally hosted mysql servers can be very slow, or access can be
refused to them by hosting service companies for various security
reasons). The user attempting to connect to the mysql server instance
must have the rights to do so, and also any rights to create, modify ro
change tables, table structures, etc, according to what is desired for
that user. These must be configured in advance within the mysql server.
A database schema (database name) must be created in advance of any
attempt to connect via LO and the JDBC connector.
A useful tool for this is phpmyadmin. This is included in XAMP for
example, which contains a complete apache web server, mysql and php
stack, obtainable here :
via JDBC: (These steps are only valid for the MySQL connector)
Get the newest JDBC driver from
Goto Tools > Options > Java
Press the browse button near "Classpath" and browse for the *.jar
file(s) of your driver.
The jar file is part of the zip file that you download from the mysql
website. Look for the file called mysql-connector-java-5.1.18.jar
Open the data source administration dialog (Tools/Data Sources...) or
start the database wizard.
Press the button "New Data Source", in the name field, enter a valid
name like "MySQL JDBC", and keep "JDBC" as type.
Enter the data source URL
Switch to the tab page JDBC. Now you have to enter the driver class
name. For the MySQL connector driver you have to insert:
You can test that the driver is loaded correctly by pressing the
corresponding button. If the driver doesn't load, then there is either
something wrong with your driver setup or your Java installation.
Enter the name of the user you wish to connect, and mark the checkbox if
this user needs a password.
To be sure that your settings will be saved, press the Apply button.
You can also test the connection by clicking on the appropriate button.
If the connection fails, you will get an error message. If it succeeds,
you will get a message telling you so.
Save your ODB document with an appropriate name.
Once saved, click on the Tables icon in the main Base window, the tables
of your mysql database should appear (if you have defined any in advance).
For unsubscribe instructions e-mail to: email@example.com
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
|Re: [libreoffice-users] Re: Installing MySQL Connector||Pertti Rönnberg <firstname.lastname@example.org>|
|[libreoffice-users] Installing MySQL Connector||Tom Davies <email@example.com>|
|Re: [libreoffice-users] Installing MySQL Connector||Pertti Rönnberg <firstname.lastname@example.org>|
- Prev by Date: Re: [libreoffice-users] Fw: 'Open' Standards dependant on a single company?
- Next by Date: Re: [libreoffice-users] Impress full screen question
- Previous by thread: Re: [libreoffice-users] Installing MySQL Connector
- Next by thread: Re: [libreoffice-users] Re: Installing MySQL Connector