Search Results
https://dev.mysql.com/doc/refman/8.4/en/reproducible-test-case.html
If you encounter corrupted MyISAM tables or if mysqld always fails after some update statements, you can test whether the issue is reproducible by doing the following: Stop the MySQL daemon with mysqladmin shutdown. Remove (or move away) any old log ...For information about steps to take when encountering InnoDB table corruption, see Section 1.6, “How to Report Bugs or ...
https://dev.mysql.com/doc/refman/8.4/en/reserved-accounts.html
One part of the MySQL installation process is data directory initialization (see Section 2.9.1, “Initializing the Data Directory”). During data directory initialization, MySQL creates user accounts that should be considered reserved: ...This ...
https://dev.mysql.com/doc/refman/8.4/en/security.html
When thinking about security within a MySQL installation, you should consider a wide range of possible topics and how they affect the security of your MySQL server and related applications: General factors that affect security. The security is ...
https://dev.mysql.com/doc/refman/8.4/en/selinux.html
MySQL SELinux policy modules, for example, define policy rules using type information. mysqld_db_t is the type associated with the MySQL data directory and its files. Security-Enhanced Linux (SELinux) is a mandatory access control (MAC) system that ...
https://dev.mysql.com/doc/refman/8.4/en/setting-environment-variables.html
Section 6.9, “Environment Variables”, lists all environment variables that affect MySQL program operation. For example, on Windows, you can set the USER variable to specify your MySQL account name. Suppose that you want to specify the TCP/IP ...
https://dev.mysql.com/doc/refman/8.4/en/show-create-view.html
MySQL lets you use different sql_mode settings to tell the server the type of SQL syntax to support. For example, you might use the ANSI SQL mode to ensure MySQL correctly interprets the standard SQL concatenation operator, the double bar (||), in ... SHOW CREATE VIEW view_name This statement shows the CREATE VIEW statement that creates the named ...
https://dev.mysql.com/doc/refman/8.4/en/show-replica-status.html
If you issue this statement using the mysql client, you can use a \G statement terminator rather than a semicolon to obtain a more readable vertical layout: mysql> SHOW REPLICA STATUS\G *************************** 1. Internally, the state of this ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-aggregate-functions.html
MySQL supports aggregate functions that perform a calculation on a set of values. For general information about these functions, see Section 14.19.1, “Aggregate Function Descriptions”. ST_Collect() can be used as a window function, as signified ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-reference-systems.html
The SRS denoted in MySQL by SRID 0 represents an infinite flat Cartesian plane with no units assigned to its axes. SRID 0 is the default SRID for spatial data in MySQL. MySQL maintains information about available spatial reference systems for ... A ...
https://dev.mysql.com/doc/refman/8.4/en/subquery-optimization-with-exists.html
WHERE subquery_where) MySQL evaluates queries “from outside to inside.” That is, it first obtains the value of the outer expression outer_expr, and then runs the subquery and captures the rows that it produces. WHERE subquery_where AND ...