Skip to content

Instantly share code, notes, and snippets.

@Ameen-Alam
Forked from mansurali901/SetupMysql5.7RPM.sh
Created September 22, 2020 00:04
Show Gist options
  • Save Ameen-Alam/21f2468982c20b1d3c80e922917ab81e to your computer and use it in GitHub Desktop.
Save Ameen-Alam/21f2468982c20b1d3c80e922917ab81e to your computer and use it in GitHub Desktop.
#!/bin/bash
# This script Mysql 5.7 from RPM Builder
# Author Mansur Ul Hasan
# mansurali901@gmail.com
Prepass () {
echo "Preparing Environement ....."
yum groupinstall "Development Tools"
yum install ncurses-dev libaio perl-DBI
echo "Adding User...."
groupadd mysql
useradd -r -g mysql -s /bin/false mysql
echo "Download Source RPMs"
mkdir /usr/local/mysql-rpms
cd /usr/local/mysql-rpms
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.21-1.el6.x86_64.rpm-bundle.tar
tar -xvf mysql-5.7.21-1.el6.x86_64.rpm-bundle.tar
rpm -i mysql-community-common-5.7.21-1.el6.x86_64.rpm
rpm -i mysql-community-libs-5.7.21-1.el6.x86_64.rpm
rpm -i mysql-community-devel-5.7.21-1.el6.x86_64.rpm
rpm -i mysql-community-libs-compat-5.7.21-1.el6.x86_64.rpm
rpm -i mysql-community-embedded-5.7.21-1.el6.x86_64.rpm
rpm -i mysql-community-embedded-devel-5.7.21-1.el6.x86_64.rpm
rpm -i mysql-community-client-5.7.21-1.el6.x86_64.rpm
rpm -i mysql-community-server-5.7.21-1.el6.x86_64.rpm
}
SetupFunc () {
mysqld --initialize --basedir=/var/lib/mysql
/etc/init.d/mysqld stop
echo "We are going to start mysql in safe mode to reset your mysql root password.....
Please issue below commands in order to reset your root access
connect to mysql cli
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
mysql
flush privileges;
SET PASSWORD FOR root@'localhost' = PASSWORD('yourrootpassword');
flush privileges;
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
After applying above commands start your mysql in normal mode
"
}
MysqlSafe () {
mysqld_safe --skip-grant-tables &
}
# Main Function
Prepass
# Setup Function
SetupFunc
# Safe Mode
MysqlSafe
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment