Section 1: user commands and tools
NAME mysqlaccess – client for checking access privileges SYNOPSIS mysqlaccess [host_name [user_name [db_name]]] [options] DESCRIPTION mysqlaccess is a diagnostic tool written by Yves Carlier. It checks the access privileges for a host name, user name, and database combination. Note that mysqlaccess checks access using only the user, db, and host tables. It does not check…
NAME mysql_zap – kill processes that match a pattern SYNOPSIS mysql_zap [-signal] [-?Ift] pattern DESCRIPTION mysql_zap kills processes that match a pattern. It uses the ps command and Unix signals, so it runs on Unix and Unix-like systems. Invoke mysql_zap like this: shell> mysql_zap [-signal] [-?Ift] pattern A process matches if its output line from…
NAME mysql_waitpid – kill process and wait for its termination SYNOPSIS mysql_waitpid [options] pidwait_time DESCRIPTION mysql_waitpid signals a process to terminate and waits for the process to exit. It uses the kill() system call and Unix signals, so it runs on Unix and Unix-like systems. Invoke mysql_waitpid like this: shell> mysql_waitpid [options] pidwait_time mysql_waitpid sends…
NAME mysql_upgrade – check and upgrade MySQL tables SYNOPSIS mysql_upgrade [options] DESCRIPTION Note As of MySQL 8.0.16, the MySQL server performs the upgrade tasks previously handled by mysql_upgrade (for details, see Section 2.11.3, “What the MySQL Upgrade Process Upgrades”). Consequently, mysql_upgrade is unneeded and is deprecated as of that version, and will be removed in…
NAME mysql_tzinfo_to_sql – load the time zone tables SYNOPSIS mysql_tzinfo_to_sql arguments DESCRIPTION The mysql_tzinfo_to_sql program loads the time zone tables in the mysql database. It is used on systems that have a zoneinfo database (the set of files describing time zones). Examples of such systems are Linux, FreeBSD, Solaris, and macOS. One likely location for…
NAME mysql_ssl_rsa_setup – create SSL/RSA files SYNOPSIS mysql_ssl_rsa_setup [options] DESCRIPTION This program creates the SSL certificate and key files and RSA key-pair files required to support secure connections using SSL and secure password exchange using RSA over unencrypted connections, if those files are missing. mysql_ssl_rsa_setup can also be used to create new SSL files if…
NAME mysql_setpermission – interactively set permissions in grant tables SYNOPSIS mysql_setpermission [options] DESCRIPTION mysql_setpermission is a Perl script that was originally written and contributed by Luuk de Boer. It interactively sets permissions in the MariaDB grant tables. mysql_setpermission is written in Perl and requires that the DBI and DBD::mysql Perl modules be installed. Invoke mysql_setpermission…
NAME mysql_secure_installation – improve MySQL installation security SYNOPSIS mysql_secure_installation DESCRIPTION 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 anonymous-user accounts….
NAME mysql_plugin – configure MySQL server plugins SYNOPSIS mysql_plugin [options] plugin {ENABLE|DISABLE} DESCRIPTION Note mysql_plugin is deprecated as of MySQL 5.7.11 and removed in MySQL 8.0. Alternatives include loading plugins at server startup using the –plugin-load or –plugin-load-add option, or at runtime using the INSTALL PLUGIN statement. The mysql_plugin utility enables MySQL administrators to manage…
NAME mysql_install_db – initialize MySQL data directory SYNOPSIS mysql_install_db [options] DESCRIPTION Note mysql_install_db is deprecated as of MySQL 5.7.6 because its functionality has been integrated into mysqld, the MySQL server. To initialize a MySQL installation, invoke mysqld with the –initialize or –initialize-insecure option. For more information, see Section 2.10.1, “Initializing the Data Directory”. mysql_install_db will…
NAME mysql_fix_privilege_tables – upgrade MySQL system tables SYNOPSIS mysql_fix_privilege_tables –password=root_password DESCRIPTION Note In MySQL 5.1.7, mysql_fix_privilege_tables was superseded by mysql_upgrade, which should be used instead. See mysql_upgrade(1). Some releases of MySQL introduce changes to the structure of the system tables in the mysql database to add new privileges or support new features. When you update…
NAME mysql_fix_extensions – normalize table file name extensions SYNOPSIS mysql_fix_extensions data_dir DESCRIPTION mysql_fix_extensions converts the extensions for MyISAM (or ISAM) table files to their canonical forms. It looks for files with extensions matching any lettercase variant of .frm, .myd, .myi, .isd, and .ism and renames them to have extensions of .frm, .MYD, .MYI, .ISD, and…
NAME mysql_find_rows – extract SQL statements from files SYNOPSIS mysql_find_rows [options] [file_name …] DESCRIPTION mysql_find_rows reads files containing SQL statements and extracts statements that match a given regular expression or that contain USE db_name or SET statements. The utility was written for use with update log files (as used prior to MySQL 5.0) and as…
NAME mysql – the MySQL command-line client SYNOPSIS mysql [options] db_name DESCRIPTION mysql is a simple SQL shell with input line editing capabilities. It supports interactive and noninteractive use. When used interactively, query results are presented in an ASCII-table format. When used noninteractively (for example, as a filter), the result is presented in tab-separated format….
NAME mysql_convert_table_format – convert tables to use a given storage engine SYNOPSIS mysql_convert_table_format [options] db_name DESCRIPTION mysql_convert_table_format converts the tables in a database to use a particular storage engine (MyISAM by default). mysql_convert_table_format is written in Perl and requires that the DBI and DBD::mysql Perl modules be installed (see Section 2.15, “Perl Installation Notes”). Invoke…
NAME mysql_config_editor – configure authentication information for connecting to MySQL server SYNOPSIS mysql_config_editor options command DESCRIPTION The mysql_config_editor utility enables you to store authentication credentials in an obfuscated login path file named .mylogin.cnf. The file location is the %APPDATA%\MySQL directory on Windows and the current user’s home directory on non-Windows systems. The file can be…
NAME mysql_config – get compile options for compiling clients SYNOPSIS mysql_config options DESCRIPTION mysql_config provides you with useful information for compiling your MariaDB client and connecting it to MariaDB. mysql_config supports the following options. • –cflags Compiler flags to find include files and critical compiler flags and defines used when compiling the libmysqlclient library. The…
NAME mysql_client_test – test client API mysql_client_test_embedded – test client API for embedded server SYNOPSIS mysql_client_test [options] [test_name] … mysql_client_test_embedded [options] [test_name] … DESCRIPTION The mysql_client_test program is used for testing aspects of the MariaDB client API that cannot be tested using mysqltest and its test language. mysql_client_test_embedded is similar but used for testing the…
NAME mysql_client_test – test client API mysql_client_test_embedded – test client API for embedded server SYNOPSIS mysql_client_test [options] [test_name] … mysql_client_test_embedded [options] [test_name] … DESCRIPTION The mysql_client_test program is used for testing aspects of the MariaDB client API that cannot be tested using mysqltest and its test language. mysql_client_test_embedded is similar but used for testing the…
mysql.server – MariaDB server startup script Synopsis mysql {start|stop} Description MariaDB distributions on Unix include a script named mysql.server. It can be used on systems such as Linux and Solaris that use System V-style run directories to start and stop system services. It is also used by the Mac OS X Startup Item for MariaDB….