The Linux Manuals (man pages) document is an important part of Linux documents. Linux Manuals are organized as several sections. Each section has a group of commands for a specific area in Linux usage, administration or development.
mysqldbcopy – Copy Database Objects Between Servers Synopsis mysqldbcopy [options] db_name [:new_db_name]DescriptionThis utility copies a database on a source server to a database on a destination server. If the source and destination servers are different, the database names can be the same or different. If the source and destination servers are the same, the database…
mysqldbcompare – Compare Two Databases and Identify Differences Synopsis mysqldbcompare [options] db1 [:db2] …DescriptionThis 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 a similar diff-style…
mysqld_safe – MySQL server startup script Synopsis mysqld_safe optionsDescriptionmysqld_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 section. Note For…
mysqld_multi – manage multiple MySQL servers Synopsis mysqld_multi [options] {start|stop|report} [GNR[,GNR] …]Descriptionmysqld_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 Debian packages includes…
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…