Setting)) Mysql version upgrade

This wiki introduces how to upgrade mysql version 5.1 to 5.7.

highly recommend to test this process in virtual environment.

1. db backup with mysqldump

    mysqldump -uroot -p DB_NAME > dumpfilename.sql

2. remove mysql package

    sudo yum remove mysql mysql-server*

3. remove database directory

    sudo rm -rf /var/lib/mysql/*

must copy hue folder since we use cloudera environment.

4. Download package(rpm)

    wget http://dev.mysql.com/get/mysql57-community-release-el6-7.noarch.rpm
    yum localinstall mysql57-community-release-el6-7.noarch.rpm
    yum install mysql-community-server

5. Server start

    /etc/init.d/mysqld start

6. Access mysql

    mysql -uroot -p
    password:
    mysql>

Trouble shooting reference:

    https://stackoverflow.com/questions/41645309/mysql-error-access-denied-for-user-rootlocalhost

Written by ilgwonPark