Search Results
https://dev.mysql.com/doc/refman/8.4/en/alter-table.html
For example, you can add or delete columns, create or destroy indexes, change the type of existing columns, or rename columns or the table itself. To use ALTER TABLE, you need ALTER, CREATE, and INSERT privileges for the table. Renaming a table ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-data-encryption.html
A DBA can grant this privilege to enable a user to deviate from the default_table_encryption setting when creating or altering a schema or general tablespace, or to deviate from the default schema encryption when creating or altering a table. You ...
https://dev.mysql.com/doc/refman/8.4/en/alter-event.html
(See Section 15.1.13, “CREATE EVENT Statement”.) Any user can alter an event defined on a database for which that user has the EVENT privilege. The syntax for each of the DEFINER, ON SCHEDULE, ON COMPLETION, COMMENT, ENABLE / DISABLE, and DO ...
https://dev.mysql.com/doc/refman/8.4/en/environment-variables.html
USER The default user name on Windows when connecting to mysqld. On some systems, if you set MYSQL_PWD, your password is exposed to any other user who runs ps. Even on systems without such a version of ps, it is unwise to assume that there are no ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-connect-drivermanager.html
try { conn = DriverManager.getConnection("jdbc:mysql://localhost/test?" + "user=minty&password=greatsqldb"); // Do something with the Connection ... } catch (SQLException ex) { // handle any errors System.out.println("SQLException: " + ... When you ...
https://dev.mysql.com/doc/x-devapi-userguide/en/connecting-connection-pool.html
Closing the Client object closes all connections it manages, invalidates all Sessions the Client has created, and destroys the managed pool. X DevAPI supports connection pooling, which can reduce overhead for applications that open many connections ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-connect-drivermanager.html
try { conn = DriverManager.getConnection("jdbc:mysql://localhost/test?" + "user=minty&password=greatsqldb"); // Do something with the Connection ... } catch (SQLException ex) { // handle any errors System.out.println("SQLException: " + ... When you ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-instruments-table.html
Summaries for finer levels are unavailable, such as per thread, account, user, or host. Instruments with a higher volatility index (for example, SESSION = 5) are created and destroyed for every user session. When an instrument is enabled and ... The ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-authentication.html
If none is specified, it is authentication plugin dependent what user name is used. Since Version all versions password The password to use when authenticating the user. It is a synonym of the connection property 'password' and can also be set with ...Since Version all versions password1 The password to use in the first phase of a Multi-Factor Authentication ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-model-load.html
Use ML_MODEL_ACTIVE to check which models are active for which users. All active users and models share the amount of memory defined by the shape, and it might be necessary to schedule users. ML_MODEL_LOAD Syntax mysql> CALL ... The ML_MODEL_LOAD ...