Search Results
https://dev.mysql.com/doc/refman/8.4/en/can-not-connect-to-server.html
Locate the following key in the registry: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters On the Edit menu, click Add Value, and then add the following registry value: Value Name: MaxUserPort Data Type: REG_DWORD Value: 65534 ... A MySQL client on Unix can connect to the mysqld server in two different ways: By using a Unix socket file to connect through a file in the file system (default /tmp/mysql.sock), or by using TCP/IP, which connects through a port ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-component-functions.html
When a dictionary of terms is created, it becomes part of the dictionary registry and is assigned a name to be used by other dictionary functions. All of the terms in a dictionary are accessible to any user account if that user executes ...
https://dev.mysql.com/doc/refman/8.4/en/explain-extended.html
For results consisting of multiple values, a temporary table may be created and <temporary table> is shown instead. <in_optimizer>(query fragment) This is an internal optimizer object with no user significance. <ref_null_helper>(expr) This is an ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-fine-tuning.html
Note Minimum and maximum word length full-text parameters do not apply to FULLTEXT indexes created using the ngram parser. For an example specific to full-text indexing, see Section 14.9.7, “Adding a User-Defined Collation for Full-Text ...You can ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-introduction.html
Unless you have configured a different default storage engine, issuing a CREATE TABLE statement without an ENGINE clause creates an InnoDB table. Key Advantages of InnoDB Its DML operations follow the ACID model, with transactions featuring commit, ... InnoDB is a general-purpose storage engine that balances high reliability and high ...
https://dev.mysql.com/doc/refman/8.4/en/ipv6-remote-connections.html
mysql> SELECT CURRENT_USER(), @@bind_address; +-----------------------------------+----------------+ | CURRENT_USER() | @@bind_address | +-----------------------------------+----------------+ | remoteipv6user@2001:db8:0:f101::2 | :: | ... The ...
https://dev.mysql.com/doc/refman/8.4/en/ipv6-support.html
IPv6 addresses can be specified in account names in statements such as CREATE USER, GRANT, and REVOKE. For example: mysql> CREATE USER 'bill'@'::1' IDENTIFIED BY 'secret'; mysql> GRANT SELECT ON mydb.* TO 'bill'@'::1'; IPv6 functions enable ...
https://dev.mysql.com/doc/refman/8.4/en/json-validation-functions.html
In this example, we set a user variable @schema to the value of a JSON schema for geographical coordinates, and another one @document to the value of a JSON document containing one such coordinate. In this example, we set a user variable @schema to ... MySQL supports validation of JSON documents against JSON schemas conforming to Draft 4 of the JSON Schema ...
https://dev.mysql.com/doc/refman/8.4/en/ldml-collation-example.html
The collation is designed for a scenario involving a Web application for which users post their names and phone numbers. You can check the variable value as follows, although the path name might be different on your system: mysql> SHOW VARIABLES ...
https://dev.mysql.com/doc/refman/8.4/en/loadable-function-reference.html
The following table lists each function that is loadable at runtime and provides a short description of each one. For a table listing built-in functions and operators, see Section 14.1, “Built-In Function and Operator Reference” For general ...