https://community.cloudera.com/t5/Support-Questions/Error-starting-HIVE-metastore/m-p/209327#M171281 <P>I already have hive user in mysql. But seems only good if I use 'local' host. When use FQDN, access to data base is denied</P><PRE>root@msl-dpe-perf74:/home/harry.li# mysql -u hive -phive -h localhost mysql: [Warning] Using a password on the command line interface can be insecure. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 293 Server version: 5.7.23-0ubuntu0.16.04.1 (Ubuntu) Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql&gt; show databases; +--------------------+ | Database | +--------------------+ | information_schema | | hive | +--------------------+ 2 rows in set (0.00 sec) mysql&gt; quit Bye root@msl-dpe-perf74:/home/harry.li# mysql -u hive -phive -h msl-dpe-perf74.msl.lab mysql: [Warning] Using a password on the command line interface can be insecure. ERROR 1045 (28000): Access denied for user 'hive'@'msl-dpe-perf74.msl.lab' (using password: YES)</PRE> Thu, 02 Aug 2018 05:03:52 GMT harry_li 2018-08-02T05:03:52Z