Installing mysql on Ubuntu

I wanted to install mysql on my Ubuntu os. As a biginner to Ubuntu I found that it's some what difficult thing to do. However I came across my problem after struggling two days with command terminal. I'd like to share my experiences, faults I which have faced during my installation process.
First I found out that I must install mysql-client and mysql-server. So I used (I suggest you to use the root account during this)

sudo apt-get install mysql-client mysql-server

(Note: You must be online when you are doing this)

This will install mysql for you. You just only need to follow the instructins that asked to do. But in my case this wasn't done, I was ended up with an error

Err http://archive.ubuntu.schoolnet.lk/ubuntu/maverick-updates/main mysql-server all 5.1.49-1ubuntu8.1 403 Forbidden

And so on. 

I couldn't understood the exact reason for that but I think my weak network connection might cause for that. Well.., I was not in a mind to give up this. So I went through the link which showed in the error message and I downloaded those files from the archive

(Note: http://archive.ubuntu.schoolnet.lk/ is dedicated ubuntu archive for Sri Lanka. If haven't configured your PC to the nearest ubuntu server at your location, you have to do it first)

After Downloading those missing stuffs I installed those packages using below command

 dpkg -i mysql server_5.1.49-1ubuntu8.1_all.deb

You'll have to answer some questions like password, etc
proceed with the process. After that process you have installed mysql successfully. To check whether it's working or not use:

netstat -tap | grep mysql
If it's working properly you'll see something like this

~$ netstat -tap | grep mysql
tcp        0      0 localhost.localdo:mysql *:*              LISTEN    -              

Finally to run the mysql on command terminal 

mysql -u root -h localhost -p
Then it'll ask for the password. give the password which you have given in the installation process. That's all, now you can see the command terminall turned in to a mysql console.

mysql -u root -h localhost -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 40
Server version: 5.1.49-1ubuntu8.1 (Ubuntu)

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>


To exit from the mysql console:

mysql> exit

device is not ready (firmware missing)...!!

Hi there, Nowadays I'm playing around Ubuntu 10.10 because I had to do big works with command terminal which need for my 2nd semester subjects. I haven't installed Ubuntu to my laptop (Dell XPS M1210) before. But I knew I'll have to get it soon to my laptop. However I was in a doubt whether my laptop can bear two OS's because my HDD is too small comparatively to others. Whatever I decided to install Ubuntu 10.10 and no matter, it's running easily. But I saw that my wi-fi status indicator not coming to active status even I switched it into active mode. And I saw the network connections icon in top of the desktop is showing a red exclamation mark also. It's indicating "device is not ready (firmware missing)" under the wireless networks. Finally I found a solution for that after surfing some web sites. There are two solutions as I got it. If you can gain a Internet connection using other source like wired Ethernet, etc. It'll be a easy case for you. 

Here's the correct place you must follow: http://wireless.kernel.org/