Tag Archives: dbms


how to install MySQL server on Ubuntu 11.10

MySQL is one of the most popular open source Relation Database Management System (RDBMS), used very widely developing database based Applications – it’s specifically very popular in web development (The blog – you’re reading right now, is based on wordpress, which also uses MySQL databases for storing contents such as post, category, comments, and other meta data). Since Ubuntu (11.10 beta 2 – latest version, final is coming within few weeks) has now become the most popular choice for application development, LAMP (Linux, Apache, MySQL and PHP).

most popular open source RDBMS

In Ubuntu 11.10 (based on Gnome 3), synaptic package manager has been removed so you can use Ubuntu Software Center or terminal (or install synaptic package manager in Ubuntu 11.10 (Oneiric Ocelot) if it’s you favorite application for managing application – although due to some major improvements in Ubuntu Software Center you might not need it anymore).

In Ubuntu or any other Linux based systems there are lot of other database programs are also available such as SQLite, mongoDB, H2, CouchDB, etc but MySQL is probably the most reliable, fast and powerful database – although it depends on the type of application or your interest.

 Installing MySQL in Ubuntu 11.10 – Oneiric Ocelot

I prefer Terminal for managing applications, as I think it’s very handy, although installing new softwares/Apps from Software center is also very simple – just search for the mysql server meta package (if you don’t know the actual name of the package then search using name of equivalent proprietary software, e.g if you search for Photoshop then you will get GIMP) which will automatically select the latest version and click on Install button….and wait for the download/installation procedure to finish and you’re done!

1. Open a terminal (Ctrl+Alt+t) and execute the following command(s)

sudo apt-get install mysql-server

2. During the installation process – you will be prompted to set the password for root user (for MySQL server).


Then, enter the password again (for confirmation) and the installation process will complete within a minute.


3. That’s All..you’re successfully installed the mysql server, client and other dependent packages successfully.

Login to MySQL Server in Ubuntu @localhost

using mysql-server in localhost

Now, you’ve mysql program installed on your computer, you can start creating databases, tables, users ..whatever you want! Login using terminal or install a query browser tool (search in Software Center). In terminal execute the command –

mysql -u root -h localhost -p

Then enter your root password (you entered during installation – step#2 ) and you will get the mysql prompt.


Just for testing purpose, lets create a database. Execute the following commands –

create database forfun;
show databases;

Have Fun!


How to install MySQL on Ubuntu 11.04

MySQL is the most popular database, mostly used in developing database driven websites or in other words web Applications (Web Apps or Apps). it’s Free and open source. MySQL is a Relational Database Management System (RDBMS), that runs like a server and serves the requests (usually CRUD (Create, Retrieve, Update, Delete) operations) from the clients.

On Ubuntu 11.04 (Alias : Natty Narwhal) , if you want to use any database server, then of course MySQL is the best choice. This post will guide you in installing MySQL server/client (current version : 5.1) from Synaptic Package Manager or Command Line. In last I’ll also show you, how to connect to the MySQL database at the Terminal/shell, although you can also install use graphical tool to manage MySQL database – e.g MySQL Query Browser, MySQL Administrator or phpMyAdmin. MySQL is very popular in the combination of : LAMP – Linux, Apache, MySQL and PHP.

Installing MySQL Server on Ubuntu 11.04

From Synaptic Package Manager

#1 : Open Synaptic Package Manager and search for ‘mysql’. Then select (check the box) the mysql server 5.1 to install. If you want to install some other packages, then click on yes, if it asks for dependencies.


#2 : Then click on Apply and wait for the installation to complete.

#3 : In the , middle of the installation you will be prompted to Enter the MySQL ROOT Password. Enter a good password for that, but remember!, you need this password to manage the MySQL databases and users, so don’t forget!!

mysql root password

#4 : Relax, until the installation is complete.

From Terminal

sudo apt-get install mysql-server

Now you can connect to MySQL server using the command (In the example the Server Address : localhost, Username : root) –

mysql -h localhost -u root -p

Then Enter your Password (ROOT Password, that you entered in step #3) to connect to the server running at localhost.

Connecting to MySQL server

how to install MySQL on ubuntu 10.10

On Ubuntu 10.10(Maverick Meerkat) MySQL(server/client) Database Management System is recommended because it’s free,open source,fast and easy to install.MySQL is one of the most widely used DBMS specifically for web development.PHP+MySQL is a De Facto standard for creating dynamic websites.The most widely preferred cms(Content Management System) i.e wordpress(This blog is also running on wordpress) also uses PHP+MySQL to generate dynamic pages.

Installing MySQL in Ubuntu 10.10


#1. Open Synaptic Package Manager and search for ‘mysql’ or ‘mysql 5’ and select the packages(client and server) you need.

#2. Then click on Apply button to begin the installation procedure.In the middle of the installation you will be prompted for MySQL root password,set strong password for MySQL server.You will need this password for logging to your MySQL server account,with administrative power.


#3. Next installation will complete within a minute.You can start using your server/client now.Open terminal and Type the following command :

mysql -u user -h host –p                //Then Enter the User’s Password

In this scenario,the user is ‘root’ and in host use ‘localhost’;so the actual command will be

mysql -u root -h localhost –p


That’s All…I hope,Now you are enjoying MySQL..don’t forget to comment specially in case of any problems related to MySQL and Ubuntu 10.10