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