NAME mysqldbcompare – Compare Two Databases and Identify Differences SYNOPSIS mysqldbcompare [options] db1 [:db2] … DESCRIPTION This utility compares the objects and data from two databases to find differences. It identifies objects having different definitions in the two databases and presents them in a diff-style format of choice. Differences in the data are shown using…
NAME mysqld_safe – MySQL server startup script SYNOPSIS mysqld_safe options DESCRIPTION mysqld_safe is the recommended way to start a mysqld server on Unix. mysqld_safe adds some safety features such as restarting the server when an error occurs and logging runtime information to an error log. A description of error logging is given later in this…
NAME mysqld_multi – manage multiple MySQL servers SYNOPSIS mysqld_multi [options] {start|stop|report} [GNR[,GNR] …] DESCRIPTION mysqld_multi is designed to manage several mysqld processes that listen for connections on different Unix socket files and TCP/IP ports. It can start or stop servers, or report their current status. Note For some Linux platforms, MySQL installation from RPM or…
NAME mysqlcheck – a table maintenance program SYNOPSIS mysqlcheck [options] [db_name [tbl_name …]] DESCRIPTION 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 with a READ lock only…
NAME mysqlbug – generate bug report SYNOPSIS mysqlbug DESCRIPTION To 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…
NAME mysqlbinlog – utility for processing binary log files SYNOPSIS mysqlbinlog [options] log_file … DESCRIPTION The 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…
NAME 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_FILE DESCRIPTION This 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….
NAME 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] DESCRIPTION This 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…
NAME mysqlcheck – a table maintenance program SYNOPSIS mysqlcheck [options] [db_name [tbl_name …]] DESCRIPTION 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 with a READ lock only…
NAME mysqladmin – client for administering a MySQL server SYNOPSIS mysqladmin [options] command [command-options] [command [command-options]] … DESCRIPTION mysqladmin 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…
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…