Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-features-functions.html
Certain functions do not replicate well under some conditions: The USER(), CURRENT_USER() (or CURRENT_USER), UUID(), VERSION(), and LOAD_FILE() functions are replicated without change and thus do not work reliably on the replica unless row-based ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-binary-package.html
For example: mysqld_safe --user=mysql --datadir=/path/to/existing-datadir & If there are encrypted InnoDB tablespaces, use the --early-plugin-load option to load the keyring plugin. During this process, the server upgrades metadata for all database ... This section describes how to upgrade MySQL binary and package-based installations on ...
https://dev.mysql.com/doc/relnotes/mysql-router/8.4/en/news-8-3-0.html
The following error was returned: Unknown character set '' (Bug #35968017) If MySQL Router was bootstrapped over an existing configuration, the existing user's credentials were retrieved from the keyring and reused, even if the user used the ...
https://dev.mysql.com/doc/mysql-router/9.4/en/mysqlrouter_keyring.html
list: List usernames stored in the keyring; or list properties of a user stored in the keyring. set: Add or overwrite account of the user in the keyring file delete: Delete user from the keyring. The mysqlrouter_keyring utility is a command line ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-privileges.html
mysql>GRANT SELECT, INSERT, CREATE, DROP, ALTER, UPDATE ON output_schema.* TO 'user_name'@'%'; For more information, see Privileges Provided by MySQL and Default MySQL Privileges. What's Next Learn about the available LLMs, embedding Models, and ...
https://dev.mysql.com/doc/refman/8.4/en/privilege-changes.html
If the mysqld server is started without the --skip-grant-tables option, it reads all grant table contents into memory during its startup sequence. If you modify the grant tables indirectly using an account-management statement, the server notices ...The in-memory tables become effective for access control at that ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-change-user.html
Syntax: ccnx.change_user(user='user_name, password='password_val', database='db_name') Changes the user and sets a new default database.
https://dev.mysql.com/doc/refman/8.4/en/flush.html
Reloading the grant tables is necessary to enable updates to MySQL privileges and users only if you make such changes directly to the grant tables; it is not needed for account management statements such as GRANT or REVOKE, which take effect ...| ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-server-compatibility.html
strip_restricted_grants Certain privileges are restricted in MySQL HeatWave on AWS, such as RELOAD , FILE , SUPER , BINLOG_ADMIN , and SET_USER_ID . skip_invalid_accounts Skips user accounts created with external authentication plugins that are not ... MySQL Server Compatibility 7.1.2 MySQL Server Compatibility MySQL HeatWave on AWS has several security-related restrictions that are not present in an on-premise instance of ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-table-reference.html
The following table summarizes all available INFORMATION_SCHEMA tables. For greater detail, see the individual table descriptions. Table 28.1 INFORMATION_SCHEMA Tables Table Name Description Deprecated ADMINISTRABLE_ROLE_AUTHORIZATIONS Grantable ...