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/sys-schema-object-index.html
The following tables list sys schema objects and provide a short description of each one.
https://dev.mysql.com/doc/refman/5.7/en/create-event.html
CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON SLAVE] [COMMENT 'string'] DO event_body; schedule: { AT timestamp [+ INTERVAL interval] ... If the DEFINER ...The event does not run unless the Event Scheduler is ...
https://dev.mysql.com/doc/refman/5.7/en/linux-installation-rpm.html
Notes The mysql user is created using the -r and -s /bin/false options of the useradd command, so that it does not have login permissions to your server host (see Creating the mysql User and Group for details). To switch to the mysql user on your ...
https://dev.mysql.com/doc/refman/5.7/en/password-logging.html
Passwords can be written as plain text in SQL statements such as CREATE USER, GRANT, SET PASSWORD, and statements that invoke the PASSWORD() function. Statement logging avoids writing passwords as cleartext for the following statements: CREATE USER ...If such statements are logged by the MySQL server as written, passwords in them become visible to anyone with access to the ...
https://dev.mysql.com/doc/refman/5.7/en/encryption-functions.html
This function is the SQL interface to the algorithm used by the server to encrypt MySQL passwords for storage in the mysql.user grant table. It also influences password hashing performed by CREATE USER and GRANT statements that specify a password ...
https://dev.mysql.com/doc/refman/5.7/en/starting-server.html
Such problems can occur if you neglected to create the grant tables by initializing the data directory before proceeding to this step, or if you ran the command that initializes the data directory without the --user option. Start the MySQL server ...
https://dev.mysql.com/doc/refman/5.7/en/binary-installation.html
Create a mysql User and Group If your system does not already have a user and group to use for running mysqld, you may need to create them. The following commands add the mysql group and the mysql user. You might want to call the user and group ...
https://dev.mysql.com/doc/refman/5.7/en/expired-password-handling.html
MySQL provides password-expiration capability, which enables database administrators to require that users reset their password. For example: ALTER USER 'myuser'@'localhost' PASSWORD EXPIRE; For each connection that uses an account with an expired ...Passwords can be expired manually, and on the basis of a policy for automatic expiration (see Section 6.2.11, “Password ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-logs-cluster-log.html
NDBStopForced StartUp 1 ALERT Node node_id: Node shutdown aborted The node shutdown process was aborted by the user. Error: error_code The backup was terminated after starting, possibly due to user intervention BackupAborted Backup 7 ALERT . The ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-memory-summary-tables.html
Event names refer to names of event instruments in the setup_instruments table: memory_summary_by_account_by_event_name has USER, HOST, and EVENT_NAME columns. Each row summarizes events for a given account (user and host combination) and event name. Each row summarizes events for a given user and event ...Operation counts help to understand or tune the overall pressure the server is putting ...