• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

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

Summary
Review Date
Reviewed Item
MySQL Installation related Programs
Author Rating
5

“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 info@tekslate.com, 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 *

    Site Disclaimer, Copyright © 2016 - All Rights Reserved.

    Support


    Please leave a message and we'll get back to you soon.

    I agree to be contacted via e-mail.