Unable to install cloudera-management services

[#1]

Hi All,

I'm trying to install cloudera 6.2.0 , however am stuck with below error.

Provided username, dbname and password correct, I tried same credentials to connect to DB from backend and it works. 

[root@tdicsadn01 cloudera-scm-server]# cat db.properties
# Auto-generated by scm_prepare_database.sh on Fri Feb 14 17:51:09 +08 2020
#
# For information describing how to configure the Cloudera Manager Server
# to connect to databases, see the "Cloudera Manager Installation Guide."
#
com.cloudera.cmf.db.type=mysql
com.cloudera.cmf.db.host=localhost
com.cloudera.cmf.db.name=scm
com.cloudera.cmf.db.user=scm
com.cloudera.cmf.db.setupType=EXTERNAL
com.cloudera.cmf.db.password=scm2019
[root@tdicsadn01 cloudera-scm-server]#

No firewall or Selinux

[root@tdicsadn02 jdk1.8.0_181-cloudera]# getenforce
Disabled
[root@tdicsadn02 jdk1.8.0_181-cloudera]# systemctl status firewalld
● firewalld.service - firewalld - dynamic firewall daemon
   Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)
   Active: inactive (dead)
     Docs: man:firewalld(1)
[root@tdicsadn02 jdk1.8.0_181-cloudera]#

[#2]

Likely user permissions on MySQL level. If you test mysql command connecting to hostname instead of localhost you likely see the same login recected:

# mysql -h tdicsadn01.td.com -u rman -p rman2019

 If so then please add grants for those two users for '%' or 'tdicsadn01.td.com' in MySQL as shown in Step 2 in corresponding documentation chapter

[#3]

Hi @gzigldrum 

I indeed followed documentation and used below commands to grant required access;

CREATE DATABASE rman DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
GRANT ALL ON rman.* TO 'rman'@'%' IDENTIFIED BY 'rman2019';
GRANT ALL ON rman.* TO 'rman'@'localhost' IDENTIFIED BY 'rman2019';

[#4]

That looks good, can you successfully connect when running this command on the CM host:

# mysql -h tdicsadn01.td.com -u rman -p rman2019

[#5]

@chhaya_vishwaka,

If "mysql -h tdicsadn01.td.com -u rman -p rman2019" still not working, please share the output of below query from MySQL database:

SELECT * FROM mysql.user WHERE User = 'rman'\G

Need to make sure that there are no other entries might interfere with the permissions.

Cheers
Eric