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

How To connect with mysql in HDPCDeveloper Practice exam instance

Solved Go to solution
Highlighted

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
Highlighted

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
Highlighted

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
Highlighted

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.

Highlighted

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

Highlighted

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

New Contributor

Thanks ..it worked