Search Results
https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-secure-auth.html
MySQL Workbench uses mysql_native_password by default, so for example enabling it is required to create a MySQL Server 8.4 user. This is because MySQL does not store passwords as plain text, so regenerating password hashes requires user intervention. With this option enabled, a user with a password defined in the old format will not be able to login to ...
https://dev.mysql.com/doc/connectors/en/connector-python-connectargs.html
A connection with the MySQL server can be established using either the mysql.connector.connect() function or the mysql.connector.MySQLConnection() class: cnx = mysql.connector.connect(user='joe', database='test') cnx = MySQLConnection(user='joe', ...An asterisk (*) following an argument indicates a synonymous argument name, available only for compatibility with other Python MySQL ...
https://dev.mysql.com/doc/connector-python/en/connector-python-connectargs.html
A connection with the MySQL server can be established using either the mysql.connector.connect() function or the mysql.connector.MySQLConnection() class: cnx = mysql.connector.connect(user='joe', database='test') cnx = MySQLConnection(user='joe', ...An asterisk (*) following an argument indicates a synonymous argument name, available only for compatibility with other Python MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/set-password.html
If an account is to be permitted to manipulate secondary passwords for all accounts, it should be granted the CREATE USER privilege rather than APPLICATION_PASSWORD_ADMIN. SET PASSWORD [FOR user] auth_option [REPLACE 'current_auth_string'] [RETAIN ...The password may be either explicitly specified in the statement or randomly generated by ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-user-roles.html
MySQL Enterprise Monitor Agent installation requires a dedicated user in each monitored MySQL server, and optional limited and general users the installer can create for you. Before installing MySQL Enterprise Monitor, gather credentials (a root ...
https://dev.mysql.com/doc/connectors/en/connector-j-time-instants.html
Changes the server session time zone to a desired time zone specified by the user, and then converts the timestamps between the JVM time zone and the user-specified time zone. connectionTimeZone={LOCAL|SERVER|user-defined-time-zone}: Specifies how ... Background A time instant is a specific moment on a ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-acl-best-open-ref.html
The following users are involved in this scenario: Manager: responsible for all monitored assets. This user has the permission to close Events, due to MySQL Instances being set to Administer. This role is permitted to perform the following actions: ...This scenario has the following role types: Manager: responsible for all monitored assets, advisor configuration, group configuration, query analysis, event handling and ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-ui-settings-external-auth-ref.html
When unchecked, MySQL Enterprise Monitor provides for a pre-auth bind user to lookup account records. For Active Directory, the most common user account attribute is sAMAccountName, whereas it is common for Unix-based LDAP to use CN. Bind as User: ... Table 15.3 External Authentication Name Description Disabled No external authentication system is ...
https://dev.mysql.com/doc/connector-j/en/connector-j-time-instants.html
Changes the server session time zone to a desired time zone specified by the user, and then converts the timestamps between the JVM time zone and the user-specified time zone. connectionTimeZone={LOCAL|SERVER|user-defined-time-zone}: Specifies how ... Background A time instant is a specific moment on a ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-privilege-synchronization.html
A statement granting the NDB_STORED_USER privilege, such as GRANT NDB_STORED_USER ON *.* TO 'cluster_app_user'@'localhost', works by directing NDB to create a snapshot using the queries SHOW CREATE USER cluster_app_user@localhost and SHOW GRANTS FOR ... Privilege synchronization is the mechanism used by NDB Cluster for sharing and synchronizing users, roles, and privileges between SQL ...