PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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/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/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 ...
https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html
NO_AUTO_CREATE_USER Prevent the GRANT statement from automatically creating new user accounts if it would otherwise do so, unless authentication information is specified. It is preferable to create MySQL accounts with CREATE USER rather than GRANT.
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbd-definition.html
(NDB 7.5.0) This parameter specifies the directory where all files created for metadata, REDO logs, UNDO logs (for Disk Data tables), and data files are placed. The recommended directory hierarchy for NDB Cluster includes /var/lib/mysql-cluster, ...
https://dev.mysql.com/doc/refman/5.7/en/mysqld-multi.html
If the servers that you want to manage have different user names or passwords for the administrative accounts, you might want to create an account on each server that has the same user name and password. For example, you might set up a common ...
https://dev.mysql.com/doc/refman/5.7/en/sys-user-summary-by-statement-type.html
These views summarize informaion about statements executed, grouped by user and statement type. By default, rows are sorted by user and descending total latency. The user_summary_by_statement_type and x$user_summary_by_statement_type views have ...
https://dev.mysql.com/doc/refman/5.7/en/mysqladmin.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. You can use it to check the server's configuration and current status, to create and drop ...
https://dev.mysql.com/doc/refman/5.7/en/set-password.html
SET PASSWORD [FOR user] = password_option password_option: { 'auth_string' | PASSWORD('auth_string') } The SET PASSWORD statement assigns a password to a MySQL user account. = 'auth_string' syntax is not deprecated, but ALTER USER is the preferred ...For example: ALTER USER user IDENTIFIED BY 'auth_string'; Important Under some circumstances, SET PASSWORD may be recorded in server logs or on the client side in a history file such as ~/.mysql_history, which means that cleartext passwords may be read by anyone having read access to that ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-threads-table.html
For foreground threads, the initial INSTRUMENTED value is determined by whether the user account associated with the thread matches any row in the setup_actors table. For foreground threads, the initial HISTORY value is determined by whether the ...