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/audit-log-filter-definitions.html
Table 6.26 Event Class and Subclass Combinations Event Class Event Subclass Description connection connect Connection initiation (successful or unsuccessful) connection change_user User re-authentication with different user/password during session ...An event in the connection class indicates when a connection-related activity occurs during a session, such as a user connecting to or disconnecting from the ...It is ...
https://dev.mysql.com/doc/refman/5.7/en/account-activity-auditing.html
The User and Host column values in this row uniquely identify the account and correspond to the 'user_name'@'host_name' format in which account names are written in SQL statements. Normally, the CURRENT_USER() function can be invoked to determine ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-howto.html
If you are starting with new servers, see Section 16.1.2.2, “Creating a User for Replication” for information about adding a specific user for replication connections and Section 16.1.2.1, “Setting the Replication Source Configuration” for ...Most of the steps that follow require the use of the MySQL root account or another MySQL user account that has the SUPER ...
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/creating-accounts.html
row *************************** CREATE USER for admin@localhost: CREATE USER 'admin'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*67ACDEBDAB923990001F0FFB017EB8ED41861105' REQUIRE NONE PASSWORD EXPIRE DEFAULT ACCOUNT UNLOCK Revoking ...
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/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/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/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/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, ...