question Re: Password for MySQL in Support Questions

Password for MySQL

jdupourque — Tue, 31 Oct 2017 14:29:35 GMT

I've installed Cloudera VM 5.3.0 with VMware 11.0 on Windows 8.1. I'm trying to connect to MySQL with CLI and I typed

mysql -u root -p cloudera, but I can't connect to MySql.

Is "cloudera" the correct password ?

Best regards,

Re: Password for MySQL

GautamG — Sat, 03 Jan 2015 01:39:53 GMT

> mysql -u root -p cloudera

Try

$ mysql -uroot -pcloudera (no space between -p and password)

Re: Password for MySQL

jdupourque — Sat, 03 Jan 2015 08:53:05 GMT

Thank you for your answer. It works!

Re: Password for MySQL

Pandian — Wed, 23 Nov 2016 22:28:02 GMT

It works. Thanks

Re: Password for MySQL

anjaniajay — Sun, 21 May 2017 16:59:58 GMT

Please try both mysql -uroot -pcloudera and mysql -uroot.

One of them definitely work.

Re: Password for MySQL

ChandraRavi — Sun, 16 Jul 2017 05:05:25 GMT

Thanks. This works.

Could you please point me how and where did you find this user id and password.

Re: Password for MySQL

Santy3298 — Tue, 05 Sep 2017 18:47:19 GMT

mysql -uroot

its work for me for cloudera on windows10.

Re: Password for MySQL

other — Sun, 08 Oct 2017 20:40:33 GMT

It works like charm. 🙂

Re: Password for MySQL

hparteaga — Wed, 22 Nov 2017 10:21:22 GMT

Why ? Can you explain the reason?

Re: Password for MySQL

durgaprasad — Thu, 11 Jan 2018 17:38:36 GMT

What is the password for retail_user

Re: Password for MySQL

durgaprasad — Thu, 11 Jan 2018 17:45:28 GMT

below option worked for me...

$mysql -u root -p
Enter Password:

mysql> grant all privileges on *.* to retail_user@localhost identified by 'pass' with grant option;

Re: Password for MySQL

other — Thu, 11 Jan 2018 18:44:04 GMT

mysql -u root -pcloudera