PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/change-replication-source-to.html
OFF: The replica sets sql_require_primary_key = OFF; no replicated CREATE TABLE or ALTER TABLE statement is checked for the presence of a primary key. SOURCE_CONNECTION_AUTO_FAILOVER = {0|1} Activates the asynchronous connection failover mechanism ...] CHANGE REPLICATION SOURCE TO changes the parameters that the replica server uses for connecting to the source and reading data from the ...
https://dev.mysql.com/doc/refman/8.0/en/charset-database.html
The CREATE DATABASE and ALTER DATABASE statements have optional clauses for specifying the database character set and collation: CREATE DATABASE db_name [[DEFAULT] CHARACTER SET charset_name] [[DEFAULT] COLLATE collation_name] ALTER DATABASE db_name ... Every database has a database character set and a database ...
https://dev.mysql.com/doc/refman/8.0/en/charset-table.html
The CREATE TABLE and ALTER TABLE statements have optional clauses for specifying the table character set and collation: CREATE TABLE tbl_name (column_list) [[DEFAULT] CHARACTER SET charset_name] [COLLATE collation_name]] ALTER TABLE tbl_name ...
https://dev.mysql.com/doc/refman/8.0/en/crashing.html
In this case, you can try to change the storage engine to another engine by using ALTER TABLE on a repaired copy of the table. If you have a problem with tables containing dynamic-length rows and you are using only VARCHAR columns (not BLOB or TEXT ... Each MySQL version is tested on many platforms before it is ...
https://dev.mysql.com/doc/refman/8.0/en/data-directory-initialization.html
To ensure this, start mysqld from the system root account and include the --user option as shown here: bin/mysqld --initialize --user=mysql bin/mysqld --initialize-insecure --user=mysql Alternatively, execute mysqld while logged in as mysql, in ...
https://dev.mysql.com/doc/refman/8.0/en/default-privileges.html
Note Alternative means for performing the process described in this section: On Windows, you can perform the process during installation with MySQL Installer (see Section 2.3.3, “MySQL Installer for Windows”). Connect to the server as root using ... The MySQL installation process involves initializing the data directory, including the grant tables in the mysql system schema that define MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/docker-mysql-more-topics.html
Oracle does not provide support for MySQL products running in such an altered container, or a container created from an altered Docker image. As an alternative to specifying the password explicitly, you can set the variable with a container file ...
https://dev.mysql.com/doc/refman/8.0/en/events-metadata.html
The session time zone that is current when a CREATE EVENT or ALTER EVENT statement executes is used to interpret times specified in the event definition. Value EVENTS Table SHOW EVENTS Execute at ETZ ETZ Starts ETZ ETZ Ends ETZ ETZ Last executed ETZ ... To obtain metadata about events: Query the EVENTS table of the INFORMATION_SCHEMA ...
https://dev.mysql.com/doc/refman/8.0/en/events-syntax.html
The definition of an existing event can be changed by means of the ALTER EVENT statement. MySQL provides several SQL statements for working with scheduled events: New events are defined using the CREATE EVENT statement. When a scheduled event is no ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-mysql-cluster.html
It is also possible to convert existing tables that use other storage engines to NDBCLUSTER using one or more ALTER TABLE statement. In the following section, we answer questions that are frequently asked about MySQL NDB Cluster and the NDB storage ...