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/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 ...
https://dev.mysql.com/doc/refman/5.7/en/command-line-options.html
Consequently, the following two commands have two completely different meanings: mysql -ptest mysql -p test The first command instructs mysql to use a password value of test, but specifies no default database. The second instructs mysql to prompt ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-files.html
MySQL represents each table by an .frm table format (definition) file in the database directory. For an InnoDB table created in a file-per-table tablespace or general tablespace, table data and associated indexes are stored in a .ibd file in the ...
https://dev.mysql.com/doc/refman/5.7/en/csv-storage-engine.html
When you create a CSV table, the server creates a table format file in the database directory. If you examine the test.CSV file in the database directory created by executing the preceding statements, its contents should look like this: "1","record ... The CSV storage engine stores data in text files using comma-separated values ...
https://dev.mysql.com/doc/refman/5.7/en/derived-tables.html
A derived table is an expression that generates a table within the scope of a query FROM clause. For example, a subquery in a SELECT statement FROM clause is a derived table: SELECT ... The [AS] tbl_name clause is mandatory because every table in a ...
https://dev.mysql.com/doc/refman/5.7/en/document-store-concepts.html
Mogae", "GovernmentForm": "Republic" }, "demographics": { "Population": 1622000, "LifeExpectancy": 39.29999923706055 } } Collection A Collection is a container that may be used to store Documents in a MySQL database. CRUD Operations Create, Read, ...
https://dev.mysql.com/doc/refman/5.7/en/downgrade-before-you-begin.html
The backup should include the mysql database, which contains the MySQL system tables. Review Section 2.11.2, “Downgrade Paths” to ensure that your intended downgrade path is supported. Review Section 2.11.3, “Downgrade Notes” for items that ...