Search Results
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-ssl-pfx.html
Creating a Certificate File to Use with the .NET Client From the directory server-repository-root/mysql-test/std_data, issue the following command. Connecting to the Server Using a File-Based Certificate Use the client.pfx file that you created in ...Instead, Windows includes a certificate store that provides platform-dependent certificates in PFX ...
https://dev.mysql.com/doc/refman/8.4/en/drop-role.html
To use this statement, you must have the global DROP ROLE or CREATE USER privilege. Users who have the CREATE USER privilege can use this statement to drop accounts that are locked or unlocked. Users who have the DROP ROLE privilege can use this ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-buffer-pool-tables.html
The InnoDB INFORMATION_SCHEMA buffer pool tables provide buffer pool status information and metadata about the pages within the InnoDB buffer pool. The InnoDB INFORMATION_SCHEMA buffer pool tables include those listed below: mysql> SHOW TABLES FROM ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-logging.html
Then use either of the following techniques to prevent it from being created again: Set the MYSQL_HISTFILE environment variable to /dev/null. Create .mysql_history as a symbolic link to /dev/null; this need be done only once: ln -s /dev/null ... The ...
https://dev.mysql.com/doc/refman/8.4/en/native-pluggable-authentication.html
Attempts to create a new user account or to alter an existing user account identified with mysql_native_password also fail and emit an error. mysql> CREATE USER userxx@localhost IDENTIFIED WITH 'mysql_native_password'; ERROR 1524 (HY000): Plugin ...
https://dev.mysql.com/doc/refman/8.4/en/preface.html
If you are using a Commercial release of MySQL 8.4, see the MySQL 8.4 Commercial Release License Information User Manual for licensing information, including licensing information relating to third-party software that may be included in this ...
https://dev.mysql.com/doc/refman/8.4/en/system-variable-privileges.html
Suppose that an administrator has created the following role to confer the ability to set restricted session system variables: CREATE ROLE set_session_sysvars; GRANT SYSTEM_VARIABLES_ADMIN ON *.* TO set_session_sysvars; Any user granted the ...In ...
https://dev.mysql.com/doc/refman/8.4/en/alter-database.html
A stored routine that uses the database defaults when the routine is created includes those defaults as part of its definition. See Section 15.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”.) If you change the default character set or ...alter_option: { [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_name | [DEFAULT] ENCRYPTION [=] {'Y' | 'N'} | READ ONLY [=] {DEFAULT | 0 | 1} } ALTER DATABASE enables you to change the overall characteristics of a ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-backup-restoring.html
The restored DB System uses the same MySQL Administrator user name and password that was in effect when the backup was created. Note: No administrator user name and password are requested, because the restored DB System uses the same administrator ... Restoring a Backup to a New DB System 18.4 Restoring a Backup to a New DB System When you restore a backup, you create a new DB System and restore the backup to ...
https://dev.mysql.com/doc/workbench/en/wb-plugins.html
Plugins are special Modules that are exposed to the user through the Workbench GUI. A plugin can be a simple function that performs some action on an input, and ends without further interaction with the user. To create a simple plugin, the function ...This is typically done using the main menu, or the context-sensitive ...