Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-commands.html
mysql sends each SQL statement that you issue to the server to be executed. There is also a set of commands that mysql itself interprets. For a list of these commands, type help or \h at the mysql> prompt: mysql> help List of all MySQL commands: ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-configurator-cli.html
MySQL Configurator supports GUI (default) and CLI (by passing in --console) modes using the mysql_configurator.exe executable. Note MySQL Configurator CLI functionality was added in MySQL Configurator 9.2.0. Executing MySQL Configurator requires a ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-enterprise-security.html
MySQL Enterprise Edition provides plugins that implement security features using external services: MySQL Enterprise Edition includes an authentication plugin that enables MySQL Server to use LDAP (Lightweight Directory Access Protocol) to ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-migrate-keyring.html
The mysql_migrate_keyring utility migrates keys between one keyring component and another. Invoke mysql_migrate_keyring like this (enter the command on a single line): mysql_migrate_keyring --component-dir=dir_name --source-keyring=name ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-secure-installation.html
This program enables you to improve the security of your MySQL installation in the following ways: You can set a password for root accounts. You can remove root accounts that are accessible from outside the local host. You can remove the test ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlcheck.html
The mysqlcheck client performs table maintenance: It checks, repairs, optimizes, or analyzes tables. Each table is locked and therefore unavailable to other sessions while it is being processed, although for check operations, the table is locked ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump-delimited-text.html
This section describes how to use mysqldump to create delimited-text dump files. For information about reloading such dump files, see Section 9.4.4, “Reloading Delimited-Text Format Backups”. If you invoke mysqldump with the --tab=dir_name ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlshow.html
The mysqlshow client can be used to quickly see which databases exist, their tables, or a table's columns or indexes. The same information can be obtained by using those statements directly. For example, you can issue them from the mysql client ...
https://dev.mysql.com/doc/refman/8.4/en/null-values.html
The NULL value means “no data.” NULL can be written in any lettercase. Be aware that the NULL value is different from values such as 0 for numeric types or the empty string for string types. For text file import or export operations performed ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-storage-layout.html
Once your data reaches a stable size, or a growing table has increased by tens or some hundreds of megabytes, consider using the OPTIMIZE TABLE statement to reorganize the table and compact any wasted space. The reorganized tables require less disk ...