Forked from ahmadhasankhan/MySql-5.5-installation guide.md
Created
May 11, 2020 02:50
-
-
Save coderdavi/0f9fda61a5785deafde2086c9546a470 to your computer and use it in GitHub Desktop.
Revisions
-
ahmadhasankhan revised this gist
Nov 27, 2019 . 1 changed file with 1 addition and 1 deletion.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -46,7 +46,7 @@ sudo mv mysql-5.5.56-linux-glibc2.5-x86_64 /usr/local/ - Create mysql folder in /usr/local by moving the untarred folder ``` cd /usr/local sudo mv mysql-5.5.56-linux-glibc2.5-x86_64 mysql ``` -
ahmadhasankhan revised this gist
Nov 1, 2017 . 1 changed file with 3 additions and 2 deletions.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -131,10 +131,11 @@ sudo update-rc.d -f mysql.server remove - REBOOT! - Now login using below command, start mysql server if it's not running already ``` mysql -u root -p ``` -
ahmadhasankhan revised this gist
Nov 1, 2017 . 1 changed file with 1 addition and 1 deletion.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -35,7 +35,7 @@ sudo useradd -g mysql mysql - Extract it ``` sudo tar -xvf mysql-5.5.56-linux-glibc2.5-x86_64.tar.gz ``` - Move it to /usr/local -
ahmadhasankhan revised this gist
Oct 9, 2017 . 1 changed file with 1 addition and 1 deletion.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -1,4 +1,4 @@ MySQL Download URL ``` https://dev.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.56-linux-glibc2.5-x86_64.tar.gz ``` -
ahmadhasankhan revised this gist
Oct 9, 2017 . 1 changed file with 1 addition and 5 deletions.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -1,8 +1,4 @@ MySQL Downloads URL ``` https://dev.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.56-linux-glibc2.5-x86_64.tar.gz ``` -
ahmadhasankhan revised this gist
Oct 9, 2017 . 1 changed file with 1 addition and 1 deletion.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -68,7 +68,7 @@ sudo apt-get install libaio1 - Execute mysql installation script ``` sudo scripts/mysql_install_db --user=mysql ``` - Set mysql directory owner from outside the mysql directory -
ahmadhasankhan revised this gist
Oct 9, 2017 . 1 changed file with 9 additions and 1 deletion.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -9,6 +9,7 @@ https://dev.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.56-linux-glibc2.5-x86_64 ### Open the terminal and follow along: - Uninstall any existing version of MySQL ``` sudo rm /var/lib/mysql/ -R ``` @@ -35,11 +36,17 @@ sudo groupadd mysql sudo useradd -g mysql mysql ``` - Extract it ``` sudo tar -xvf mysql-5.5.56-linux-glibc2.5-x86_64.tar.gz /usr/local/ ``` - Move it to /usr/local ``` sudo mv mysql-5.5.56-linux-glibc2.5-x86_64 /usr/local/ ``` - Create mysql folder in /usr/local by moving the untarred folder ``` cd /usr/local @@ -48,6 +55,7 @@ sudo mv mysql-5.5.49-linux2.6-x86_64 mysql ``` - set MySql directory owner and user group ``` cd mysql sudo chown -R mysql:mysql * -
ahmadhasankhan revised this gist
Oct 9, 2017 . 1 changed file with 9 additions and 3 deletions.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -3,13 +3,19 @@ Go to www.mysql.com > downloads > you will see links for older versions. When you get to the dropdowns for OS, you will see Ubuntu. Note that these only go up to 14. Instead, select Linux/Generic. Scroll to the bottom to get the TAR Archive – select 32 or 64 bit. Click download On the following page look for “No thanks, just start my download.” Right click and copy the URL. Here is the URL for 5.5 as it was when I wrote this: ``` https://dev.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.56-linux-glibc2.5-x86_64.tar.gz ``` ### Open the terminal and follow along: - Uninstall any existing version of MySQL ``` sudo rm /var/lib/mysql/ -R ``` - Delete the MySQL profile ``` sudo rm /etc/mysql/ -R ``` - Automatically uninstall mysql ``` sudo apt-get autoremove mysql* --purge -
ahmadhasankhan created this gist
Oct 9, 2017 .There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -0,0 +1,132 @@ Find the correct version you want for MySQL 5.5 Go to www.mysql.com > downloads > you will see links for older versions. When you get to the dropdowns for OS, you will see Ubuntu. Note that these only go up to 14. Instead, select Linux/Generic. Scroll to the bottom to get the TAR Archive – select 32 or 64 bit. Click download On the following page look for “No thanks, just start my download.” Right click and copy the URL. Here is the URL for 5.5 as it was when I wrote this: `https://dev.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.56-linux-glibc2.5-x86_64.tar.gz` ### Open the terminal and follow along: - Uninstall any existing version of MySQL `sudo rm /var/lib/mysql/ -R`\ - Delete the MySQL profile `sudo rm /etc/mysql/ -R` - Automatically uninstall mysql ``` sudo apt-get autoremove mysql* --purge sudo apt-get remove apparmor ``` - Download version 5.5.51 from MySQL site ``` wget https://dev.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.56-linux-glibc2.5-x86_64.tar.gz ``` - Add mysql user group ``` sudo groupadd mysql ``` - Add mysql (not the current user) to mysql user group ``` sudo useradd -g mysql mysql ``` - Extract to /usr/local ``` sudo tar -xvf mysql-5.5.56-linux-glibc2.5-x86_64.tar.gz /usr/local/ ``` - Create mysql folder in /usr/local by moving the untarred folder ``` cd /usr/local sudo mv mysql-5.5.49-linux2.6-x86_64 mysql ``` - set MySql directory owner and user group ``` cd mysql sudo chown -R mysql:mysql * ``` - Install the required lib package (works with 5.6 as well) ``` sudo apt-get install libaio1 ``` - Execute mysql installation script ``` udo scripts/mysql_install_db --user=mysql ``` - Set mysql directory owner from outside the mysql directory ``` sudo chown -R root . ``` - Set data directory owner from inside mysql directory ``` sudo chown -R mysql data ``` - Copy the mysql configuration file ``` sudo cp support-files/my-medium.cnf /etc/my.cnf ``` - Start mysql ``` sudo bin/mysqld_safe --user=mysql & sudo cp support-files/mysql.server /etc/init.d/mysql.server ``` - Set root user password ``` sudo bin/mysqladmin -u root password '[your new password]' ``` - Add mysql path to the system ``` sudo ln -s /usr/local/mysql/bin/mysql /usr/local/bin/mysql ``` - Reboot! - Start mysql server ``` sudo /etc/init.d/mysql.server start ``` - Stop mysql server ``` sudo /etc/init.d/mysql.server stop ``` - Check status of mysql ``` sudo /etc/init.d/mysql.server status ``` - Enable myql on startup ``` sudo update-rc.d -f mysql.server defaults ``` *Disable mysql on startup (Optional) ``` sudo update-rc.d -f mysql.server remove ``` - REBOOT! - Now directly use the command below to start mysql if it hasn’t ``` sudo service start mysql -u root -p ```