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/information-functions.html
mysql> SELECT CHARSET('abc'); -> 'latin1' mysql> SELECT CHARSET(CONVERT('abc' USING utf8)); -> 'utf8' mysql> SELECT CHARSET(USER()); -> 'utf8' COERCIBILITY(str) Returns the collation coercibility value of the string argument. mysql> SELECT ...It may ...
https://dev.mysql.com/doc/refman/5.7/en/user-variables.html
You can store a value in a user-defined variable in one statement and refer to it later in another statement. User variables are written as @var_name, where the variable name var_name consists of alphanumeric characters, ., _, and $. A user ...This ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-filtering.html
To grant the SUPER privilege to a user account, use this statement: GRANT SUPER ON *.* TO user; Alternatively, should you prefer to avoid granting the SUPER privilege while still permitting users to access specific filtering functions, “wrapper” ...Multiple filters can be defined, and any given filter can be assigned to any number of user ... Note As of MySQL 5.7.13, for audit log filtering to work as ...
https://dev.mysql.com/doc/refman/5.7/en/socket-pluggable-authentication.html
The plugin uses the SO_PEERCRED socket option to obtain information about the user running the client program. To uninstall it, use UNINSTALL PLUGIN: UNINSTALL PLUGIN auth_socket; Using Socket Pluggable Authentication The socket plugin checks ...
https://dev.mysql.com/doc/refman/5.7/en/drop-user.html
The DROP USER statement removes one or more MySQL accounts and their privileges. It removes privilege rows for the account from all grant tables. To use DROP USER, you must have the global CREATE USER privilege, or the DELETE privilege for the mysql ...An error occurs if you try to drop an account that does not ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-config-editor.html
The file location is the %APPDATA%\MySQL directory on Windows and the current user's home directory on non-Windows systems. Each option group in .mylogin.cnf is called a “login path,” which is a group that permits only certain options: host, ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-install-db.html
By default, the file is .mysql_secret in the home directory of the effective user running the script. .mysql_secret is created with mode 600 to be accessible only to the operating system user for whom it is created. Because the MySQL server, mysqld, ... Note mysql_install_db is deprecated as of MySQL 5.7.6 because its functionality has been integrated into mysqld, the MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/option-defaults-equals.html
Consider the following example, where a user connects to a MySQL server running on host tonfisk as user jon: $> mysql --host 85.224.35.45 --user jon Welcome to the MySQL monitor. Suppose the my.cnf file is as shown here: [mysql] user jon Trying to ...Due to this behavior, problems can occasionally arise when no value is provided for an option that expects ...
https://dev.mysql.com/doc/refman/5.7/en/password-management.html
Password Expiration Policy To expire an account password manually, use the ALTER USER statement: ALTER USER 'jeffrey'@'localhost' PASSWORD EXPIRE; This operation marks the password expired in the corresponding mysql.user system table row. The ...
https://dev.mysql.com/doc/refman/5.7/en/changing-mysql-user.html
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 Windows, you can run the server as a Windows service using a normal user account. On ...