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/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. $> groupadd mysql $> useradd -r -g mysql -s /bin/false mysql Note Because the user is required only for ...A ...These include generic binary distributions in the form of compressed tar files (files with a .tar.gz extension) for a number of platforms, and binaries in platform-specific package formats for selected ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlshow.html
--user=user_name, -u user_name Command-Line Format --user=user_name, Type String The user name of the MySQL account to use for connecting to the server. --defaults-extra-file=file_name Command-Line Format --defaults-extra-file=file_name Type File ...
https://dev.mysql.com/doc/refman/5.7/en/implicit-commit.html
This means that a ROLLBACK from the user does not undo CREATE TABLE statements the user made during that transaction. ALTER USER, CREATE USER, DROP USER, GRANT, RENAME USER, REVOKE, SET PASSWORD. ALTER FUNCTION, CREATE FUNCTION and DROP FUNCTION ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-overview.html
However, if no columns are listed in the PARTITION BY KEY or PARTITION BY LINEAR KEY clause of the CREATE TABLE or ALTER TABLE statement used to create or modify a user-partitioned NDB table, then the table is not required to have an explicit ...The ... This section provides a conceptual overview of partitioning in MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/show-grants.html
Note To display nonprivilege information for MySQL accounts, use the SHOW CREATE USER statement. SHOW GRANTS [FOR user] This statement displays the privileges that are assigned to a MySQL user account, in the form of GRANT statements that must be ...SHOW GRANTS requires the SELECT privilege for the mysql system database, except to display privileges for the current ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-table-reference.html
The following table summarizes all available Performance Schema tables. For greater detail, see the individual table descriptions. Table 25.1 Performance Schema Tables Table Name Description Deprecated accounts Connection statistics per client ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-disk-data-objects.html
It is possible to place these elsewhere by specifying either an absolute or relative path as part of the filename when creating the undo log or data file. Statements that create these files are shown later in this section. Create a tablespace; ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-conflict-resolution.html
Conflict resolution in NDB Cluster Replication provides a means of resolving such conflicts by permitting a user-defined resolution column to be used to determine whether or not an update on a given source should be applied on the replica. Some ...
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 ...Stop each server using mysqladmin as shown here, where username is the user name for a MySQL user having sufficient privileges to shut down the server: $> mysqladmin -uusername -p shutdown Then supply this user's password at the ...
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.