Driver for mysql

From this directory, run the following command to compile the samples and package them in a jar file:. Note : No corresponding Ant target exists in the build. The database URL for Java DB, which is used to establish a database connection, includes the option to create the database if it does not already exist.

SeeEstablishing a Connection for more information. If you are using either Java DB or MySQL, then from the same directory, run the following command to delete existing sample database tables, recreate the tables, and populate them. For Java DB, this command also creates the database if it does not already exist:. Note : You should run the command ant setup every time before you run one of the Java classes in the sample. Many of these samples expect specific data in the contents of the sample's database tables.

Each target in the build. The following table lists the targets in the build. Download Mysql Jdbc Driver - Mysql-connector-java Go to the following link to download Apache Ant: Ensure that the Apache Ant executable file is in your PATH environment variable so that you can run it from any directory. Modify the build. Modify these XML files as follows: Modify build. You do not need to change this value. For Java DB, this is org.

For MySQL, this is com. SID The name of the database the tutorial creates and uses. Do not change this value. After completing the installation, we will need to configure the ODBC driver and its related connections.

This will lead to pop up of the following window. After clicking on the finish button, you will need to specify the fields that will be needed for configuring the DSN connection using the window of connection parameters as shown below. Now, click on the test button after entering the above details to check whether the database connection is getting pinged properly as shown below.

You can even specify other network details related to secure socket layer by clicking on the ssl button shown below. The connection is now ready. You can use the connection in different applications such as Microsoft Excel, Word to connect the database and retrieve data and manipulate the same. You can easily install it when you want to use it by following the above steps in the windows platform. You may also have a look at the following articles to learn more —.

Submit Next Question. By signing up, you agree to our Terms of Use and Privacy Policy. Forgot Password? Connectivity Troubleshooting If you get problems connecting to the database, please remember : Press the ping button in the connection dialog to make sure the host and port are reachable.

Enable Remote connections as they are not always enabled by default. This may require configuration changes. Windows Firewall may block the communication. You may need to reconfigure or disable it. Check the driver version is compatible with the database software. Please inform us in this case. Further connectivity tips can be found on the MySql Connectivity Tips page.