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….
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 myproxy-store – store end-entity credential for later retrieval SYNOPSIS myproxy-store [ options ] DESCRIPTION The myproxy-store command uploads a credential to a myproxy-server(8) for later retrieval. The user must have a valid proxy credential as generated by grid-proxy-init or retrieved by myproxy-logon(1) when running this command. Unlike myproxy-init(1), this command transfers the private key…
NAME myproxy-retrieve – retrieve an end-entity credential SYNOPSIS myproxy-retrieve [ options ] DESCRIPTION The myproxy-retrieve command retrieves a credential directly from the myproxy-server(8) that was previously stored using myproxy-init(1) or myproxy-store(1). Unlike myproxy-logon(1), this command transfers the private key in the repository over the network (over a private channel). To obtain a proxy credential, we…
NAME myproxy-logon – retrieve a credential SYNOPSIS myproxy-logon [ options ] myproxy-get-delegation [ options ] DESCRIPTION The myproxy-logon command retrieves a proxy credential from the myproxy-server(8) that was previously stored using myproxy-init(1) or myproxy-store(1). It can also be used to retrieve short-lived end entity credentials from a myproxy-server(8) configured to act as a Certificate Authority….
NAME myproxy-init – store a credential for later retrieval SYNOPSIS myproxy-init [ options ] DESCRIPTION The myproxy-init command uploads a credential to a myproxy-server(8) for later retrieval. In the default mode, the command first prompts for the user’s Grid pass phrase (if needed), which is used to create a proxy credential. The command then prompts…
NAME myproxy-info – display information about MyProxy credentials SYNOPSIS myproxy-info [ options ] DESCRIPTION The myproxy-info command displays information about a user’s credentials previously stored on a myproxy-server(8) using myproxy-init(1). The user must have a valid proxy credential as generated by grid-proxy-init or retrieved by myproxy-logon(1) when running this command. The myproxy-info command provides information…
NAME myproxy-logon – retrieve a credential SYNOPSIS myproxy-logon [ options ] myproxy-get-delegation [ options ] DESCRIPTION The myproxy-logon command retrieves a proxy credential from the myproxy-server(8) that was previously stored using myproxy-init(1) or myproxy-store(1). It can also be used to retrieve short-lived end entity credentials from a myproxy-server(8) configured to act as a Certificate Authority….
NAME myproxy-destroy – remove a credential from the repository SYNOPSIS myproxy-destroy [ options ] DESCRIPTION The myproxy-destroy command removes a credential from the myproxy-server(8) that was previously stored using myproxy-init(1). The user must have a valid proxy credential as generated by grid-proxy-init or retrieved by myproxy-logon(1) when running this command. OPTIONS -h, –help Displays command…
NAME myproxy-change-pass-phrase – change MyProxy passphrase SYNOPSIS myproxy-change-pass-phrase [ options ] DESCRIPTION The myproxy-change-pass-phrase command changes the passphrase under which a credential is protected in the MyProxy repository. The command first prompts for the current passphrase for the credential, then prompts twice for the new passphrase. Only the credential owner can change a credential’s passphrase….
NAME mylvmbackup – a utility for creating MySQL backups using LVM snapshots SYNOPSIS mylvmbackup [OPTIONS] DESCRIPTION mylvmbackup is a tool for quickly creating full physical backups of a MySQL server’s data files. To perform a backup, mylvmbackup obtains a read lock on all tables and flushes all server caches to disk, makes an LVM snapshot…