MySQL Installation on SLES

1. Download MySQL binary from
http://dev.mysql.com/downloads/mysql/

2. Unzip the bunddle
MySQL-client-5.5.36-1.sles11.x86_64.rpm  MySQL-embedded-5.5.36-1.sles11.x86_64.rpm  MySQL-shared-5.5.36-1.sles11.x86_64.rpm         MySQL-test-5.5.36-1.sles11.x86_64.rpm
MySQL-devel-5.5.36-1.sles11.x86_64.rpm   MySQL-server-5.5.36-1.sles11.x86_64.rpm    MySQL-shared-compat-5.5.36-1.sles11.x86_64.rpm
3. Install Server and Client
# zypper install MySQL-server-5.5.36-1.sles11.x86_64.rpm MySQL-client-5.5.36-1.sles11.x86_64.rpm

4. Start up MySQL
# /usr/bin/mysqld_safe &


if you got error as below:
Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist

Solution:
# mysql_install_db --user=mysql --ldata=/var/lib/mysql/

Solaris Mount NFS 3 using NFS 4 Client

Reconfigure the NFS client on Solaris to force the max. supported version of NFS to NFSv3. You change this by modifying the following line in /etc/default/nfs:

#NFS_CLIENT_VERSMAX=4

to:

NFS_CLIENT_VERSMAX=3

Then issue:

svcadm refresh svc:/network/nfs/client:default 

 Or:

# mount -o vers=3  nfs3.goweekend.ca:/nfsshare /nfsshare

Solaris Find out the PID which using specified port number

#!/bin/bash

if [ $# -ne 1 ]; then
  echo "Usage:"
  echo "        $0 <port number?"
  exit $LINENO
fi

portNumber=$1
for i in `ls /proc`
do
  pfiles $i | grep AF_INET | grep "port: ${portNumber}$"
  if [ $? -eq 0 ]
  then
    echo Is owned by pid $i
    pargs $i
  fi
done