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/starting-server.html
It is important that the MySQL server be run using an unprivileged (non-root) login account. For further instructions for running MySQL as an unprivileged user, see Section 6.1.5, “How to Run MySQL as a Normal User”. If the server is unable to ... This section describes how start the server on Unix and Unix-like ...
https://dev.mysql.com/doc/refman/5.7/en/validate-password.html
This applies to the ALTER USER, CREATE USER, GRANT, and SET PASSWORD statements, and passwords given as arguments to the PASSWORD() function. Note For statements that assign, modify, or generate account passwords (ALTER USER, CREATE USER, GRANT, and ... The validate_password plugin serves to improve security by requiring account passwords and enabling strength testing of potential ...
https://dev.mysql.com/doc/refman/5.7/en/windows-start-command-line.html
The command connects as the MySQL root user, which is the default administrative account in the MySQL grant system. Note Users in the MySQL grant system are wholly independent from any operating system users under Microsoft Windows. The MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-schemata-table.html
The following statements are equivalent: SELECT SCHEMA_NAME AS `Database` FROM INFORMATION_SCHEMA.SCHEMATA [WHERE SCHEMA_NAME LIKE 'wild'] SHOW DATABASES [LIKE 'wild'] You see only those databases for which you have some kind of privilege, unless ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-variable-table-migration.html
Migration and Privileges Initially, with the introduction of Performance Schema system and status variable tables in MySQL 5.7.6, access to those tables required the SELECT privilege, just as for other Performance Schema tables. However, this had ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-stored-procs.html
If replication or binary logging in general (for the purpose of point-in-time recovery) is active, then MySQL DBAs have two security options open to them: Any user wishing to create stored functions must be granted the SUPER privilege. Where can I ...
https://dev.mysql.com/doc/refman/5.7/en/function-loading.html
For this reason, CREATE FUNCTION requires the INSERT privilege for the mysql system database. If the server is started with the --skip-grant-tables option, functions registered in the table are not loaded and are unavailable. For this reason, DROP ... Loadable functions, as the name implies, must be loaded into the server before they can be ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-user-credentials.html
mysql> CREATE USER rpl_user@'%' IDENTIFIED BY 'password'; mysql> GRANT REPLICATION SLAVE ON *.* TO rpl_user@'%'; mysql> FLUSH PRIVILEGES; If binary logging was disabled, enable it again once the user has been created using SET SQL_LOG_BIN=1;. Group ...
https://dev.mysql.com/doc/refman/5.7/en/unix-signal-response.html
This is like executing a SHUTDOWN statement without having to connect to the server (which for shutdown requires an account that has the SHUTDOWN privilege). SIGHUP causes the server to reload the grant tables and to flush tables, logs, the thread ... On Unix and Unix-like systems, a process can be the recipient of signals sent to it by the root system account or the system account that owns the ...
https://dev.mysql.com/doc/refman/5.7/en/create-table.html
As of MySQL 5.7.17, you must have the FILE privilege to use the DATA DIRECTORY or INDEX DIRECTORY table option. You must have SELECT, UPDATE, and DELETE privileges for the tables you map to a MERGE table. As of MySQL 5.7.17, you must have the FILE ...| {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ...