Where is MySQL connector jar file in NetBeans?

1. Log in to your A2 Hosting account using SSH.
2. At the command line, type the following command, replacing USERNAME with your username: mysql -u USERNAME -p.
3. At the Enter Password prompt, type your password.
4. To display a list of databases, type the following command at the mysql> prompt:

1. Import JDBC packages.
2. Load and register the JDBC driver.
3. Open a connection to the database.
4. Create a statement object to perform a query.
5. Execute the statement object and return a query resultset.
6. Process the resultset.
7. Close the resultset and statement objects.
8. Close the connection.

1. import java.sql.*;
2. class MysqlCon{
3. public static void main(String args[]){
4. try{
5. Class.forName("com.mysql.jdbc.Driver");
6. Connection con=DriverManager.getConnection(
7. //here sonoo is database name, root is username and password.
8. Statement stmt=con.createStatement();

1. Step 1: download MySQL.
2. Step 2: extract the files.
3. Step 3: move the data folder (optional)
4. Step 4: create a configuration file.
5. Step 5: test your installation.
6. Step 6: change the root password.

1. Click the Services tab.
2. Right-click the Databases node and select New Connection to open the New Connection dialog.
3. Under Name, select Java DB (Network).
4. Set User Name to APP.
5. Set Password to APP.
6. Select the Remember Password during this Session box.
7. Click OK.

1. Right-click on your project.
2. Select Build Path.
3. Click on Configure Build Path.
4. Click on Libraries and select Add External JARs.
5. Select the jar file from the required folder.
6. Click and Apply and Ok.

1. import java.sql.*;
2. class MysqlCon{
3. public static void main(String args[]){
4. try{
5. Class.forName("com.mysql.jdbc.Driver");
6. Connection con=DriverManager.getConnection(
7. //here sonoo is database name, root is username and password.
8. Statement stmt=con.createStatement();

1. Right click in libraries.
2. Add Jar/Folder.
3. Add your mysql-connector-java-5.1.13-bin.jar.
4. right click in you project; click on "Clean and Build";
5. After that go to the netbeans project folder;
6. It creats a new folder called:"Dist" In this folder will have a file ProjectName.

1. Right-click the Databases node in the Services window and choose Register MySQL Server to open the MySQL Server Properties dialog box.
2. Confirm that the server host name and port are correct.

4 Answers

1. Under Services , open the Databases node.
2. Right-click on Java DB and select properties.
3. In the Database Location field, enter the path to the copied folder.

1. Download the MySQL Installer from dev.mysql.com.
2. Run the installer that you downloaded from its location on your server, generally by double-clicking.
3. Determine which setup type you would like to use for the installation:
4. Install the server instance and whichever additional products you selected.