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…
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…