PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/data-directory-initialization.html
Within the data directory, the server creates the mysql system database and its tables, including the grant tables, time zone tables, and server-side help tables. These include statements that relate to account management (such as CREATE USER or ...
https://dev.mysql.com/doc/refman/5.7/en/identifier-length.html
This applies to identifiers in table definitions that are stored in .frm files and to identifiers stored in the grant tables in the mysql database. The sizes of the identifier string columns in the grant tables are measured in characters. For ...
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. (Direct modification of grant tables is discouraged, anyway.) For the general query log, password ...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/show-create-user.html
To display the privileges granted to an account, use the SHOW GRANTS statement. The statement requires the SELECT privilege for the mysql system database, except to display information for the current user. SHOW CREATE USER user This statement ...
https://dev.mysql.com/doc/refman/5.7/en/create-event.html
As granting such privileges entails a potential for abuse, extreme care must be taken in doing so. CREATE EVENT requires the EVENT privilege for the schema in which the event is to be created. If the DEFINER clause is present, the privileges ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-restore.html
For more information, see Section 21.6.13, “Distributed Privileges Using Shared Grant Tables”. (In other words, you should start the data nodes with --initial prior to performing the restore.) --restore-privilege-tables Command-Line Format ...
https://dev.mysql.com/doc/refman/5.7/en/docker-mysql-more-topics.html
If a user name and a password are supplied with MYSQL_USER and MYSQL_PASSWORD, the user is created and granted superuser access to this database (corresponding to GRANT ALL). MYSQL_USER, MYSQL_PASSWORD: These variables are used in conjunction to ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-preparation.html
Preparing the NDB Cluster for replication consists of the following steps: Check all MySQL servers for version compatibility (see Section 21.7.2, “General Requirements for NDB Cluster Replication”). To provide replication backup capability, you ...
https://dev.mysql.com/doc/refman/5.7/en/programs-overview.html
mysql_install_db This program initializes the MySQL data directory, creates the mysql database and initializes its grant tables with default privileges, and sets up the InnoDB system tablespace. It updates the grant tables with any changes that have ...Later sections provide a more detailed description of each one, with the exception of NDB Cluster ...
https://dev.mysql.com/doc/refman/5.7/en/security.html
These include choosing good passwords, not granting unnecessary privileges to users, ensuring application security by preventing SQL injections and data corruption, and others. Access control and security within the database system itself, including ... When thinking about security within a MySQL installation, you should consider a wide range of possible topics and how they affect the security of your MySQL server and related applications: General factors that affect ...