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