mysqlcheck – a table maintenance program Synopsis mysqlcheck [options] [db_name [tbl_name …]]DescriptionThe 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 with a READ lock only (see Section 13.3.6,…
mysqlbug – generate bug report Synopsis mysqlbugDescriptionTo report MariaDB bugs, see https://mariadb.com/kb/en/mariadb/reporting-bugs/ – the mysqlbug program has now been deprecated by Oracle, and was never useful for MariaDB. Originally, the program enabled you to generate a bug report and send it to Oracle Corporation. It is a shell script and runs on Unix. The normal…
mysqlbinlog – utility for processing binary log files Synopsis mysqlbinlog [options] log_file …DescriptionThe server’s binary log consists of files containing “events” that describe modifications to database contents. The server writes these files in binary format. To display their contents in text format, use the mysqlbinlog utility. You can also use mysqlbinlog to display the contents…
mysqlauditgrep – Search an audit log Synopsis mysqlauditgrep [OPTIONS]… AUDIT_LOG_FILE mysqlauditgrep –file-stats[–format=FORMAT] AUDIT_LOG_FILE mysqlauditgrep –format=FORMATAUDIT_LOG_FILE mysqlauditgrep [–users=USERS] [–start-date=START_DATE] [–end-date=END_DATE] [–pattern=PATTERN[–regexp]] [–query-type=QUERY_TYPE] [–event-type=EVENT_TYPE] [–status=STATUS] [–format=FORMAT] AUDIT_LOG_FILEDescriptionThis utility allows you to search the current or archived audit logs, allowing you to display data from the audit log file according to the defined search criterion. It also allows…
mysqlauditadmin – Maintain the audit log Synopsis mysqlauditadmin [OPTIONS]… mysqlauditadmin [OPTIONS]… [COMMAND]mysqlauditadmin l=user:pass [at] host:port [OPTIONS]… [COMMAND[–value=VALUE]]mysqlauditadmin –file-stats –audit-log-name=FULL_PATHmysqlauditadmin copy –audit-log-name=FULL_PATH –copy-to=DESTINATION [–remote-login=user:host]DescriptionThis utility allow you to maintain the m[blue]audit logm[][1], allowing you to monitor the audit log file growth and control its rotation. Rotation refers to the action of replacing the current audit log…
mysqlcheck – a table maintenance program Synopsis mysqlcheck [options] [db_name [tbl_name …]]DescriptionThe 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 with a READ lock only (see Section 13.3.6,…
mysqladmin – client for administering a MySQL server Synopsis mysqladmin [options] command [command-options] [command [command-options]] …Descriptionmysqladmin is a client for performing administrative operations. You can use it to check the server’s configuration and current status, to create and drop databases, and more. Invoke mysqladmin like this: shell> mysqladmin [options] command [command-arg] [command [command-arg]] … mysqladmin…
mysqlaccess – client for checking access privileges Synopsis mysqlaccess [host_name [user_name [db_name]]] [options]Descriptionmysqlaccess 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 table, column, or…
mysql_zap – kill processes that match a pattern Synopsis mysql_zap [-signal] [-?Ift] patternDescriptionmysql_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 the ps command…
mysql_waitpid – kill process and wait for its termination Synopsis mysql_waitpid [options] pidwait_timeDescriptionmysql_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 signal 0 to…
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 a future…
mysql_tzinfo_to_sql – load the time zone tables Synopsis mysql_tzinfo_to_sql argumentsDescriptionThe 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 these files is…
mysql_ssl_rsa_setup – create SSL/RSA files Synopsis mysql_ssl_rsa_setup [options]DescriptionThis 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 the existing ones…
mysql_setpermission – interactively set permissions in grant tables Synopsis mysql_setpermission [options]Descriptionmysql_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 like this: shell>…
mysql_secure_installation – improve MySQL installation security Synopsis mysql_secure_installationDescriptionThis 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.• You can remove the test…
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 which plugins…
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 be removed…
mysql_fix_privilege_tables – upgrade MySQL system tables Synopsis mysql_fix_privilege_tables –password=root_passwordDescription 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 to a…
mysql_fix_extensions – normalize table file name extensions Synopsis mysql_fix_extensions data_dirDescriptionmysql_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 .ISM, respectively. This…
mysql_find_rows – extract SQL statements from files Synopsis mysql_find_rows [options] [file_name …]Descriptionmysql_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 such expects statements…