- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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 Questions & Answers
- 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
- MySQL Server and Server-Startup Programs
- Important MYSQL Performance Tuning and Settings after Installation
- Application Programs vs System Programs
- How to specify options for MySQL programs?
- Cypress Installation (Test Automation)
- Perl Installation on Windows Platform
- Perl Installation on Macintosh Platform
- Explain JMeter installation in macOS