Support Questions
Find answers, ask questions, and share your expertise

How To connect with mysql in HDPCDeveloper Practice exam instance

Solved Go to solution

How To connect with mysql in HDPCDeveloper Practice exam instance

New Contributor

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)

1 ACCEPTED SOLUTION

Accepted Solutions

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

Guru

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

View solution in original post

4 REPLIES 4

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

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

@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

Guru

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

View solution in original post

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

New Contributor

Thanks ..it worked