MySQL 5.6 Installation

• ubuntu
  • apt-get -y install mysql-server-5.6
  • vim /etc/mysql/my.cnf
  • bind-address=0.0.0.0
  • service mysql restart
• centos
  
  • download yum repository page from http://dev.mysql.com/downloads/repo/yum/, or
  • wget http://dev.mysql.com/get/mysql57-community-release-el7-7.noarch.rpm
  • yum -y localinstall mysql57-community-release-el7-7.noarch.rpm
  • vim /etc/yum.repos.d/mysql-community.repo
  • enable mysql 5.6 community server
  • disable mysql 5.7 community server
  • yum repolist enabled | grep "mysql.*-community.*"
  • yum -y install mysql-community-server
  • systemctl start mysqld.service
  • systemctl enable mysqld.service
  • set root password
    • mysql -u root
    • use mysql;
    • update user set password=PASSWORD("new-password") where User='root';
    • flush privileges;
    • exit;
  • granting user connections from remote hosts
    • GRANT ALL PRIVILEGES ON *.* TO 'root'@'remote host' IDENTIFIED BY 'password' WITH GRANT OPTION;