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/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/performance-schema-thread-filtering.html
For foreground threads (resulting from client connections), the initial values of the INSTRUMENTED and HISTORY columns in threads table rows are determined by whether the user account associated with a thread matches any row in the setup_actors ...
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/docker-mysql-more-topics.html
MYSQL_USER, MYSQL_PASSWORD: These variables are used in conjunction to create a user and set that user's password, and the user is granted superuser permissions for the database specified by the MYSQL_DATABASE variable. MYSQL_RANDOM_ROOT_PASSWORD: ...In the following example, we run the mysql client from inside the myapp1 container to connect to host mysql1 in its own container: docker exec -it myapp1 mysql --host=mysql1 --user=myuser --password For other networking techniques for containers, see the Docker container networking section in the Docker ...A MySQL Docker installation is different from a common, non-Docker installation in the following aspects: Included binaries are ...
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-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/create-procedure.html
For each OUT or INOUT parameter, pass a user-defined variable in the CALL statement that invokes the procedure so that you can obtain its value when the procedure returns. The user who invokes the routine must have the EXECUTE privilege for it, as ...If the DEFINER clause is present, the privileges required depend on the user value, as discussed in Section 23.6, “Stored Object Access ...
https://dev.mysql.com/doc/refman/5.7/en/mysqladmin.html
On some systems, your password becomes visible to system status programs such as ps that may be invoked by other users to display command lines. --defaults-extra-file=file_name Command-Line Format --defaults-extra-file=file_name Type File name Read ...To kill threads belonging to other users, the connected user must have the SUPER ...You can use it to check ...
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 ...