连接到 MySQL 数据库

2022-01-24 00:00:00 connection database mysql java

如何从 Java 连接到 MySQL 数据库?Java 在本地机器上运行，而数据库在远程服务器上.

How do I connect from Java to a MySQL database? The Java is running on a local machine while the Database is on a remote server.

推荐答案

此示例使用 MySQL 的 MM JDBC 驱动程序连接到 MySQL 数据库:

This example connects to a MySQL database using the MM JDBC driver for MySQL:

Connection connection = null;

try {
    // Load the JDBC driver
    String driverName = "com.mysql.jdbc.Driver"; // MySQL MM JDBC driver
    Class.forName(driverName);

    // Create a connection to the database
    String serverName = "localhost";
    String mydatabase = "mydatabase";
    String url = "jdbc:mysql://" + serverName +  "/" + mydatabase; // a JDBC url
    String username = "username";
    String password = "password";
    connection = DriverManager.getConnection(url, username, password);
} catch (ClassNotFoundException e) {
    // Could not find the database driver
} catch (SQLException e) {
    // Could not connect to the database
}

您需要在 MySQL 数据库中拥有一个帐户才能运行此示例.要创建一个帐户，您可以以 root 身份连接到您平台上的 MySQL 数据库，然后运行以下命令:

You need to have an account in MySQL database to run this example. To create an account, you can connect to MySQL database on your platform as root, and run the following command:

mysql> GRANT SELECT, INSERT, UPDATE, DELETE PRIVILEGES ON *.* 
       TO username@localhost IDENTIFIED BY 'password' WITH GRANT OPTION;

相关文章