Today one of our client has forgot his Application Server Console password. We have used following method to reset his password.

Please Note : This method also work on following

• Oracle Fusion Middleware Version 9.0.4.0.0 to 10.1.3.5.0
• Enterprise Manager Base Platform Version 10.1.0.2 to 10.2.0.5
• Enterprise Manager for Fusion Middleware Version 9.0.4.0.0 to 10.1.3.5.0

Step 1 First shutdown the application server control by running emctl command
For 10.1.2

$ORACLE_HOME/bin/emctl stop iasconsole

On 10.1.3 you need to stop the OC4J instances before performing the password change:

$ORACLE_HOME/opmn/bin/opmnctl stopproc ias-component=OC4J

Step 2 Locate and backup the jazn-data.xml (10.1.2) or system-jazn-data.xml (10.1.3) file:
On 10.1.2 File Location would be

$ORACLE_HOME/sysman/j2ee/config/jazn-data.xml

On 10.1.3 File Location would be

$ORACLE_HOME/j2ee/home/config/system-jazn-data.xml

Step 3 Edit the jazn-data.xml / system-jazn-data.xml file depending on the Application Server version in a text editor and locate the line that defines the credentials property for the ias_admin user:

On 10.1.2
The following example shows the section of jazn-data.xml with the encrypted credentials entry in boldface type:

<realm>
     <name>enterprise-manager</name>
      <users>
       <user>
        <name>ias_admin</name>
         <credentials>rJqp85BkhFwAyw9ddl0PnFlUBVaWzbfT</credentials>
       </user>

On 10.1.3
The following example shows the section of system-jazn-data.xml with the encrypted credentials entry in boldface type:

<realm>
  <name>jazn.com</name>
   <users>
    <user>
      <name>oc4jadmin</name>
      <display-name>OC4J Administrator</display-name>
      <description>OC4J Administrator</description>
       <credentials>{903}4L50lHJWIFGwLgHXTub7eYK9e0AnWLUH</credentials>
    </user>

Step 4 Replace the existing encrypted password with the new password
Be sure to prefix the password with an exclamation point (!). For example:
!mynewpassword123

Step 5 Start the Application Server Console:
For 10.1.2 do following

$ORACLE_HOME/bin/emctl start iasconsole

After the restart, the Application Server Control will be using your new Administrator (ias_admin) password, which will be stored in encrypted format within the jazn-data.xml file.

For 10.1.3 do following

$ORACLE_HOME/opmn/bin/opmnctl startproc ias-component=OC4J

After the restart, the Application Server Control will be using your new Administrator (oc4jadmin) password, which will be stored in encrypted format within the system-jazn-data.xml file.

Step 6 Login to the Application Server Console and authenticate with the ias_admin user (10.1.2) or the oc4jadmin user (10.1.3) and the new password.

LibreOffice is the free power-packed Open Source personal productivity suite for Windows, Mac and Linux, that gives you six feature-rich applications for all your document production and data processing needs: Writer, Calc, Impress, Draw, Math and Base. Support and documentation is free from our large, dedicated community of users, contributors and developers.

Recently LibreOffice team has released LibreOffice 3.5 RC 1. In this tutorial we will see how to install LibreOffice 3.5 RC 1 on Ubuntu

Step 1 Go to LibreOffice official website and download the LibreOffice 3.5 RC 1 archive for Ubuntu

cd /tmp/vidyadhar
wget http://download.documentfoundation.org/libreoffice/testing/3.5.0-rc1/deb/x86/LibO_3.5.0rc1_Linux_x86_install-deb_en-US.tar.gz
tar zxvf LibO_3.5.0rc1_Linux_x86_install-deb_en-US.tar.gz

Step 2 To install LibreOffice 3.5 RC 1 you have to run dpkg command

cd /tmp/vidyadhar/LibO_3.5.0rc1_Linux_x86_install-deb_en-US/DEBS
sudo dpkg -i *.deb
cd desktop-integration
sudo dpkg -i *.deb

That’s it. Enjoy your LibreOffice 3.5

In this guide we will upgrade the Ubuntu kernel version. By default Ubuntu 11.10 ships with 3.0 Kernel version. We will install the new kernel 3.2 over existing 3.0

Step 1 First we will see the current kernel version. To do so run following

uname -r

Output will be something like below

Step 2 Now we will add kernel ppa. Open a command propmt and run following commands

sudo add-apt-repository ppa:francisbrwn9/kernels
sudo apt-get update
sudo apt-get dist-upgrade

Step 3 Once finish, you have to reboot your machine to use the newest kernel. After reboot run uname -r to see the kernel version

uname -r

Output will be something like below

Enjoy your new Kernel

Oracle Application Server is no longer available. The reason is because once “Oracle SOA Suite 10g (10.1.3.1.0)” was released, it contains the same product features and functionality, including some features which are not obtainable without the 10.1.3.1 media. In this tutorial we will see how to install Oracle Application Server 10g R 3(10.1.3.X) on Windows.

Requirements
Windows OS
Oracle Application Server 10.1.3.X

Step 1 Downloading Oracle Application Server 10.1.3.X
Oracle provides 32-bit and 64-bit versions of Oracle Application Server for Windows. The 32-bit version runs on Intel x86, AMD64, and Intel EM64T processors. For additional information, visit OracleMetaLink at http://metalink.oracle.com

I have downloaded the installer files at C:\Downloads\INSTALLABLES\Oracle For 32 bit installer file name would be soa_windows_x86_101310_disk1.zip

I have extracted the same to C:\Downloads\INSTALLABLES\Oracle

Step 2 Starting the installation
Go to extracted folder. In our case it is C:\Downloads\INSTALLABLES\Oracle\soa_windows_x86_101310_disk1\soa_windows_x86_101310_disk1 and double click on setup.exe It will start the Oracle Application Server Universal installer

Step 3 Oracle Application Server 10g 10.1.3.X screen
Enter the installation directory where you want to install Oracle Application Server. In our case I choose D:\product\10.1.3.1\OracleAS_1 Also select Advance Installation mode.

For the Warning please click on yes

Step 4 Select Installation Type screen
In this section choose J2EE server and Web server, as we are going to use only oc4j containers for J2EE and HTTP Server

Step 5 Specify Port Configuration Options screen
In Specify Port Configuration Options screen Select Automatic and click Next

Step 6 Administration Instance Settings screen
In AS administrator settings enter following values:
AS instance Name : techienote
AS Administrator Password : admin_123
OC4J Instance Name : home
Select Configure this as an Administration OC4J instance. This will start EM console as soon as you start the oracle service via OPMN.
Click Next.

Step 7 Cluster Topology Configuration screen

Deselect Configure this instance to be part of an Oracle Application Server cluster topology as this is a simple installation and click on Next

Step 8 Now it will start the installation process

Step 9. Configuration Assistant
At this level installer will configure various service. In case of any failure please see installation logs which are located at C:\Program Files\Oracle\Inventory\logs folder

Step 10 End of Installation
On this screen you will get Oracle Application server EM console URL

Step 11. Access the Oracle Application Server Welcome page to verify that the installation was successful. The URL for the Welcome page is:

http://hostname.domainname:http_port

You can locate the URL for accessing the Welcome Page on the End of Installation Screen text, which is stored in the following file:
ORACLE_HOME\install\readme.txt

The Welcome page provides links to these useful pages:
New features in Oracle Application Server 10g Release 3 (10.1.3)

• Oracle Enterprise Manager Application Server Control (“Application Server Control”), which is a browser-based administrative tool
• Release Notes
• Quick Start
• Demos

That’s it. You are ready with the application server installation. In next section we will see how to deploy sample application in Oracle Application Server.

Bejeweled is very popular game for PalmOS / Windows / Java based phone. Now you can also play the same game on your Ubuntu desktop by installing Gweled. Gweled is a GNOME version of Bejeweled or Diamond Mine.

The aim of the game is to make alignment of 3 or more gems, both vertically or horizontally by swapping adjacent gems. The game ends when there are no possible moves left.

Here’s how to install and play Gweled on Ubuntu:

Step 1 Issue the following command at the terminal

sudo apt-get install gweled

Step 2 After the installation is complete, go to Menu > Games > Gweled to start the game. Else type gweled in console.

That’s it. Enjoy your game.

In the smartphone market android os is the best OS I have used till now. Android was listed as the best-selling smartphone platform worldwide in Q4 2010 by Canalys. Android is capable of wide variety of functions due to its openness, but a lot of the problems comes from a lack of understanding of the OS.

Because of the way memory is managed in the Android OS, and the way Android apps are structured, the more apps you load, the less memory is available to actually run the apps. The less memory is available, the slower the phone will run, as the phone must spend more time swapping apps in and out of the little working memory available. This affects both battery life and performance.

The problem shows itself in at least three ways:

Symptom 1: You download an updated app and the download stops for apparently no reason

Diagnosis: The “downloading service” was shuffled out by the system, killing the download.

Go the the “services screen”. (see below) Does the “download service” says “restarting” to the right? That means It was indeed stopped by the system to give the memory to some other apps.

Symptom 2: Apps used to load from the launcher instantly now takes several seconds. Screens transitions are slow as heck. Loading a new supposedly “fast” launcher did not help.

Diagnosis: System is busy shuffling various activities and services in and out of memory.

Does lot of different services show “restarting”? Do the some of the services shows very short “active life”?

Symptom 3: Your phone used to last most of a day but now it won’t last past lunch without a charge

Diagnosis: You have all sorts of services in the background using battery power here and there

If you go into the battery usage screen (settings > About Phone > Battery Usage) and you see a very long list of apps all taking a few bits and pieces of power, you have too many apps loaded, and they are all sucking up a little power, and all those bits and pieces add up.

All these problems can be traced back to a single cause: too many apps in too little memory. However, as the memory in Android phones are not expandable, you can only deal with the problem by remove apps to make more memory available. But first, let us dig into the Android OS and learn how Android OS manages memory.

So How Android OS Really Manages Memory?

The Android OS memory management is a complicated subject, and is quite technical.
Android OS roughly groups all apps into 6 groups, with priority from highest to lowest:
Foreground app: you see this app on screen, currently running, but also includes the system itself and “phone”

Visible app: the app is running and visible, but due to multi-tasking or such is not currently “on top”

Secondary server: services that stay in background and apps such as Launcher (or other home replacements). Most services go here, like music player, clock updater, background sync, and so on, that’s not built into the OS.

Hidden Application: apps not visible, but still running in the background

Content Provider: process that provides content to the foreground, such as “contacts content provider”, “calendar content provider”, and so on. May also known as “storage”.

Empty App: the app is in standby, not being used, but is still in memory

Within each ‘group’ the system assigns a “priority” number based on how recently the app was accessed, with assumption that a most recently access program should be kept, and the oldest will be out of luck.

When Android OS runs out of free memory and needs to load a new app, it starts killing apps in Empty App group, oldest first. if that’s not enough, it then starts killing apps in the Content Provider Group, and it keeps going up groups until it has finally freed up enough memory to load the app and all related processes (such as services).

NOTE: Having a constant “notification” in the notification area makes the program “visible app” instead of “hidden app”, thus making it less likely to be killed by the system to make room for other apps.
Most of the problems occur when the system tries to make room by killing “secondary server” processes that are needed.

Never Enough Memory

Android OS has THREE main pools of memory: RAM (for running programs), app storage (for storing programs that will be ran) and finally, SD card (for storing data like music, photos, and secondary storage). (NOTE: Some phones have “internal” SD card and external SD card, and they are known as /sdcard and /sdcard-ext respectively.)

RAM management is very complicated because Android OS is based on a Linux kernel (read: heart) and even seasoned Linux developer will tell you it is virtually incomprehensible. After extensive experimentation, it is found that the hardware itself (i.e. the PHONE) will take 32MB or so even before the Android OS loads. Then the fixed components like “system” (acore, phone, gapps, system…) will take up about 65-80MB. That’s about 100-128 MB gone, without a single actual app being loaded.

Then you load the launcher itself, which uses anywhere like 8-30 MB.

Now the individual apps load, except it’s not that simple. Many apps have several components, the frontend (user interface) called “process”, and the backend (“services”). Due to the way the apps work under the Android OS they usually take up at least 3 MB of RAM even though the app itself appears to be only a few hundred KB in size. Some can use a lot more RAM.

Check the Services screen. You will see each service takes up 2-5 (or more) MB, some may take 15 or more. That does not leave much for the apps, esp. when the “services” are often loaded automatically. The more apps you load (or start automatically), the less is available to the system.

Every widget you place on the screen is backed up by a service. If you have 5 widgets on screen, that’s another 20 MB or so gone. Subtract another 10-20 for live wallpaper (depending on complexity), and your consumed RAM is up to 160+ MB, and that’s BEFORE you actually run any programs!

The early Android phones are extremely RAM deficient. Original Google phone, the T-Mobile G1 has only 192MB internal storage, and original Motorola Droid has only 256MB. With 16)+ MB used up before any apps, this leaves almost NOTHING for the actual apps. The later Android phones like Samsung Galaxy S series expanded that to 512MB, and some of the latest phones are up to 768MB or even 1 GB in RAM. So keeping more internal memory free is easier on those phones.

So you’re probably wondering, if there’s only like 80-90MB of RAM available, how can you load like 100-200 MB of apps? What happens is the phone try to fit in more apps than the memory would allow, so it kills off “lower priority” apps and services in order to make room for other apps. However, those apps may request the system to load itself back into memory, so you have a CPU trying to fit X+Y programs into space that can only fit X, by time-sharing… Load apps to do something, then swap those out of memory and swap some others back in. This constant swap process is handled all in the background.

NOTE: The way system decides what to kill and what to load is rather complicated, so see the sidebar.

So the lesson learned is simple: load LESS stuff into RAM. And how do you load less stuff into RAM? Load less apps. Really, it is that simple.

Your App storage is important, but not as important as RAM. My phone shows I’ve used up 176MB of my 256MB of app storage just for apps and their cache and data. Each app you load also needs some space to store working data. So a small app of only a few hundred KB can be using several megabytes of data, both working data and cache. Web browser apps are notorious for keeping cache of several megabytes when it is only a few hundred KB in size.

To see how much app storage you got left, go to menu / Settings / Sd Card and Phone Storage. At the very bottom, under “internal Phone stroage”, it’ll tell you how much it has left.

So what can we do about this? Here are 6 normal tips and 4 advance tips.

Tip 1: Uninstall the apps you rarely use

It is obvious, but it’s still true: the less program you load, the more responsive the phone will be, because there are a LOT of free memory available. More memory will be available to the phone to actually RUN the programs.

If you want to save the app, use something like AppManager, AppMonster, or Titanium Backup to archive the apps you want to keep around to SD card. Or just redownload them when you need them.

Figure out which apps are taking up the most space by going to menu / Settings / Applications / Manage Applications / menu / sort by size (default is sort by alpha A-Z)

(You can also sort by size in AppBrain, but that’s the “total size”, not the “internal storage size”, which is not that useful)

Also see Tip #6: Do NOT use a Task Killer.

Tip 2: Move apps back from SD Card… if possible

(Yes, I know I used to recommend the exact opposite)

Apps are really meant to be run from internal storage. Move2SD is a neat feature, but SD card is still not as fast as internal storage (unless you have a Class 10 or faster). For the apps you use often, move them BACK INTO phone. They’ll actually run faster.

Tip 3: Use only the bare minimum number of widgets

Each widget loads a “service” or two to keep itself updated, and each service is 2-4 MB of space used, even if the widget itself is only like 50KB in size.

Look at the Services Screen yourself: How much is that pretty clock widget taking up? Probably 2-4 MB. Add another one for the music player, another one for the podcast player, another one for this, another one for that… They all add up.

Tip 4: Use a Static Wallpaper

Even a simple Live Wallpaper will take 2 MB or so of memory. Complicated ones may take up to 20MB. And that thing is running ALL THE TIME. It even sucks up CPU power (and battery). Thus, just use a static wallpaper.

Tip 5: Occasionally, Manually Kill Unnecessary Services

Seems every app nowadays comes with a service… and uses several MB of internal memory, even when they are NOT running.

Google Maps have a “Places” service that sometimes loads even when Maps is NOT loaded. Youtube sometimes loads a “widget service” even when it’s not running and have no widgets on screen. When you exit an app, the associated services are not always stopped with it.

Kill them manually (see “Running Services” sidebar above), tap any service to kill it. Make their space available to other apps. In fact, if you rarely use that app, uninstall it altogether. (See Tip #1)

Tip 6: Do NOT Use Task Killers on Automatic or Schedule

Advanced Task Killer and similar apps may interfere with the built-in memory management. The memory they free up is only temporary and may include running apps, which will be reloaded by the system in moments.

The best way NOT to overburden the system is to load less apps in the first place

You can have one loaded, but turn off any auto-kill or schedule-kill functions. Advanced Task Killer for Froyo by ReChild is what I use, but only very occasionally, and you can just go into services and kill individual services.

For more information on why NOT to use Task Killers, see my other hub: Android OS Task Killers.

Advanced Tips for Rooted Phones

The following advanced tips all require rooting the phone, which means you gain “superuser” status that allows you to read/write all portions of the phone, even the “system” sections, which normal users don’t have access to. Not all phones can be rooted, and rooting your phone MAY void your warranty. You do so at your own risk, and there are guides out there on how to root your phone. If the 6 tips above are somehow not enough to help you, try the four tips below.

Advanced Tip 1: Use AutoStarts or Autorun Manager to disable automatic startup of programs

REQUIRES ROOT!

The good apps can be set to NOT run at startup. The not-so-good ones just start without giving you a choice.

Use AutoStarts (paid app) or Autorun manager (free) and disable the startups of certain apps. Not all apps need to stay on all the time. AutoStarts can also prevent apps from being started by certain system events, such as “bluetooth on”. For example, if you have an app that’s supposed to be triggered by the camera button, but isn’t, the only way you’ll diagnose it is run AutoStarts and see which app is hooked into that event and disable it.

There are a lot of programs that claims to stop “autorun” or “autostart”, but this is the original, and it really does work. The ones that don’t require root only works about half of the time.

Advanced Tip 2: Use Auto Memory Manager or AutoKiller to tweak settings

REQUIRES ROOT!

Use Auto Memory Manager or AutoKiller to tweak the built-in memory manager to be more aggressive or just somewhat more active (i.e. “mild”) than the default setting, which is VERY conservative.

This means you don’t need to mess with a task killer at all (except for certain instances). I have mine set on “mild”.

Advanced Tip 3: Load an Overclocked Kernel

REQUIRES ROOT!

Load an overclocking kernel so you can overclock the CPU in your Android phone. The OMAP CPU in the original Moto Droid is designed for 600 MHz, but is clocked at only 550 MHz for better battery life. However, it can be easily overclocked to 800 MHz without modification, and perhaps even 1.2 or 1.25 GHz (depending on how lucky you are) by loading a new kernel.

Keep in mind there are dozens of different alternate kernels out there and they are written for a specific phone model and specific clock speed. You will need to know how to boot into “recovery mode” in case your kernel experimentation did not work out.

I have mine set to 1.1 GHz and it never had any problems.

Advanced Tip 4: Load a new Custom ROM altogether

REQUIRES ROOT!

People love Customs ROMs, and many are noticeably faster (though a lot of it is from completely wiping out all the apps). Still, it is a valid way to “start over” with your phone.
For almost every model of Android phone (at least the popular ones) there are custom ROM developers making custom ROMs for it. The original Motorola Droid, i.e. OG Droid, had a dozen or more custom ROMs, the best known of which: Cyanogen Mod (which gradually expanded to support over a dozen different phones). However, there’s also Liquid, Alfonso, MIUI, and many more.

Following is the tutorial for installing Oracle VM server through PXE.

Requirement
PXE Server
Oracle VM Server 3.0.2

Step 1 Download & Mount OracleVM-Server.iso

mount -o loop /storage/os/OracleVM-Server-3.0.2.iso cd/

Step 2 Create folder to store oracle vm files.

mkdir -p /tftpboot/images/oraclevm/

Step 3 Copy required files to oraclevm folder under pxe.

cp cd/isolinux/mboot.c32 /tftpboot/images/oraclevm/
cp cd/isolinux/initrd.img /tftpboot/images/oraclevm/
cp cd/isolinux/vmlinuz /tftpboot/images/oraclevm/
cp cd/isolinux/xen.gz /tftpboot/images/oraclevm/

Step 4 append following lines in /tftpboot/pxelinux.cfg/default

LABEL ovs3
kernel images/oraclevm/mboot.c32
append images/oraclevm/xen.gz --- images/oraclevm/vmlinuz --- images/oraclevm/initrd.img

Thats all, now with pxe boot you’ll find option to boot using ovs. Once you boot from ovs pxe, you need to either give path of iso image using nfs store OR give http path where content of cd is copied / cd mounted.

Source @LINUXREADERS

HTC Incredible S is a very good smart phone of HTC. HTC Incredible S by default comes with Android v2.2(Froyo) which is getting outdated. Today I got a chance to root HTC Incredible S with Android Ice Cream flavour.

Remember : Rooting will thereby end up your warranty. There are always chances of bricking your phone while rooting so always prefer to back up all your data before rooting.

Note: You phone’s battery must be at least 60% charged before following this rooting tutorial. This version of ICS is not a stable version which means that you might face some bugs. The things which are not expected to work properly are as follows

• Proper UMS
• Proper Hardware acceleration
• WiFi Tethering
• USB Tethering
• Camera
• Some Other Bugs

Step 1 Start up by downloading the Android v4.0 Ice Cream Sandwich Package on your computer. Don’t rename the files in the package because once you do so, they won’t be recognized. Download the package from here.

Step 2 Connect your phone with the computer using the USB cable which everyone gets during the purchase.

Step 3 Now just copy the downloaded zip file to your phone and then safely remove the phone from computer.

Step 4 Now you need to enable USB debugging. You can do so by following this path Settings then Applications then Development and finally checking USB debugging.

Step 5 Now switch off your phone and restart it in recovery mode. To start it in recovery mode, hold and press volume down key and power button key. If you will follow the steps as mentioned, you will make it to the boot loader mode.

Step 6 Now tap the recovery option from the boot loaded mode.

Step 7 Now tap Clear Storage in order to remove all the cache data.Step 8 – Now select the install zip from SD Card option and then tap the Choose zip from SD Card option. Now select the Ice Cream Sandwich Package from the location where you saved it.

Step 9 It will take 15-20 minutes for HTC Incredible S to get rooted, wait till then and don’t stop the procedure in-between. After the procedure is complete tap “++++ Go Back ++++” and reboot system now.

Step 10 Once your phone gets rebooted, it will load up in ICS custom ROM. And if it doesn’t then you have to repeat the tutorial once again.

That’s it. Enjoy your new OS

Is it possible to disable GUI / X at boot time? So many Ubuntu 11.10 Desktop edition users are asking the same question. On my ubuntu machine I have done following steps to disable GUI boot in ubuntu 11.10

Step 1 First update your repository by running

sudo apt-get update

Step 2 There is some bug in old version of lightdm, so we need to upgrade the same. To do so run,

sudo apt-get install lightdm

Step 3 Now we have to modify grub config.
Step 3a Open /etc/default/grub with your faviourite editor and change

GRUB_CMDLINE_LINUX_DEFAULT="quiet splash"

to

GRUB_CMDLINE_LINUX_DEFAULT="text"

Step 3b Also comment GRUB_HIDDEN_TIMEOUT=0 This line is for unhiding the GRUB menu

Step 4 Now we will upgrade GRUB configuration

sudo update-grub

Step 5 Ubuntu 11.10 Desktop edition use lightdm for GUI. We need to disable the same

sudo update-rc.d -f lightdm remove

Step 6 Now restart your machine. Voilla you will be in console mode

At any time you need after booting your system you want to change to gui mode the run

startx

If you want to restore Ubuntu’s GUI mode then

Open /etc/default/grub with your faviourite editor and change

GRUB_CMDLINE_LINUX_DEFAULT="text"

to

GRUB_CMDLINE_LINUX_DEFAULT="quiet splash"

Update GRUB by running

sudo update-grub

To restore lightdm run

sudo update-rc.d lightdm defaults

That’s it

MySQL is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. MySQL is a freely downloadable version of the world’s most popular open source database that is supported by an active community of open source developers and enthusiasts. The MySQL development project has made its source code available under the terms of the GNU General Public License, as well as under a variety of proprietary agreements. MySQL was owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, now owned by Oracle Corporation.

Free-software-open source projects that require a full-featured database management system often use MySQL. Applications which use MySQL databases include: TYPO3, Joomla, WordPress, phpBB, Drupal and other software built on the LAMP software stack. MySQL is also used in many high-profile, large-scale World Wide Web products, including Wikipedia, Google(though not for searches), Facebook, and Twitter.

From last couple of days I am struggling to install mysql-server-5 on Ubuntu 11.10 by apt-get. So finally I decided to install mysql from source.

In this tutorial we will install mysql in /usr/local/mysql directory

Get Packages to compile the source.

sudo apt-get install cmake g++ libncurses5-dev bison libaio-dev

Creating directory to download source file

mkdir /usr/local/src/
cd /usr/local/src

Download the 5.5.19 version of mysql.

wget http://ftp.jaist.ac.jp/pub/mysql/Downloads/MySQL-5.5/mysql-5.5.19.tar.gz
tar -xvzf mysql-5.5.19.tar.gz

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

cd /usr/local/src/mysql-5.5.19
make -LAH > options

Make MySQL

cmake .
make

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.

groupadd mysql
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

make install DESTDIR="/custom/path"

Install in the default /usr/local/mysql directory

make install
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.

cd /usr/local/mysql

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

chown -R mysql .
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:

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:

chown -R root .
chown -R mysql data

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

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/ubuntu.home.network.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:

./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.

cd /usr/local/src/mysql-5.5.19
cp support-files/my-huge.cnf /etc/my.cnf

Configure MySQL to start automatically. I have a feeling this isn’t necessary any more, but no harm trying to do it again

cd /usr/local/src/mysql-5.5.19
cp ./support-files/mysql.server /etc/init.d/mysql
chmod +x /etc/init.d/mysql
update-rc.d mysql defaults

Test this. The following command should display a few dots then a star. Then hopefully MySQL is running!

/etc/init.d/mysql start

I prefer to add a link to the mysql binaries I use in /usr/bin than add MySQL’s bin directory to the path:

ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql
ln -s /usr/local/mysql/bin/mysqldump /usr/bin/mysqldump

Now we can connect:

mysql -u root -p

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.5.19-log Source distribution
 
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
 
mysql> show tables;
ERROR 1046 (3D000): No database selected
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| test               |
+--------------------+
3 rows in set (0.00 sec)
 
mysql> exit
Bye

That’s it. Installation complete.