
- Learn MySQL
- MySQL - Home
- MySQL - Introduction
- MySQL - Installation
- MySQL - Administration
- MySQL - PHP Syntax
- MySQL - Connection
- MySQL - Create Database
- MySQL - Drop Database
- MySQL - Select Database
- MySQL - Data Types
- MySQL - Create Tables
- MySQL - Drop Tables
- MySQL - Insert Query
- MySQL - Select Query
- MySQL - Where Clause
- MySQL - Update Query
- MySQL - Delete Query
- MySQL - Like Clause
- MySQL - Sorting Results
- MySQL - Using Join
- MySQL - NULL Values
- MySQL - Regexps
- MySQL - Transactions
- MySQL - Alter Command
- MySQL - Indexes
- MySQL - Temporary Tables
- MySQL - Clone Tables
- MySQL - Database Info
- MySQL - Using Sequences
- MySQL - Handling Duplicates
- MySQL - SQL Injection
- MySQL - Database Export
- MySQL - Database Import
MySQL Installation Related Programs
There are 5 MySQL installation related programs. They have been listed, and discussed in brief below −
comp_err
mysql_secure_installation
mysql_tzinfo_to_sql
mysql_upgrade
comp_err
The comp_err creates the errmsg.sys file which is used by mysqld to determine the error messages that need to be displayed for different error codes. The comp_err also generates the mysqld_error.h, mysqld_ername.h, and mysqld_errmsg.h header files.
The comp_err can be invoked in the following way −
shell> comp_err [options]
mysql_secure_installation
This mysql_secure_installation program enables the user to improve the security of their MySQL installation in the below mentioned ways −
The user can set a password for root accounts.
The user can remove root accounts which are accessible from outside the local host.
The user can remove anonymous-user accounts.
The user can remove the test database which, by default, can be accessed by all users, even anonymous users), and privileges that permit anyone to access databases with names that start with test_.
The mysql_secure_installation helps the user to implement security recommendations.
mysql_tzinfo_to_sql
The mysql_tzinfo_to_sql program helps load the time zone tables in the mysql database. It is used on systems which have a zoneinfo database, i.e the set of files that describe the time zones. Examples of such systems include Linux, FreeBSD, Solaris, and macOS. One most probable location for these files is the /usr/share/zoneinfo directory (/usr/share/lib/zoneinfo on Solaris).
mysql_upgrade
Every time MySQL is upgraded, the user should execute mysql_upgrade that looks for incompatibilities with the upgraded MySQL server.
The mysql_upgrade can be used as shown below −
Ensure that the server is currently running.
Invoke mysql_upgrade to upgrade the system tables in the mysql schema.
Check and repair tables in other schemas using the below command −
shell > mysql_upgrade [options]
Stop the server and restart it so that any system table changes can take effect.
- Related Articles
- Invoking MySQL Programs
- MySQL Client Programs
- mysql_secure_installation - Improve MySQL Installation Security
- Overview of MySQL Programs
- Steps to upgrade a MySQL installation
- Upgrading a Docker Installation of MySQL
- MySQL Administrative and Utility Programs
- Important MYSQL Performance Tuning and Settings after Installation
- MySQL Server and Server-Startup Programs
- How to specify options for MySQL programs?
- Application Programs vs System Programs
- Using Options on the Command Line for MySQL programs?
- What kinds of programs are available in MySQL database to manage MySQL server?
- Cypress Installation (Test Automation)
- Using Option Files for MySQL programs? Usage of Option Files
