Friday, November 18, 2011

Installing MySQL on Ubuntu without apt-get

If you are trying to install MySQL on a box that does not have internet connection, installation will be challenging.

This post explains how MySQL can be installed and configured by downloading individual .deb files.

1. Identify your Ubuntu distribution name/version and architecture 

For checking your Ubuntu distribution name,
root@localhost:$ cat /etc/*-release
DISTRIB_ID=Ubuntu
DISTRIB_RELEASE=10.04
DISTRIB_CODENAME=lucid
DISTRIB_DESCRIPTION="Ubuntu 10.04.3 LTS"

For checking the architecture,use "uname -m" or arch command
root@localhost:/etc/mysql$ uname -m
x86_64

2. Download below packages from packages.ubuntu.com (links below correspond to amd64 architecture and lucid distribution, you will have to change this according to your configuration)

http://packages.ubuntu.com/lucid/all/libnet-daemon-perl/download
http://packages.ubuntu.com/lucid/all/libplrpc-perl/download
http://packages.ubuntu.com/lucid/amd64/libdbi-perl/download
http://packages.ubuntu.com/lucid/amd64/mysql-common/download
http://packages.ubuntu.com/lucid/amd64/libmysqlclient16/download
http://packages.ubuntu.com/lucid/amd64/libdbd-mysql-perl/download
http://packages.ubuntu.com/lucid-updates/amd64/mysql-client-core-5.1/download
http://packages.ubuntu.com/lucid-updates/amd64/mysql-client-5.1/download
http://packages.ubuntu.com/lucid-updates/amd64/mysql-server-core-5.1/download
http://packages.ubuntu.com/lucid-updates/amd64/mysql-server-5.1/download
http://packages.ubuntu.com/lucid/all/libhtml-template-perl/download
http://packages.ubuntu.com/lucid-updates/all/mysql-server/download


3. Install downloaded packages in the same order

sudo dpkg -i libnet-daemon-perl_0.43-1_all.deb
sudo dpkg -i libplrpc-perl_0.2020-2_all.deb
sudo dpkg -i libdbi-perl_1.609-1build1_amd64.deb
sudo dpkg -i mysql-common_5.1.41-3ubuntu12.10_all.deb
sudo dpkg -i libmysqlclient16_5.1.41-3ubuntu12.10_amd64.deb
sudo dpkg -i libdbd-mysql-perl_4.012-1ubuntu1_amd64.deb
sudo dpkg -i mysql-client-core-5.1_5.1.41-3ubuntu12.10_amd64.deb
sudo dpkg -i mysql-client-5.1_5.1.41-3ubuntu12.10_amd64.deb
sudo dpkg -i mysql-server-core-5.1_5.1.41-3ubuntu12.10_amd64.deb
sudo dpkg -i mysql-server_5.1.41-3ubuntu12.10_all.deb
sudo dpkg -i libhtml-template-perl_2.9-1_all.deb
sudo dpkg -i mysql-server-5.1_5.1.41-3ubuntu12.10_amd64.deb

During mysql-server-5.1 installation, you will be asked to provide the root user name and password. Make sure you remember what you provide here, without the root id and password you will not be able to connect to MySQL server.

To check whether MySQL is installed correctly, run the command
sudo netstat -tap | grep mysql

Reference 1:- http://askubuntu.com/questions/29533/install-mysql-without-apt-get

No comments: