How to know if MySQL Server is running?

Here are some of my compilations using command line.

For those who are lost in linuxworld here is my simple guide.

1. If you already install MySQL, look at the processes in System/Administration/System Monitor to see if MySQL is running. If you are on the command line try

~$ : ps -aux | grep mysql

If it is running, you should be able to login from the console with this command

~$ : mysql -u username -p”

it will ask the password. It assumes the host name is localhost, i.e. the machine itself.

Other way around to be sure it is running

~$ : sudo /etc/init.d/mysql status

or

~$ : mysql -u root -p

If in case you forget or don’t remember your MySQL password this command will help you.

~$ : sudo dpkg-reconfigure mysql-server-5.0

Install an RPM Package on Ubuntu Linux

Installing software on Ubuntu usually entails using Synaptic or by using an apt-get command from the terminal. Unfortunately, there are still a number of packages out there that are only distributed in RPM format.

There’s a utility called Alien that converts packages from one format to the other. This doesn’t always mean that an rpm will work on your system, though. You will need to install some prerequisite software packages in order to install alien, however. These packages include gcc and make.

Run this command to install alien and other necessary packages:

sudo apt-get install alien dpkg-dev debhelper build-essential

To convert a package from rpm to debian format, use this command syntax. The sudo may not be necessary, but we’ll include it just in case.

sudo alien packagename.rpm

To install the package, you’ll use the dpkg utility, which is the internal package management tool behind debian and Ubuntu.

sudo dpkg -i packagename.deb

The package should now be installed, providing it’s compatible with your system.

HOW TO : Graphical IP Blocker on Ubuntu karmic koala

 

This article describes how to block lists with a graphical front-end called IPblock. No knowledge of networking, firewalls or command-line configuration are needed. Due to the way IPblock works it doesn’t change the behavior of existing firewalls which makes it compatible [1] with other firewall applications like ufw, shorewall or fireHOL. This howto is intended for Beginners and was tested on Ubuntu Feisty, Gutsy, Hardy, Intrepid, Jaunty and Karmic (32-bit and 64-bit).

Installation
Add the iplist repository to your sources.list. Make sure to use the correct sources.list that corresponds to your current distribution:

Code:

sudo wget http://iplist.sf.net/sources.list.d/karmic.list -O /etc/apt/sources.list.d/iplist.list

The key of the signed packages can be imported like this:

sudo apt-key adv --recv-keys --keyserver keyserver.ubuntu.com C6E3D905C8BCD56BB02E6E0B39456311108B243F

There is also another way to import the key. You could save the pub key to a file and import it through System->Administration->Software Sources->Authentication->Import Key-file.

After an update of the Software sources iplist can be installed with any package manager. E.g.:

sudo aptitude update
sudo aptitude install iplist

Note: If sun-java* is installed by gdebi it requires to open the terminal part of gdebi and accept sun’s license agreement.
Packages for Feisty and Gutsy can be found in the 0.19 release.

After the installation IPblock can be found in Applications -> Internet -> IPblock.

Lists

The default choice for lists is similar to PeerGuardian

.

• level1.gz – Anti-P2P organizations and known government addresses
• ads-trackers-and-bad-pr0n.gz – Advertising and data tracker servers
• spyware.gz – Malicious spyware and adware servers
• edu.gz – Educational institutions and universities
• bogon.gz – Spoofed IP-addresses

These lists are maintained by www.bluetack.co.uk (list descriptions). Custom p2p or dat lists can easily be added. Note that lists can optionally be compressed with gzip.
The URL file /etc/ipblock.lists contains list descriptions.

Settings

All options can be configured in this and the network tab. Auto-updating lists is important and the default choice of 2 days is reasonable. Using out-of-date lists is not recommended.
To ignore outgoing network traffic like HTTP or EMAIL (pop3) use the ignored ports section. Note that http and dns (domain) is ignored by default. The connection-settings specify which type of connections should be filtered.

[1] NOTE: IPblock needs to be started after other firewall applications.

FAQ on iplist.sf.net

For Multiple OS

If any of you would like to have multiple OS you can use CRUB2 please click here for more info.

Ubuntu 9.10 (Karmic Koala) – Download Site

For those who would like to try UBUNTU 9.10 code name Karmic Koala please click here

Install Adobe Reader on Ubuntu 9.10 Karmic Koala

You can install the official Adobe Reader in Ubuntu 9.10 (Karmic Koala).
Download .deb package from here called Linux- x86 (.deb)

Apache on Ubuntu Guide

 

Terminal command for installing Apache On Ubuntu:

sudo apt-get install apache2 php5 mysql-client-5.0 mysql-server-5.0 phpmyadmin libapache2-mod-php5 libapache2-mod-auth-mysql php5-mysql

then restart the computer/start mysql manually

From:  Ubuntu installation tutorial for Apache

HOW TO: Using checkinstall to make .debs from sources

So you want that app… yes… THAT app, so you goto the website… but… DAMN no .deb file only source files.
If you’re anything like me, you hate ./configure, make, make install you just want an easy .deb package, for easy install and removing.
Well, checkinstall does that for you. Checkinstall eliminates the ‘make install’ area and creates AND installs a .deb package for you, therefore you can remove it with a simple ‘dpkg -r foo’ or in synaptic.

The first thing you need to do is install check install. So we have to uncomment universe, and apt-get check install like so:

sudo gedit /etc/apt/sources.list

then uncomment universe so it looks like this

deb http://archive.ubuntu.com/ubuntu/ warty universe

deb-src http://archive.ubuntu.com/ubuntu/ warty universe

save and exit.

Then, open synaptic and search for checkinstall (make sure you update first) or…

sudo apt-get update && apt-get install checkinstall

Reading Package Lists… Done

Building Dependency Tree… Done

The following NEW packages will be installed:

checkinstall

0 upgraded, 1 newly installed, 0 to remove and 0 not upgraded.

Need to get 34.8kB of archives.

After unpacking 135kB of additional disk space will be used.

Enter Y to install.

Now, download that source file you need, unpack it using ‘tar zxvf (or jxvf) foo’ and cd to that sources directory.

then do the usual.

~/Path/to/folder:$ ./configure

when that is done

~/path/to/folder:$ make

let that finish, then, instead of doing a ‘make install’ do this:

~/path/to/folder:$ sudo checkinstall

accept all the defaults, then an option will come up to set a description. You can set one, then hit enter twice, or just hit enter. Select the next default. And that’s it.

You’re done!!

Checkinstall installed the new .deb package for you, and put a copy of the package into that foler you were working in. Now you can move that .deb package where ever you want it and delete that folder.
Now if you want to remove that package, just ‘dpkg -r pkgname’ or ‘apt-get remove pkgname’ or do it in synaptic.

Ubuntu Desktop Computing Made Easy (Ubuntu 9.04)

This documentation is intended for folks that would like to add additional programs and applications to
their Ubuntu Desktop installation making their overall experience similar to that of other well known
operating systems (less the huge software expense).

Download Links:

GYachE Improve

Since i was using LINUX (Ubuntu)

Download offline package