Mysql- community - 5.6.40 : Installation Issues

[#1]

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

[#2]

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

[#3]

@Geoffrey Shelton Okot

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

RHEL - 7.4

[#4]

@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

[#5]

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

[#6]

@Abbas Ahmed Syed

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

[#7]

@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

[#8]

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