How To connect with mysql in HDPCDeveloper Practice exam instance

[#1]

Hi

I was trying to connect with mysql to check databases.. as mysql is already running in namenode

I have used following command

mysql --user root -p and got following error

ERROR 2002(HY000) : Can't connect to local MySQL server thorugh socket 'var/lib/MySQL/MySQL.scok' (2)

[#2]

By not specifying the hostname, you are attempting to connect to "localhost". When you connect to "localhost", the socket connector is used, which doesn't look like it was configured properly. To use the TCP/IP connector, you should connect to mysql using the hostname:

mysql --host your.hostname.goes.here --user root -p

[#3]

@Shikha Verma - did this answer help? If so, please accept. Otherwise, let me know if you need further assistance.

[#4 · Accepted solution]

@Shikha Verma - The MySQL instance is running on a machine called "namenode", not localhost. If you want to run the mysql client, you should SSH onto namenode first:

$ ssh root@namenode

The password is "hadoop".

Once you are on the namenode, then you can run mysql:

# mysql --user root -p

That password is also "hadoop". Let me know if that works.

[#5]

Thanks ..it worked