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