PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/group-replication-user-credentials.html
This process can be captured in the binary log and then you can rely on distributed recovery to replicate the statements used to create the user. Alternatively, you can disable binary logging using SET SQL_LOG_BIN=0; and then create the user ...
https://dev.mysql.com/doc/refman/5.7/en/revoke.html
To use this REVOKE syntax, you must have the global CREATE USER privilege, or the UPDATE privilege for the mysql system database. User accounts from which privileges are to be revoked must exist, but the privileges to be revoked need not be ...The ...When the read_only system variable is enabled, REVOKE requires the SUPER privilege in addition to any other required privileges described in the following ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump.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. Because the server creates *.txt files in the directory that you specify, the directory must be ...To reload a dump file, you must have the privileges required to execute the statements that it contains, such as the appropriate CREATE privileges for objects created by those ...
https://dev.mysql.com/doc/refman/5.7/en/downgrading-to-previous-series.html
System Table Changes InnoDB Changes Logging Changes SQL Changes System Table Changes In MySQL 5.7.13, system table columns that store user@host string values were increased in length. Before downgrading to a previous release, change each affected ...
https://dev.mysql.com/doc/refman/5.7/en/sys-user-summary.html
These views summarize statement activity, file I/O, and connections, grouped by user. The user_summary and x$user_summary views have these columns: user The client user name. Rows for which the USER column in the underlying Performance Schema table ...
https://dev.mysql.com/doc/refman/5.7/en/ignoring-user.html
If you get the following error, it means that when mysqld was started or when it reloaded the grant tables, it found an account in the user table that had an invalid password. Found wrong password for user 'some_user'@'some_host'; ignoring user As ...The following list indicates possible causes of and fixes for this problem: You may be running a new version of mysqld with an old user ...
https://dev.mysql.com/doc/refman/5.7/en/show-processlist.html
MySQL reserves one extra connection to be used by accounts that have the SUPER privilege, to ensure that administrators should always be able to connect and check the system (assuming that you are not giving this privilege to all your users). If you ... SHOW [FULL] PROCESSLIST The MySQL process list indicates the operations currently being performed by the set of threads executing within the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-top.html
For more information about MySQL user accounts and passwords, see Section 6.2, “Access Control and Account Management”. This password is associated with a MySQL user account only, and is not related in any way to the password used with encrypted ...Usage ndb_top [-h hostname] [-t port] [-u user] [-p pass] [-n node_id] ndb_top connects to a MySQL Server running as an SQL node of the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-processlist-table.html
The latter distinguishes the system user and regular user account categories (see Account Categories). Note The processlist table is automatically created in the Performance Schema for new installations of MySQL 5.7.39, or higher. If you have the ...The MySQL process list indicates the operations currently being performed by the set of threads executing within the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-users-table.html
The users table contains a row for each user who has connected to the MySQL server. For each user name, the table counts the current and total number of connections. To set the table size explicitly, set the performance_schema_users_size system ...