Search Results
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-user-accounts.html
To have passwords automatically expire after a specified number of days, add an entry similar to this under the [mysqld] option group in the MySQL configuration file (/etc/my.cnf): default_password_lifetime=120 A setting of 120 means that the ...It ...
https://dev.mysql.com/doc/workbench/en/wb-reverse-engineer-create-script.html
Select fewer elements to create the EER diagram." In this case, execute the reverse engineering wizard with this option disabled, manually create the EER diagram, and then import the 1000+ objects using the EER diagram catalog viewer. The following ... To reverse-engineer a database using a create script, do one of the following: On the home screen, select the model view from the sidebar, click (>) next to Models, and then click Reverse Engineer MySQL Create ...
https://dev.mysql.com/doc/workbench/en/wb-table-editor-columns-tab.html
PK: PRIMARY KEY NN: NOT NULL UQ: UNIQUE INDEX BIN: BINARY UN: UNSIGNED ZF: ZEROFILL AI: AUTO_INCREMENT G: Generated Column This option is available as of MySQL Server 5.7. You must manually add single quote characters for the default value. If a ...
https://dev.mysql.com/doc/internals/en/binary-log-overview.html
[Some information in this section is derived from Chapter 20, The Binary Log, in the MySQL Reference Manual.] The binary log is a set of log files that contain information about data modifications made to a MySQL server instance. Many details of ...
https://dev.mysql.com/doc/internals/en/libmysql-directory.html
For example, as described in an earlier section of this manual, there is a discussion of libmysql/libmysql.c which sends packets from the client to the server. The libmysql files are split into three directories: libmysql (this one), libmysql_r (the ...The files here are for producing MySQL as a library (for example, a Windows ...
https://dev.mysql.com/doc/ndbapi/en/overview-selecting-tc.html
The pool of connections from which this selection is made consists of all available connections. This is done by providing a table and a partition key (usually the primary key). Note that this is only a hint; the system can be reconfigured at any ...
https://dev.mysql.com/doc/workbench/en/wb-keys.html
The following tables list keyboard shortcuts for MySQL Workbench commands.
https://dev.mysql.com/doc/workbench/en/wb-migration-database-concepts.html
MySQL only supports one schema for each database (or rather, a MySQL database is a schema) so this difference in design must be planned for. The following table shows a comparison between each DBMS product supported by the Migration Wizard and ...
https://dev.mysql.com/doc/internals/en/debug-sync-implementation.html
Pseudo code for a synchronization point: #define DEBUG_SYNC(thd, sync_point_name) if (unlikely(opt_debug_sync_timeout)) debug_sync(thd, STRING_WITH_LEN(sync_point_name)) The synchronization point performs a binary search in a sorted array of ...The ...
https://dev.mysql.com/doc/internals/en/implementing-rnd-next-method.html
After the table is initialized, the MySQL server will call the handler's [custom-engine.html#custom-engine-api-reference-rnd_next rnd_next()] method once for every row to be scanned until the server's search condition is satisfied or an end of file ...The rnd_next() method takes a single byte array parameter named ...