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
shell> mysql_fix_privilege_tables --password=XXX
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
This option is used by the mysql_install_db
script to create the MySQL privilege tables without having to start a full MySQL server
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)
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
shell> mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql
Check Out Our Related Courses
Oracle Pl SQL Tutorials
Top 50 Sql Server Interview Questions
SQL Server DBA Training In Bangalore