Catalog

install MySql

eclipse To configure mysql

---

install MySql:

I use it Ubuntu20.04, So use the following command to install directly ：

sudo apt-get install mysql-server 

If other, you can update the source first ：

sudo apt-get update

Check whether the installation is successful ：

systemctl status mysql

start-up mysql：

sudo mysql  // No password required , It's fine too su Enter the super user and directly use mysql
// perhaps 
mysql -u root -p // You need to enter a password 

mysql A password is automatically generated , Check the method ：

sudo cat /etc/mysql/debian.cnf

thus Mysql Installation successful , The initial password has also been .

eclipse To configure mysql:

Go to MySQL Official website download Java Of JDBC.

Operation as shown in figure ：

  Unzip the downloaded file .

  open eclipse => Window => Preferences

I have created JDBC One, so he reported a mistake .

  Go back to the interface just now ：

  Find the folder you just extracted , choice jar package , And then click OK, Save it ：

  On the right side, click the highest level project file , And then right-click => Build Path => Configure Build Path...:

  After checking , Click finish , Save to exit . I've already done it , So I can't order here .

  And then create a new one .java file , Enter the following code to verify the successful connection MySQL.

import java.sql.*;

public class test05 {
    public static void main(String args[]) {
        Connection conn=null;
        try {
          Class.forName("com.mysql.cj.jdbc.Driver");     
          System.out.println("Success!");
        }
        catch (Exception e) {
          System.out.print("Error!");
          e.printStackTrace();
        }

        try {
          conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "debian-sys-maint", "VShIsIqvYFvcb5q1");
          System.out.println("Success!");
          conn.close();
        }
        catch (Exception e) {
          System.out.print("get data error!");
          e.printStackTrace();
        }  
    }
}

  The configuration is successful by outputting the following results ：