How do i download mysql connector jar in linux?

MySQL Community Downloads

Connector/J

• General Availability (GA) Releases
• Archives
• 

Connector/J 8.0.30

Select Operating System:

Recommended Windows Download:

MySQL Connector/J is the official JDBC driver for MySQL. MySQL Connector/J 8.0 is compatible with all MySQL versions starting with MySQL 5.6. Additionally, MySQL Connector/J 8.0 supports the new X DevAPI for development with MySQL Server 8.0.

Online Documentation:

• MySQL Connector/J Installation Instructions
• Documentation
• MySQL Connector/J X DevAPI Reference (requires Connector/J 8.0)
• Change History

MySQL Connector/J 8.0 is highly recommended for use with MySQL Server 8.0, 5.7 and 5.6. Please upgrade to MySQL Connector/J 8.0.

Please report any bugs or inconsistencies you observe to our Bugs Database.
Thank you for your support!

Obtaining and Using the Binary Distribution Packages

Different types of binary distribution packages for Connector/J are available from the Connector/J Download page. The following explains how to use each type of the packages to install Connector/J.

Using Platform-independent Archives: .tar.gz or .zip archives are available for installing Connector/J on any platform. Using the appropriate graphical or command-line utility (for example, tar for the .tar.gz archive and WinZip for the .zip archive), extract the JAR archive from the .tar.gz or .zip archive to a suitable location.

Note

Because there are potentially long file names in the distribution, the Connector/J archives use the GNU Tar archive format. Use GNU Tar or a compatible application to unpack the .tar.gz variant of the distribution.

Using Packages for Software Package Management Systems on Linux Platforms: RPM and Debian packages are available for installing Connector/J on a number of Linux distributions like Oracle Linux, Debian, Ubuntu, SUSE, and so on. Install these packages using your system's software package management system.

Configuring the CLASSPATH

Once mysql-connector-java-version.jar has been extracted from the binary distribution package to the right place, finish installing the driver by placing the JAR archive in your Java classpath, either by adding its full file path to your CLASSPATH environment variable, or by directly specifying the file path with the command line switch -cp when starting the JVM.

For example, on Linux platforms, add the Connector/J driver to your CLASSPATH using one of the following forms, depending on your command shell:

# Bourne-compatible shell (sh, ksh, bash, zsh):
$> export CLASSPATH=/path/mysql-connector-java-ver.jar:$CLASSPATH

# C shell (csh, tcsh):
$> setenv CLASSPATH /path/mysql-connector-java-ver.jar:$CLASSPATH

You can also set the CLASSPATH environment variable in a profile file, either locally for a user within the user's .profile, .login, or other login file, or globally by editing the global /etc/profile file.

For Windows platforms, you set the environment variable through the System Control Panel.

Configuring Connector/J for Application Servers

To use MySQL Connector/J with an application server such as GlassFish or Tomcat, read your vendor's documentation for information on how to configure third-party class libraries, as most application servers ignore the CLASSPATH environment variable. For configuration examples for some J2EE application servers, see Chapter 8, Connection Pooling with Connector/J, Section 9.3, “Configuring Load Balancing with Connector/J”, and Section 9.5, “Advanced Load-balancing and Failover Configuration”. However, the authoritative source for JDBC connection pool configuration information is the documentation for your own application server.

If you are developing servlets or JSPs and your application server is J2EE-compliant, you can put the driver's .jar file in the WEB-INF/lib subdirectory of your web application, as this is a standard location for third-party class libraries in J2EE web applications. You can also use the MysqlDataSource or MysqlConnectionPoolDataSource classes in the com.mysql.cj.jdbc package, if your J2EE application server supports or requires them. The javax.sql.XADataSource interface is implemented using the com.mysql.cj.jdbc.MysqlXADataSource class, which supports XA distributed transactions. The various MysqlDataSource classes support the following parameters (through standard set mutators):

• user

• password

• serverName

• databaseName

• port

How do I download MySQL Connector in Linux?

Where can I download MySQL Connector jar file?

Where is MySQL Connector jar file in Linux?