Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Mysql- community - 5.6.40 : Installation Issues

Mysql- community - 5.6.40 : Installation Issues

New Contributor

mysqlinstalldb --user=mysql --basedir=/usr/ --ldata=/var/lib/mysql/

/usr/bin/perl: symbol lookup error: /usr/local/lib64/perl5/auto/Data/Dumper/Dumper.so: undefined symbol: PerlIstacksp_ptr

7 REPLIES 7

Re: Mysql- community - 5.6.40 : Installation Issues

Mentor

@Abbas Ahmed Syed

What are you trying to do? Are you trying to install Mysql DB for Ambari?

What OS are you running this install on?

Re: Mysql- community - 5.6.40 : Installation Issues

New Contributor

@Geoffrey Shelton Okot

Yes I want to install MYSQL for Ambari and other HDF services.

RHEL - 7.4

Re: Mysql- community - 5.6.40 : Installation Issues

Mentor

@Abbas Ahmed Syed

This is how you should install MYSQL on, what version of HDP do you intend to install?

Install the MySQL database

sudo yum install mysql-server 

Set Mysql to autostart

sudo systemctl enable mysqld 

Start the Mysql database

sudo systemctl start mysqld

HTH

Re: Mysql- community - 5.6.40 : Installation Issues

New Contributor

@Geoffrey Shelton Okot

That's the first thing i had done.

So it was not working .. It's not starting .

No pid.

No config file.

Re: Mysql- community - 5.6.40 : Installation Issues

Mentor

@Abbas Ahmed Syed

Whats the output of all the above commands? The Install and start for example?

Re: Mysql- community - 5.6.40 : Installation Issues

Mentor

@Abbas Ahmed Syed

Setting up MySQL on Linux should be straightforward please try to follow the steps below and let me know.

Installing MySQL

$ wget https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm 

Check that the download is not corrupt

$  md5sum mysql57-community-release-el7-9.noarch.rpm 

sample output

1a29601dc380ef2c7bc25e2a0e25d31e mysql57-community-release-el7-9.noarch.rpm

Add the MySQL to yum repositories

$ sudo rpm -ivh mysql57-community-release-el7-9.noarch.rpm 

Install the MySQL server

 $ sudo yum install mysql-server 

Starting MySQL

$ sudo systemctl start mysqld 

Check the status

$ sudo systemctl status mysqld 

During the installation process, a temporary password is generated for the MySQL root user. Locate it in the mysqld.log with this command:

$ sudo grep 'temporary password' /var/log/mysqld.log 

Make note of the password, which you will need in the next step to secure the installation and where you will be forced to change it. The default password policy requires 12 characters, with at least one uppercase letter, one lowercase letter, one number and one special character. It is recommended that you answer yes to these options

Secure and Configure MySQL

$ sudo mysql_secure_installation 

Testing MySQL

# mysqladmin -u root -p version

HTH

Re: Mysql- community - 5.6.40 : Installation Issues

Mentor

@Abbas Ahmed Syed

Any updates ?

As the issue is resolved, hence it will be also great if you can mark this HCC thread as Answered by clicking on the "Accept" Button. That way other HCC users can quickly find the solution when they encounter the same issue.

Don't have an account?
Coming from Hortonworks? Activate your account here