Jdbc driver for mysql(connector/j) free download
Click to specify additional driver-specific options. The Test Connection dialog box opens. Enter the user name and password for your database, or leave these boxes blank if your database does not require them. If your connection succeeds, the Database Explorer dialog box displays a message indicating the connection is successful.
Otherwise, it displays an error message. Close this dialog box. Set the JDBC connection options. Test the database connection by specifying the user name username and password pwd , or leave these arguments blank if your database does not require them.
On the Database Explorer tab, in the Connections section, click and select the data source for the connection. In the connection dialog box, enter a user name and password, or leave these boxes blank if your database does not require them. The app connects to the database and displays its tables in the Data Browser pane. A data source tab appears to the right of the pane. The title of the data source tab is the data source name that you defined during the setup.
Close the data source tab to close the SQL query. In the Connections section, close the database connection by clicking. If multiple connections are open, close the database connection of your choice by selecting the corresponding data source from the list. Step 1. Verify the driver installation. Step 2. Set up the data source. You set up a data source using the Database Explorer app or the command line.
Save the JDBC data source. Step 3. JDBC drivers are Java library files with the extension. Usually, they are provided by the same company which implemented the MySql software. The URL is a string text with a specific format, containing information about the host where the database is running, the port, username, database name, etc.
The format is specific to each driver. Any wrong character in the URL may make the database connectivity fail, therefore we recommend installing DbSchema and try to get connected. During installation go for a detailed install, and when you are prompted for the user password check the 'Enable root access from remote machines'.
Enabling this you will be allowed to connect to MySql from another computer. Remember the password you set here, it will be requested when connecting to the database as user root. There are two tabs you can use to connect. You can enable remote access during installation see the next chapter or later using the instructions below.
If this didn't help, please try to search the web for tutorials. Free Download DbSchema When the download finished please follow this steps:. This will be the name of this specific connection to the database.