PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-connection-tables.html
It removes rows for accounts, hosts, or users with no connections, and resets the summary columns to zero for the remaining rows. The Performance Schema also counts internal threads and threads for user sessions that failed to authenticate, using ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-collation-character-set-applicability-table.html
The COLLATION_CHARACTER_SET_APPLICABILITY table indicates what character set is applicable for what collation. CHARACTER_SET_NAME The name of the character set with which the collation is associated. Notes The COLLATION_CHARACTER_SET_APPLICABILITY ...
https://dev.mysql.com/doc/refman/5.7/en/data-directory-initialization.html
For example (enter the command on a single line): bin/mysqld --initialize --user=mysql --basedir=/opt/mysql/mysql --datadir=/opt/mysql/mysql/data Alternatively, put the relevant option settings in an option file and pass the name of that file to ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-installer-change-path-proc.html
To change paths for MySQL server Identify the MySQL server to change and enable the Advanced Options link as follows: Navigate to the Select Products page by doing one of the following: If this is an initial setup of MySQL Installer, select the ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-utf16le.html
This is the same as utf16 but is little-endian rather than big-endian.
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-security-mysql-security-procedures.html
First and foremost, you should always run a MySQL Server as the mysql operating system user; this is no different from running MySQL in a standard (non-Cluster) environment. Alternatively, you can start the MySQL server process with --user=mysql on ...You should also delete the anonymous user account that is installed by ...In general, any standard procedure for running ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-threads-table.html
For foreground threads, the initial INSTRUMENTED value is determined by whether the user account associated with the thread matches any row in the setup_actors table. setup_actors is not consulted because there is no associated user for background ...row *************************** THREAD_ID: 51 NAME: thread/sql/one_connection TYPE: FOREGROUND PROCESSLIST_ID: 34 PROCESSLIST_USER: isabella PROCESSLIST_HOST: localhost PROCESSLIST_DB: performance_schema PROCESSLIST_COMMAND: Query PROCESSLIST_TIME: 0 PROCESSLIST_STATE: Sending data PROCESSLIST_INFO: SELECT * FROM performance_schema.threads PARENT_THREAD_ID: 1 ROLE: NULL INSTRUMENTED: YES HISTORY: YES CONNECTION_TYPE: SSL/TLS THREAD_OS_ID: 755399 ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-nutshell.html
MySQL now enables database administrators to establish a policy for automatic password expiration: Any user who connects to the server using an account for which the password is past its permitted lifetime must change the password. = 'auth_string' ...(The server writes the random password to the error log.) Installation creates no anonymous-user ...The server now requires account rows in the ...
https://dev.mysql.com/doc/refman/5.7/en/connection-options.html
--user=user_name, -u user_name Command-Line Format --user=user_name Type String The user name of the MySQL account to use for connecting to the server. To require use of encrypted connections by a MySQL account, use CREATE USER to create the account ...--password[=pass_val], -p[pass_val] Command-Line Format --password[=password] Type String Default Value [none] The password of the MySQL account used for connecting to the ...Command Options for Connection Establishment Command ...
https://dev.mysql.com/doc/refman/5.7/en/connecting.html
For a client program to connect to the MySQL server, it must use the proper connection parameters, such as the name of the host where the server is running and the user name and password of your MySQL account. Examples: mysql --host=localhost ...To ...The default user name is ODBC on Windows or your Unix login name on ... This section describes use of command-line options to specify how to ...Each connection parameter has ...