PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/set-sql-log-bin.html
The session user must have privileges sufficient to set restricted session variables. mysqldump adds a SET @@SESSION.sql_log_bin=0 statement to a dump file from a server where GTIDs are in use, which disables binary logging while the dump file is ...
https://dev.mysql.com/doc/refman/8.0/en/user-names.html
MySQL stores accounts in the user table of the mysql system database. This means that anyone can attempt to connect to the server using any user name, so you cannot make a database secure in any way unless all MySQL accounts have passwords. Warning ...An account is defined in terms of a user name and the client host or hosts from which the user can connect to the ...Standard ...
https://dev.mysql.com/doc/refman/8.0/en/validate-password-installation.html
To be usable by the server, the component library file must be located in the MySQL plugin directory (the directory named by the plugin_dir system variable). To install the validate_password component, use this statement: INSTALL COMPONENT ... This ...For general information about installing and uninstalling components, see Section 7.5, “MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/windows-extract-archive.html
If you do not install MySQL at C:\mysql, you must specify the path to the install directory during startup or in an option file. Extract the install archive to the chosen installation location using your preferred file-compression tool. To install ...Make sure that you are logged in as a user with administrator ...
https://dev.mysql.com/doc/refman/8.0/en/cannot-initialize-character-set.html
You might see an error like this if you have character set problems: MySQL Connection Failed: Can't initialize character set charset_name This error can have any of the following causes: The character set is a multibyte character set and you have ...In this case, you need to recompile the client by running CMake with the -DDEFAULT_CHARSET=charset_name ...
https://dev.mysql.com/doc/refman/8.0/en/view-restrictions.html
With regard to view updatability, the overall goal for views is that if any view is theoretically updatable, it should be updatable in practice. Many theoretically updatable views can be updated now, but limitations still exist. Dump files created ... The maximum number of tables that can be referenced in the definition of a view is ...
https://dev.mysql.com/doc/refman/8.0/en/create-event.html
The minimum requirements for a valid CREATE EVENT statement are as follows: The keywords CREATE EVENT plus an event name, which uniquely identifies the event in a database schema. The event_name must be a valid MySQL identifier with a maximum length ...The event does not run unless the Event Scheduler is ... CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON SLAVE] [COMMENT 'string'] DO ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-keywords-table.html
Prior to MySQL 8.0.13, selecting from the KEYWORDS table with no default database selected produced an error. This file can be found in the sql directory under the build directory. This file may be useful for applications that require a static ...
https://dev.mysql.com/doc/refman/8.0/en/uninstall-component.html
If any error occurs, the statement fails and has no effect. A component provides services that are available to the server and other components; see Section 7.5, “MySQL Components”. It requires the DELETE privilege for the mysql.component system ...
https://dev.mysql.com/doc/refman/8.0/en/semijoins.html
It must not contain any aggregate functions (whether it is explicitly or implicitly grouped). The statement must not use the STRAIGHT_JOIN join type in the outer query. The number of outer and inner tables together must be less than the maximum ...