question Re: How to start mySQL in HDPCDeveloper_2.2 PracticeExam instance? in Support Questions

How to start mySQL in HDPCDeveloper_2.2 PracticeExam instance?

ramesh_k_egamam — Thu, 31 Dec 2015 06:39:17 GMT

Is mySQL already installed on HDPCD Practice Exam instance? if yes, How to start mySQL in HDPCD Practice Exam instance?

Re: How to start mySQL in HDPCDeveloper_2.2 PracticeExam instance?

nsabharwal — Thu, 31 Dec 2015 07:12:43 GMT

@rich

Re: How to start mySQL in HDPCDeveloper_2.2 PracticeExam instance?

nsabharwal — Thu, 31 Dec 2015 07:13:08 GMT

@Ramesh Egamamidi

service mysqld start

/etc/init.d/mysqld start

Re: How to start mySQL in HDPCDeveloper_2.2 PracticeExam instance?

ramesh_k_egamam — Thu, 31 Dec 2015 07:19:00 GMT

Thanks for your response Neeraj.

I tried and getting the following error:

>>service mysqld start

mysqld : unrecognized service

>>/etc/init.d/mysqld start :

bash: /etc/init.d/mysqld: No such file or directory.

Any other alternate?

Re: How to start mySQL in HDPCDeveloper_2.2 PracticeExam instance?

rich1 — Thu, 31 Dec 2015 12:05:16 GMT

You need to ssh onto the namenode first:

ssh root@namenode  (password is hadoop)

No need to start mysqld on the namenode - it's already running. You can view what's in the DB by running mysql:

# mysql --user root -p

Password is "hadoop". Let me know if that works.

Re: How to start mySQL in HDPCDeveloper_2.2 PracticeExam instance?

ramesh_k_egamam — Sat, 02 Jan 2016 09:28:18 GMT

Hi Rich,

I tried the steps provided by you and got the following error : ERROR 2002(HY000) : Can't connect to local MySQL server thorugh socket 'var/lib/MySQL/MySQL.scok' (111)

Thanks,

Ramesh

Re: How to start mySQL in HDPCDeveloper_2.2 PracticeExam instance?

nsabharwal — Sat, 02 Jan 2016 22:22:02 GMT

@Ramesh Egamamidi

I guess mysql is not part of the AMI. Why do you need mysql?

yum install mysql-* (not sure if it's going to work in practice exam)

Re: How to start mySQL in HDPCDeveloper_2.2 PracticeExam instance?

Shelton — Sun, 03 Jan 2016 02:05:56 GMT

Hi Ramesh,

First check your mysql.sock If your file my.cnf (usually in the /etc/mysql/ folder) is correctly configured with socket=/var/lib/mysql/mysql.sock

Then check if mysql is running with the following command:

#mysqladmin -u root -p status

Try changing your permission to mysql folder. If you are working locally, you can try:

# chmod -R 755 /var/lib/mysql/

Start the MySQL

# service mysqld start or /etc/init.d/mysqld start

Or if There no MySQl the you need to install first

# yum install mysql mysql-server

Enable the MySQL service:

#/sbin/chkconfig mysqld on

Start the MySQL server:

#/sbin/service mysqld start

afterwards set the MySQL root password:

#mysqladmin -u root password 'new-password' (with the quotes)

Re: How to start mySQL in HDPCDeveloper_2.2 PracticeExam instance?

rich1 — Sun, 03 Jan 2016 02:07:51 GMT

Send me the public dns of your instance. Email it to certification@hortonworks.com. I'll take a look

Re: How to start mySQL in HDPCDeveloper_2.2 PracticeExam instance?

rich1 — Sun, 03 Jan 2016 03:19:45 GMT

Let me make a comment for anyone reading this who is attempting the practice exam: mysqld is already running on the namenode and you do not need to start it. If you want to connect to mysql, follow the instructions I provided below. It is possible that mysqld may have stopped, but very unlikely.

If you are having problems with the Sqoop tasks, make sure your connection URL is correct. Look in /home/horton/solutions for the correct URL.

Re: How to start mySQL in HDPCDeveloper_2.2 PracticeExam instance?

ramesh_k_egamam — Tue, 05 Jan 2016 01:09:57 GMT

Hi Rich,

As you suggested I have sent my Public DNS of my instance to certification@hortonworks.com

Thanks,

Ramesh.

Re: How to start mySQL in HDPCDeveloper_2.2 PracticeExam instance?

rich1 — Tue, 05 Jan 2016 01:35:12 GMT

Thanks. I logged in to it and everything looks fine. MySQL is running on the namenode, as expected, and I can run the mysql client to view the data in it.

Let me know if you need any further assistance.

Re: How to start mySQL in HDPCDeveloper_2.2 PracticeExam instance?

aervits — Wed, 03 Feb 2016 03:29:54 GMT

@Ramesh Egamamidi are you still having issues with this? Can you accept best answer or provide your own solution?

Re: How to start mySQL in HDPCDeveloper_2.2 PracticeExam instance?

ramesh_k_egamam — Wed, 03 Feb 2016 05:46:28 GMT

Solution provided by Rich worked for me. Thank you.

Re: How to start mySQL in HDPCDeveloper_2.2 PracticeExam instance?

harinarayana_hd — Thu, 23 Aug 2018 00:20:02 GMT

Hi Rich/Ramesh, what is the solution to resolve.