PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/using-innodb-tables.html
.frm Files MySQL stores data dictionary information for tables in .frm files in database directories. When MySQL drops a table or a database, it deletes one or more .frm files as well as the corresponding entries inside the InnoDB data dictionary.
https://dev.mysql.com/doc/refman/5.7/en/windows-server-first-start.html
Note The database must be initialized before MySQL can be started. This section gives a general overview of starting the MySQL server. The following sections provide more specific information for starting the MySQL server from the command line or ...
https://dev.mysql.com/doc/refman/5.7/en/added-deprecated-removed.html
slave_parallel_type: Tells replica to use timestamp information (LOGICAL_CLOCK) or database partioning (DATABASE) to parallelize transactions. Options and Variables Introduced in MySQL 5.7 Options and Variables Deprecated in MySQL 5.7 Options and ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table-problems.html
If you get a duplicate-key error when using ALTER TABLE to change the character set or collation of a character column, the cause is either that the new column collation maps two keys to the same value or that the table is corrupted. In the latter ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table.html
The temporary copy of the table is created in the database directory of the original table unless it is a RENAME TO operation that moves the table to a database that resides in a different directory. If charset_name is DEFAULT in a CONVERT TO ...
https://dev.mysql.com/doc/refman/5.7/en/assigning-passwords.html
MySQL stores credentials in the user table in the mysql system database. Operations that assign or modify passwords are permitted only to users with the CREATE USER privilege, or, alternatively, privileges for the mysql database (INSERT privilege to ... Required credentials for clients that connect to the MySQL server can include a ...
https://dev.mysql.com/doc/refman/5.7/en/backup-strategy-example.html
The following is an example log excerpt: InnoDB: Database was not shut down normally. You should include such options as necessary to enable client programs to connect to the MySQL server. Assume that data is stored in the InnoDB storage engine, ...
https://dev.mysql.com/doc/refman/5.7/en/caching-sha2-pluggable-authentication.html
The database administrator must set these variables at server startup if the key files to use have names that differ from the system variable default values. Client users can obtain the RSA public key two ways: The database administrator can provide ... MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: sha256_password: Implements basic SHA-256 ...
https://dev.mysql.com/doc/refman/5.7/en/changing-mysql-user.html
On Windows, you can run the server as a Windows service using a normal user account. On Linux, for installations performed using a MySQL repository, RPM packages, or Debian packages, the MySQL server mysqld should be started by the local mysql ...
https://dev.mysql.com/doc/refman/5.7/en/charset-server.html
The server character set and collation are used as default values if the database character set and collation are not specified in CREATE DATABASE statements. MySQL Server has a server character set and a server collation. By default, these are ...