Search Results
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/9.7/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/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/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/relnotes/mysql/9.7/en/news-9-4-0.html
(Bug #37463478) Microsoft Windows: MySQL Configurator allowed additions of duplicate users, such as users defined with the same user name and host name, and then created them as different users on the server. Note These release notes were created ...(Bug #37983282) Character Set Support Important Change: IFNULL() used in a LIKE clause raised ...
https://dev.mysql.com/doc/relnotes/mysql/9.7/en/news-9-3-0.html
(Bug #37191149) The mysqldump utility can now provide logical dumps of information about user accounts, writing the appropriate CREATE USER and GRANT SQL statements to the dump, when run with the --users command line option introduced in this ...
https://dev.mysql.com/doc/relnotes/mysql/9.7/en/news-9-1-0.html
(WL #16232) Audit Log Notes The audit log treated a user whose name did not begin with an alphanumeric character (such as '$foo') as invalid, despite the fact that the MySQL server allows such users to be created. (Bug #36522343) InnoDB: The upgrade ...This could lead to the following issues: When CREATE DATABASE failed after the database directory was created but before the operation was actually committed, the data dictionary had no record of the database's existence, but the database directory was still present in the file system, necessitating manual ...
https://dev.mysql.com/doc/refman/9.7/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 ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-threads-table.html
row *************************** THREAD_ID: 1 NAME: thread/sql/main TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: NULL PROCESSLIST_HOST: NULL PROCESSLIST_DB: mysql PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: 418094 PROCESSLIST_STATE: NULL ... The threads table contains a row for each server ...