Skip to content

Instantly share code, notes, and snippets.

@nirbhabbarat
Last active August 29, 2015 14:03
Show Gist options
  • Save nirbhabbarat/d84a3ba76dbb5b236d71 to your computer and use it in GitHub Desktop.
Save nirbhabbarat/d84a3ba76dbb5b236d71 to your computer and use it in GitHub Desktop.
Percona Server 5.6 installation on Centos 6.5
rpm --nodeps -e mysql-libs percona-xtrabackup-20
rpm -qa | grep percona-release-0.0-1* || rpm -ivh http://www.percona.com/downloads/percona-release/percona-release-0.0-1.x86_64.rpm
yum -y install perl-DBD-MySQL perl-DBI
yum -y install Percona-Server-client-56 Percona-Server-devel-56 Percona-Server-server-56 Percona-Server-shared-56 percona-xtrabackup percona-toolkit
touch /var/log/mysql-slow.log
chown mysql.mysql /var/log/mysql-slow.log
chmod 755 /var/log/mysql-slow.log
/etc/init.d/mysql start
mysql -u root -e "UPDATE mysql.user SET Password=PASSWORD('mysqlpassword') WHERE User='root';FLUSH PRIVILEGES;"
mysql -u root -pmysqlpassword -e 'DELETE FROM mysql.user WHERE User="";'
mysql -u root -pmysqlpassword -e 'DELETE FROM mysql.user WHERE User="root" AND Host NOT IN ("localhost", "127.0.0.1", "::1");'
mysql -u root -pmysqlpassword -e 'DROP DATABASE test;'
mysql -u root -pmysqlpassword -e 'FLUSH PRIVILEGES;'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment