Group Discounts available for 3+ students and Corporate Clients

MySQL Installation related Programs

3.1.  mysql_fix_privilege_tables is an older script that previously was used to uprade the system tables in the mysql database after a MySQL upgrade.

As of MySQL 5.0.19, mysql_fix_privilege_tables is superseded by mysql_upgrade, which should be used instead.

Before running mysql_fix_privilege_tables, make a backup of your mysql database.

On Unix or Unix-like systems, update the system tables by running the mysql_fix_privilege_tables script:

shell> mysql_fix_privilege_tables –password=XXX


3.2. mysql_install_db initializes the MySQL data directory and creates the system tables that it contains, if they do not exist.

shell> bin/mysql_install_db –user=mysql –basedir=/opt/mysql/mysql –datadir=/opt/mysql/mysql/data

bootstrap This option is used by the mysql_install_db script to create the MySQL privilege tables without having to start a full MySQL server


3.3. mysql_secure_installation

This program enables you to improve the security of your MySQL installation in the following ways:

  • You can set a password for root
  • You can remove root accounts that are accessible from outside the local host.
  • You can remove anonymous-user accounts.
  • You can remove the test database (which by default can be accessed by all users, even anonymous users)

shell> mysql_secure_installation


3.4.  mysql_tzinfo_to_sql

          The 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 Mac OS X. One likely location for these files is the “/usr/share/zoneinfo” directory

shell> mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql

Check Out Our Related Courses

Sql Tutorials

Oracle Pl SQL Tutorials

Top 50 Sql Server Interview Questions

SQL Server DBA Training In Bangalore

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at, we will update the article in 24 hours.”

0 Responses on MySQL Installation related Programs"

Leave a Message

Your email address will not be published. Required fields are marked *


Please Enter Your Details and Query.
Three + 6