mysql协议获取版本号

SELECT VERSION();

mysql -u username -p
mysql> SELECT VERSION();

import mysql.connector

config = {
    'user': 'username',
    'password': 'password',
    'host': 'localhost',
    'database': 'database_name'
}

try:
    cnx = mysql.connector.connect(**config)
    cursor = cnx.cursor()
    query = "SELECT VERSION()"
    cursor.execute(query)
    version = cursor.fetchone()[0]
    print("MySQL Version:", version)
except mysql.connector.Error as err:
    print("Error:", err)
finally:
    cursor.close()
    cnx.close()

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class MySQLVersion {
    public static void main(String[] args) {
        String url = "jdbc:mysql://localhost:3306/database_name";
        String user = "username";
        String password = "password";

        try (Connection conn = DriverManager.getConnection(url, user, password);
             Statement stmt = conn.createStatement();
             ResultSet rs = stmt.executeQuery("SELECT VERSION()")) {

            if (rs.next()) {
                System.out.println("MySQL Version: " + rs.getString(1));
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

GRANT SELECT ON database_name.* TO 'username'@'host';