Downloading and installing MySQL database
Download and install MySQL database depending on your CDP and Operating System (OS) version.
-
Download the MySQL distribution from https://dev.mysql.com/downloads/ based on your OS version.
Use the Cloudera Support Matrix for finding the compatibile versions.
-
Install the database using the following commands depending on your operating
system:
On RHEL/CentOS:
sudo yum install mysql-server
On SLES:sudo zypper install mysql
On Ubuntu:sudo apt-get install mysql-server #set root psswd when prompted
On Debian:sudo apt-get install mysql-server #set root psswd when prompted
-
Start the database server using the following commands depending on your
operating system:
On RHEL/CentOS:
sudo service mysqld start
On SLES:sudo rcmysql start
On Ubuntu:sudo service mysql start
On Debian:sudo service mysql start
-
Secure your installation by running the following command:
sudo /usr/bin/mysql_secure_installation
mysql_secure_installation
is a shell script available on Unix systems, and enables you to improve the security of your MySQL installation in the following ways:Enter current password for root (enter for none): [If unset, press Enter.] OK, successfully used password, moving on... [...] Set root password? [Y/n] Y [Enter n if password is set.] New password: Re-enter new password: Remove anonymous users? [Y/n] Y [...] Disallow root login remotely? [Y/n] N [...] Remove test database and access to it [Y/n] Y [...] Reload privilege tables now? [Y/n] Y