Installing MySQL server in Linux

These are the steps to install the mysql database into Unix

Ensure these libraries in the system. Depending on which linux flavor i'm using, i can simply go into their database get the libraries.
Libraries that i require are

• libsdc++5
• libncurse5-dev
• g++

For SUSE, install these additional libraries

• termcap
• ncurses

Open the folder where you store the mysql tar installer.

# tar zxvf mysql-xxx.tar.gz


After unzip, cd in the directory we just tar

Create user and usergroups first.

# /usr/sbin/groupadd mysql

# /usr/sbin/useradd -g mysql mysql

Inside, type these commands (check mysql documentation for further explanation at their website)

# ./configure –prefix=/usr/local/mysql –localstatedir=/usr/local/mysql/data –disable-maintainer-mode –with-mysql-user=mysql –enable-large-files-without-debug

# make
# make install

Now lets install the default data into mysql. Make sure i'm still in the mysql directory
# ./scripts/mysql_install_db

Change ownership of the mySQL directory. (It is now in root status).
# chown -R root:mysql /usr/local/mysql
# chown -R mysql:mysql /usr/local/mysql/data

Start the server

# usr/local/mysql/bin/mysqld_safe --user=mysql &

Check if server is starting
# /usr/local/mysql/bin/mysqladmin ping

If it says sqld is alive, its running.