If for some reason you decide not to use the schema tool, you can use the file below instead,
That file is located in the /usr/lib/hive/scripts/metastore/upgrade/mysql/ directory.
Proceed as follows if you decide to use
If you are not using the Hive schema tool, you can use this:-
$ mysql -u root -p
mysql> CREATE DATABASE metastore;
mysql> USE metastore;
mysql> SOURCE /usr/lib/hive/scripts/metastore/upgrade/mysql/hive-schema-n.n.n.mysql.sql;
You also need a MySQL user account for Hive to use to access the metastore. It is very important to prevent this user account from creating or altering tables in the metastore database schema.