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/show-create-user.html
SHOW CREATE USER user This statement shows the CREATE USER statement that creates the named user. The statement requires the SELECT privilege for the mysql system database, except to display information for the current user. It is also possible to ...To name the account, use the format described in Section 6.2.4, “Specifying Account ...
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/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 ...Check whether the Password column of that table is shorter than 16 ...
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
To kill threads belonging to other users, the connected user must have the SUPER privilege. On some systems, your password becomes visible to system status programs such as ps that may be invoked by other users to display command lines. Caution Do ...You can use it to check the server's configuration and current status, to create and drop databases, and ...
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/load-xml.html
To prevent a client from loading XML files from the server, do not grant the FILE privilege to the corresponding MySQL user account, or revoke this privilege if the client user account already has it. Important Revoking the FILE privilege (or not ...
https://dev.mysql.com/doc/refman/5.7/en/connection-options.html
In addition, the user making the connection must be a member of the Windows group specified by the named_pipe_full_access_group system variable. In addition, the user making the connection must be a member of the Windows group specified by the ...
https://dev.mysql.com/doc/refman/5.7/en/sys-user-summary-by-statement-latency.html
The user_summary_by_statement_latency and x$user_summary_by_statement_latency views have these columns: user The client user name. Rows for which the USER column in the underlying Performance Schema table is NULL are assumed to be for background ...
https://dev.mysql.com/doc/refman/5.7/en/password-security-user.html
MySQL users should use the following guidelines to keep passwords secure. When you run a client program to connect to the MySQL server, it is inadvisable to specify your password in a way that exposes it to discovery by other users. On some ...The ...