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/account-names.html
Account names appear in SQL statements such as CREATE USER, GRANT, and SET PASSWORD and follow these rules: Account name syntax is 'user_name'@'host_name'. MySQL stores account names in grant tables in the mysql system database using separate ...An ...This section describes the syntax for account names, including special values and wildcard ...
https://dev.mysql.com/doc/refman/5.7/en/request-access.html
For other users, leave all privileges in the user table set to 'N' and grant privileges at more specific levels only (for particular databases, tables, columns, or routines). The user table row for an account indicates the account privileges that ...
https://dev.mysql.com/doc/refman/5.7/en/charset-applications.html
If applications require data storage using a different character set or collation, you can configure character set information several ways: Specify character settings per database. For the per-database or server-startup techniques, the settings ...
https://dev.mysql.com/doc/refman/5.7/en/privileges-provided.html
Privileges granted for the mysql system database itself can be used to change passwords and other access privilege information: Passwords are stored encrypted, so a malicious user cannot simply read them to know the plain text password. Caution ...
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. CURRENT_USER, ...mysql> ...The result value is 0, or NULL for inappropriate arguments such as a NULL or negative repeat ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-config-editor.html
mysql_config_editor provides a print command for displaying the login path file contents, but even in this case, password values are masked so as never to appear in a way that other users can see them. When you use the set command with ...Each ...
https://dev.mysql.com/doc/refman/5.7/en/string-functions-charset.html
This section answers the question: What is the character set and collation of such a string? For simple functions that take string input and return a string result as output, the output's character set and collation are the same as those of the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-install-db.html
For example: bin/mysql_install_db --user=mysql \ --basedir=/opt/mysql/mysql \ --datadir=/opt/mysql/mysql/data Note After mysql_install_db sets up the InnoDB system tablespace, changes to some tablespace characteristics require setting up a whole new ....mysql_secret is created with mode 600 to be accessible only to the operating system user for whom it is ...mysql_install_db handles initialization tasks that must be performed before the MySQL server, ...
https://dev.mysql.com/doc/refman/5.7/en/events-privileges.html
mysql.user.Event_priv is set to 'Y' for a given user only if that user has the global EVENT privilege (that is, if the privilege was bestowed using GRANT EVENT ON *.*). For a schema-level EVENT privilege, GRANT creates a row in mysql.db and sets ...
https://dev.mysql.com/doc/refman/5.7/en/adding-collation.html
The following sections describe how to add user-defined collations of the first two types to existing character sets. Summary of the procedure for adding a new user-defined collation: Choose a collation ID. Note If you modify an existing ...Some of ... A collation is a set of rules that defines how to compare and sort character ...Characters with equal weights compare as equal, and ...