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/connection-control-plugin-installation.html
For this purpose, a failed connection attempt is one for which the client user and host match a known MySQL account but the provided credentials are incorrect, or do not match any known account. Determination of the applicable user name and host ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-ndb-comment-options.html
NDB_COLUMN Options In NDB Cluster, a column comment in a CREATE TABLE or ALTER TABLE statement can also be used to specify an NDB_COLUMN option. NDB_TABLE Options For an NDB Cluster table, the table comment in a CREATE TABLE or ALTER TABLE statement ... NDB_COLUMN Options NDB_TABLE Options It is possible to set a number of options specific to NDB Cluster in the table comment or column comments of an NDB ...
https://dev.mysql.com/doc/refman/5.7/en/using-innodb-tables.html
InnoDB tables are created using the CREATE TABLE statement; for example: CREATE TABLE t1 (a INT, b CHAR (20), PRIMARY KEY (a)) ENGINE=InnoDB; The ENGINE=InnoDB clause is not required when InnoDB is defined as the default storage engine, which it is ....frm Files MySQL stores data dictionary information for tables in .frm files in database ...
https://dev.mysql.com/doc/refman/5.7/en/drop-user.html
The DROP USER statement removes one or more MySQL accounts and their privileges. To use DROP USER, you must have the global CREATE USER privilege, or the DELETE privilege for the mysql system database. For example: DROP USER 'jeffrey'@'localhost'; ...It removes privilege rows for the account from all grant ...Attempts to access such objects may ...
https://dev.mysql.com/doc/refman/5.7/en/database-use.html
You can do so by creating tables to hold your data and loading them with the desired information. Use the SHOW statement to find out what databases currently exist on the server: mysql> SHOW DATABASES; +----------+ | Database | +----------+ | mysql ... Once you know how to enter SQL statements, you are ready to access a ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-functions-general-purpose.html
(This constraint rules out the use of the keyring functions for manipulation of instance-wide keys, such as those created by InnoDB to support tablespace encryption.) To enable multiple users to perform operations on the same key, “wrapper” ...A ... MySQL Server supports a keyring service that enables internal server components and plugins to store sensitive information securely for later ...
https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html
If you start the server as root without using --user=mysql, the server may create root-owned files in the data directory, such as log files, and these may cause permission-related problems for future server startups. This enables anyone to connect ...For instructions on assigning a password, see Section 2.9.4, “Securing the Initial MySQL ... If you have never assigned ...
https://dev.mysql.com/doc/refman/5.7/en/stored-objects-security.html
Administrators can prevent users from creating stored objects that specify highly privileged DEFINER accounts by not granting them the SUPER privilege. This remains true if the privileges needed to create the object are revoked from the account of ...If a definition omits the DEFINER attribute, the default object definer is the user who creates ...The DEFINER Attribute The SQL SECURITY Characteristic Examples Orphan Stored Objects Risk-Minimization Guidelines The ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-upgrade.html
An error occurs if a sys schema exists but has no version view, on the assumption that its absence indicates a user-created schema: A sys schema exists with no sys.version view. If you have a user created sys schema, this must be renamed for the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-security-mysql-security-procedures.html
You should also delete the anonymous user account that is installed by default. First and foremost, you should always run a MySQL Server as the mysql operating system user; this is no different from running MySQL in a standard (non-Cluster) ... In ...