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.
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…
mysql – the MySQL command-line client Synopsis mysql [options] db_nameDescriptionmysql 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. The output format…
mysql_convert_table_format – convert tables to use a given storage engine Synopsis mysql_convert_table_format [options] db_nameDescriptionmysql_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 mysql_convert_table_format like this:…
mysql_config_editor – configure authentication information for connecting to MySQL server Synopsis mysql_config_editor options commandDescriptionThe 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 read later by…
mysql_config – get compile options for compiling clients Synopsis mysql_config optionsDescriptionmysql_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 options returned are…
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] …DescriptionThe 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 embedded server. Both…
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] …DescriptionThe 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 embedded server. Both…
mysql.server – MariaDB server startup script Synopsis mysql {start|stop}DescriptionMariaDB 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. mysql.server can…
mysql – the MySQL command-line client Synopsis mysql [options] db_nameDescriptionmysql 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. The output format…
myproxy-store – store end-entity credential for later retrieval Synopsismyproxy-store [ options ] DescriptionThe 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 over the network…
myproxy-retrieve – retrieve an end-entity credential Synopsismyproxy-retrieve [ options ] DescriptionThe 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 recommend using myproxy-logon(1)…
myproxy-logon – retrieve a credential Synopsismyproxy-logon [ options ] myproxy-get-delegation [ options ] DescriptionThe 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. In the default…
myproxy-init – store a credential for later retrieval Synopsismyproxy-init [ options ] DescriptionThe 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 for a MyProxy…
myproxy-info – display information about MyProxy credentials Synopsismyproxy-info [ options ] DescriptionThe 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 only for credentials…
myproxy-logon – retrieve a credential Synopsismyproxy-logon [ options ] myproxy-get-delegation [ options ] DescriptionThe 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. In the default…
myproxy-destroy – remove a credential from the repository Synopsismyproxy-destroy [ options ] DescriptionThe 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 usage text and exits….