LinuxQuestions.org - link to download my sql for ubuntu 10.04 server

Start

I like to do everything in the source directory.

shell> mkdir /usr/local/src/
shell> cd /usr/local/src

shell> tar -xvzf mysql-5.5.8.tar.gz

Get Packages so you can compile the source.
-- cmake
shell> sudo apt-get install cmake
-- g++ compiler
shell> sudo apt-get install g++
--ncurses
shell> sudo apt-get install libncurses5-dev
--bison
shell> sudo apt-get install bison
-- take advantage of asynchronous I/O capability in the new InnoDB plugin that ships with MySQL 5.5
shell> sudo apt-get install libaio-dev

-- check options.

If you want to configure additional options you can run this command and see the various options available.

shell> cmake -LAH > options
-- make mysql
shell> cmake .
shell> make
Prepare your Enviroment
Create a mysql User and Group
If your system does not already have a user and group for mysqld
to run as, you may need to create one.

shell> groupadd mysql

shell> useradd -r -g mysql mysql

Note : The above will create a user that has login permissions to your server. You may wish to disable the account, as the user is only required for ownership purposes, not login purposes. You can do this on Linux by using the -r command-line option.

These commands add the mysql group and the mysql user. install target also provided for Makefile based generators. Installation directory can be controlled using configure-time parameter CMAKE_INSTALL_PREFIX (default is /usr/local. It is also possible to install to non-configured directory, using

shell> make install DESTDIR="/custom/path"
Install in the default /usr/local/mysql directory
shell> make install
shell> make install scripts

Now that mysql is installed lets go about and add some finishing touches before starting the server.
--Go to the directory where mysql is installed.
shell> cd /usr/local/mysql

Change its ownership to mysql by executing the following commands as root in the installed directory:

shell> chown -R mysql .
shell> chgrp -R mysql .

The first command changes the owner attribute of the files to the mysql user.
The second changes the group attribute to the mysql group.

If you have not installed MySQL before, you must create the MySQL data directory and initialize the grant tables:
shell> scripts/mysql_install_db --user=mysql

If you run the command as root, include the --user option as shown. If you run the command while logged in as that user, you can omit the --user option.
The command should create the data directory and its contents with mysql as the owner.
After creating or updating the grant tables, you need to restart the server manually.
Most of the MySQL installation can be owned by root if you like. The exception is that the data directory must be owned by mysql. To accomplish this, run the following commands as root in the installation directory:

shell> chown -R root .
shell> chown -R mysql data

Now lets test our installation.
To start the MySQL server, use the following command:

shell> bin/mysqld_safe --user=mysql &

If you run the command as root, you must use the --user option as shown. The value of the option is the name of the login account that you created in the first step to use for running the server.
If you run the command while logged in as mysql, you can omit the --user option.
If the command fails immediately and prints mysqld ended, you can find some information in the host_name.err file in the data directory.

-- here is my output --

110123 23:28:35 mysqld_safe Logging to '/usr/local/mysql/data/afdbback.err'.
110123 23:28:35 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data

Now we need to set the root password.
Best way to do this is you can run:

shell> ./bin/mysql_secure_installation

Hit enter for none since you have nothing set yet.
- Set root password? [Y/n] Y
- Remove anonymous users? [Y/n] Y
- Disallow root login remotely? [Y/n] Y
- Remove test database and access to it? [Y/n] Y
- Reload privilege tables now? [Y/n] Y

Copy Configuration Files

You may want to optionally copy one of the provided configuration files from the support-files directory into your /etc directory. There are different sample configuration files
for different use cases, server types, and CPU and RAM configurations. If you want to use one of these standard files, you should copy it to /etc/my.cnf, or /etc/mysql/my.cnf
and edit and check the configuration before starting your MySQL server for the first time.
If you do not copy one of the standard configuration files,
the MySQL server will be started with the default settings.

shell> cp support-files/my-huge.cnf /etc/my.cnf

Installation complete.

---------- Post added 10-19-11 at 01:17 AM ----------

Download the 5.5.8 version of mysql here.

shell> wget "http://www.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.8.tar.gz/from/http://mysql.he.net/"