question Re: How To connect with mysql in HDPCDeveloper Practice exam instance in Archives of Support Questions (Read Only)

How To connect with mysql in HDPCDeveloper Practice exam instance

Shk — Wed, 11 May 2016 20:51:41 GMT

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)

Re: How To connect with mysql in HDPCDeveloper Practice exam instance

tmccuch — Wed, 11 May 2016 21:22:47 GMT

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

Re: How To connect with mysql in HDPCDeveloper Practice exam instance

tmccuch — Thu, 12 May 2016 18:34:57 GMT

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

Re: How To connect with mysql in HDPCDeveloper Practice exam instance

rich1 — Fri, 13 May 2016 21:22:47 GMT

@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.

Re: How To connect with mysql in HDPCDeveloper Practice exam instance

Shk — Tue, 24 May 2016 18:51:58 GMT

Thanks ..it worked