Search Results
https://dev.mysql.com/doc/refman/9.7/en/multiple-server-clients.html
On Unix, set the MYSQL_UNIX_PORT and MYSQL_TCP_PORT environment variables to point to the Unix socket file and TCP/IP port number before you start your clients. If you normally use a specific socket file or port number, you can place commands to set ...Start the client with --protocol=TCP to connect using TCP/IP, --protocol=SOCKET to connect using a Unix socket file, --protocol=PIPE to connect using a named pipe, or --protocol=MEMORY to connect using shared ...
https://dev.mysql.com/doc/heatwave-aws/en/supported-mysql-server-versions.html
Related Topics MySQL Releases: Innovation and LTS Parent topic: MySQL Server Versions . It is ideal for developers and database administrators working in fast-paced environments with high levels of automated tests and modern continuous integration ...
https://dev.mysql.com/doc/refman/9.7/en/mysqldump.html
This option applies only if the server was started with the named_pipe system variable enabled to support named-pipe connections. On Windows, this option applies only if the server was started with the named_pipe system variable enabled to support ...Dumps can be easily imported into a MySQL Server instance or a MySQL HeatWave DB System using the MySQL Shell load dump ... The mysqldump client utility performs logical backups, ...
https://dev.mysql.com/doc/refman/9.7/en/server-side-help-support.html
MySQL Server supports a HELP statement that returns information from the MySQL Reference Manual (see Section 15.8.3, “HELP Statement”). This information is stored in several tables in the mysql schema (see Section 7.3, “The mysql System ...
https://dev.mysql.com/doc/workbench/en/wb-forward-engineering-live-server.html
Use forward engineering to export your schema design to a MySQL server. The first step of the process is to connect to a MySQL server to create the new database schema. Figure 9.45 Forward Engineering Progress You can confirm that the script ...
https://dev.mysql.com/doc/mysql-installer/en/server-file-permission-options.html
Optionally, permissions set on the folders and files located at C:\ProgramData\MySQL\MySQL Server 8.0\Data can be managed during the server configuration operation. If you select this option, you are responsible for securing the Data folder and its ...You have the following options: MySQL Installer can configure the folders and files with full control granted exclusively to the user running the Windows service, if applicable, and to the Administrators ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-server-side-help.html
mysql> help search_string If you provide an argument to the help command, mysql uses it as a search string to access server-side help from the contents of the MySQL Reference Manual. The proper operation of this command requires that the help ...
https://dev.mysql.com/doc/refman/9.7/en/mysqlbinlog.html
Binary log files are encrypted when the server's binlog_encryption system variable is set to ON. This system variable affects the handling of XA transactions, the original_commit_timestamp replication delay timestamp and the original_server_version ...The available algorithms are the same as for the protocol_compression_algorithms system ... The server's binary ...
https://dev.mysql.com/doc/internals/en/required-server-code-patches.html
Currently procedures can only be compiled into the server staticly. The build system is not too clever about creating these symlinks for files added after the first compile ... There is no dynamic procedure for loading them dynamicly yet like we ...
https://dev.mysql.com/doc/refman/9.7/en/optimizing-server.html
This section discusses optimization techniques for the database server, primarily dealing with system configuration rather than tuning SQL statements. The information in this section is appropriate for DBAs who want to ensure performance and ...