云函数创建mysql 表报错

[XTLiuFeng]

代码:

  String host = System.getenv("MYSQL_HOST_MYRDB");
String port = System.getenv("MYSQL_PORT_MYRDB");
String user = System.getenv("MYSQL_ADMIN_USER_MYRDB");
String password = System.getenv("MYSQL_ADMIN_PASSWORD_MYRDB");
Connection connection;
Statement statement;
        {
    try {
            Class.forName("com.mysql.jdbc.Driver").newInstance();
        connection = DriverManager.getConnection("jdbc:mysql://" + host + ":" + port + "/test?" +
                "user=" + user + "&password=" + password);
        statement = connection.createStatement();
    } catch (SQLException e) {
        throw new RuntimeException(e);
    } catch (ClassNotFoundException e) {
        throw new RuntimeException(e);
    } catch (InstantiationException e) {
        throw new RuntimeException(e);
    } catch (IllegalAccessException e) {
        throw new RuntimeException(e);
    }
        }

报错:code: 1, error: java.sql.SQLSyntaxErrorException: Unknown database 'test'

[linlin]

你可以试试通过管理员面板或者命令行工具创建名为 test 的 database:

CREATE DATABASE IF NOT EXISTS test;