PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-connection-tables.html
The accounts table has USER and HOST columns to track connections per user and host combination. The Performance Schema tracks the connections as follows: The accounts table has four rows, for the user1/hosta, user1/hostb, user2/hosta, and ... When ...Each connection table has CURRENT_CONNECTIONS and TOTAL_CONNECTIONS columns to track the current and total number of connections per “tracking value” on which its statistics are ...
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. For example: [mysqld] user=user_name If your Unix machine itself is not secured, you should assign passwords to the MySQL root account in the grant tables. On ...
https://dev.mysql.com/doc/refman/5.7/en/data-directory-initialization.html
Either create the account if it does not exist (see Create a mysql User and Group), or substitute the name of a different existing login account that you plan to use for running the server. The server creates a 'root'@'localhost' superuser account ...Data Directory Initialization Overview Data Directory Initialization Procedure Server Actions During Data Directory Initialization Post-Initialization root Password Assignment Data Directory Initialization Overview In the examples shown here, the server is intended to run under the user ID of the mysql login ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-secondary-indexes.html
A secondary index may be created on one or more virtual columns or on a combination of virtual columns and regular columns or stored generated columns. When a secondary index is created on a virtual generated column, generated column values are ...A ...
https://dev.mysql.com/doc/refman/5.7/en/document-store-setting-up.html
mysqlxsys@localhost User Account Installing the X Plugin creates a mysqlxsys@localhost user account. If, for some reason, creating the user account fails, the X Plugin installation fails, too. Here is an explanation on what the mysqlxsys@localhost ...The mysqlxsys@localhost account is used by the X Plugin for authentication of external users against the MySQL account system and for killing sessions when requested by a privileged ...
https://dev.mysql.com/doc/refman/5.7/en/sys-create-synonym-db.html
Given a schema name, this procedure creates a synonym schema containing views that refer to all the tables and views in the original schema. This can be used, for example, to create a shorter name by which to refer to a schema with a long name ...
https://dev.mysql.com/doc/refman/5.7/en/error-creating-innodb.html
Initialization Problems If something goes wrong when InnoDB attempts to initialize its tablespace or its log files, delete all files created by InnoDB: all ibdata files and all ib_logfile files. If you already created some InnoDB tables, also delete ... The troubleshooting steps for InnoDB I/O problems depend on when the problem occurs: during startup of the MySQL server, or during normal operations when a DML or DDL statement fails due to problems at the file system ...
https://dev.mysql.com/doc/refman/5.7/en/gis-mysql-specific-functions.html
MySQL provides a set of useful nonstandard functions for creating geometry values. GeometryCollection() with no arguments is permitted as a way to create an empty geometry. The functions described in this section are MySQL extensions to the OpenGIS ...
https://dev.mysql.com/doc/refman/5.7/en/making-windows-dumps.html
The PDB file contains more detailed information about mysqld and other tools that enables more detailed trace and dump files to be created. Program Database files (with suffix pdb) are included in the ZIP Archive Debug Binaries & Test Suite ...
https://dev.mysql.com/doc/refman/5.7/en/validate-password-options-variables.html
validate_password_check_user_name Command-Line Format --validate-password-check-user-name[={OFF|ON}] Introduced 5.7.15 System Variable validate_password_check_user_name Scope Global Dynamic Yes Type Boolean Default Value OFF Whether ...This variable ... This section describes the options, system variables, and status variables that validate_password provides to enable its operation to be configured and ...