Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-features-create-alter-drop-server.html
The statements CREATE SERVER, ALTER SERVER, and DROP SERVER are not written to the binary log, regardless of the binary logging format that is in use.
https://dev.mysql.com/doc/workbench/en/wb-create-schema-objects.html
Additional objects such as views or routines can be added in the same way as tables. To view these schema objects, select the Catalog tab in the middle palette on the right. View all the objects by clicking the + button to the left of the schema ...
https://dev.mysql.com/doc/workbench/en/wb-creating-views.html
You can add views to a database either from the Physical Schemas section of the MySQL Model page or from the EER Diagram.
https://dev.mysql.com/doc/internals/en/creating-index-keys.html
As part of every table-write operation (INSERT, UPDATE, DELETE), the storage engine is required to update its internal index information. The method used to update indexes will vary from storage engine to storage engine, depending on the method ...
https://dev.mysql.com/doc/refman/8.4/en/pluggable-authentication-system-variables.html
Authentication uses either one or two LDAP bind operations, depending on whether the MySQL account names an LDAP user DN: If the account does not name a user DN: authentication_ldap_sasl performs an initial LDAP binding using ...(The SPN and same ...
https://dev.mysql.com/doc/refman/8.4/en/pluggable-authentication.html
The Default Authentication Plugin The CREATE USER and ALTER USER statements have syntax for specifying how an account authenticates. For example: CREATE USER 'jeffrey'@'localhost' IDENTIFIED BY 'password'; In such cases, the server assigns the ...
https://dev.mysql.com/doc/mysql-router/9.4/en/mysqlrouter.html
The bootstrap process creates a new MySQL user account with a randomly generated password to use by that specific MySQL Router instance. --account Command-Line Format --account username Type String A bootstrap option to specify the MySQL user to ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-authentication-plugins-proxy-users.html
Use the CREATE USER or GRANT statement to associate accounts with plugins. Proxy user accounts must be set up to be authenticated by the plugin. Proxy user accounts must have the PROXY privilege for the proxied accounts. This string comes from the ... One of the capabilities that pluggable authentication makes possible is proxy users (see Proxy ...The plugin developer ...
https://dev.mysql.com/doc/refman/8.4/en/replication-howto-repuser.html
Although you do not have to create an account specifically for replication, you should be aware that the replication user name and password are stored in plain text in the replica's connection metadata repository mysql.slave_master_info (see Section ... Each replica connects to the source using a MySQL user name and password, so there must be a user account on the source that the replica can use to ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-secure-user.html
To secure the user credentials, you can require SSL for connections with the user account, and provide the user credentials when Group Replication is started, rather than storing them in the replica status tables. 20.6.3.1.1 Replication User With ...