PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/problems-connecting.html
Check this by executing mysql -u root mysql and issuing this SQL statement: SELECT * FROM user; The result should include a row with the Host and User columns matching your client's host name and your MySQL user name. After trying to connect from ...
https://dev.mysql.com/doc/refman/8.0/en/query-log.html
In addition, the query log may contain statements that only select data while such statements are never written to the binary log. To specify the log destination, use the log_output system variable (as described in Section 7.4.1, “Selecting ...
https://dev.mysql.com/doc/refman/8.0/en/replication-asynchronous-connection-failover.html
The list of potential source servers is stored on the replica, and in the event of a connection failure, a new source is selected from the list based on a weighted priority that you set. Beginning with MySQL 8.0.22, you can use the asynchronous ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-create-if-not-exists.html
Similarly, every CREATE TABLE IF NOT EXISTS statement without a SELECT is replicated, whether or not the table already exists on the source. SELECT follows somewhat different rules; see Section 19.5.1.7, “Replication of CREATE TABLE ... IF NOT ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-row-searches.html
If there are suitable indexes, one index is selected from the candidates, in the following priority order: A primary key. If the algorithm is able to select a primary key or a unique index where every column in the index has a NOT NULL attribute, it ... When a replica using row-based replication format applies an UPDATE or DELETE operation, it must search the relevant table for the matching ...
https://dev.mysql.com/doc/refman/8.0/en/resetting-permissions.html
For a server that is running as a Windows service, go to the Services manager: From the Start menu, select Control Panel, then Administrative Tools, then Services. Open a console window to get to the command prompt: From the Start menu, select Run, ... If you have never assigned a root password for MySQL, the server does not require a password at all for connecting as ...
https://dev.mysql.com/doc/refman/8.0/en/show-errors.html
The LIMIT clause has the same syntax as for the SELECT statement. You can also retrieve this number from the error_count variable: SHOW COUNT(*) ERRORS; SELECT @@error_count; SHOW ERRORS and error_count apply only to errors, not warnings or notes.
https://dev.mysql.com/doc/refman/8.0/en/show-processlist.html
db The default database for the thread, or NULL if none has been selected. For example, if a CALL statement executes a stored procedure that is executing a SELECT statement, the Info value shows the SELECT statement. SHOW [FULL] PROCESSLIST ...
https://dev.mysql.com/doc/refman/8.0/en/show-table-status.html
The WHERE clause can be given to select rows using more general conditions, as discussed in Section 28.8, “Extensions to SHOW Statements”. In such cases, use SELECT COUNT(*) to obtain an accurate count. A more accurate method of obtaining this ... SHOW TABLE STATUS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLE STATUS works likes SHOW TABLES, but provides a lot of information about each non-TEMPORARY ...
https://dev.mysql.com/doc/refman/8.0/en/show-variables.html
A WHERE clause can be given to select rows using more general conditions, as discussed in Section 28.8, “Extensions to SHOW Statements”. For variables with very long values that are not completely displayed, use SELECT as a workaround. For ...