RSS Feed

Getting started with MySQL on Ubuntu

Posted on

Go to Ubuntu Software Center(Applications>Ubuntu Software Center)

Search for MySQL and find ‘MySQL Server’ in the list.

Install it. Use a password if you want one.

Open the Terminal(Shell or Command Line). Type the following to see if correctly installed.

mysql --version

For me, it returned the following

mysql  Ver 14.14 Distrib 5.1.41, for debian-linux-gnu (i486) using readline 6.1

Once installed correctly, you have to start the mysql server. Use the following command.
sudo /etc/init.d/mysql start

If the root doesn’t have a password, use the following command to set password

mysqladmin -u root password myPassword

Then, to login to the server as root, use the following command

mysql -u root -p

Type in the password and just get ready for some awesomeness!

 

Pure Awesomeness

If you are a beginner, just read through this tutorial.

About Sundeep

For some strange reasons, I always will be 'what I wanted to be' rather than 'what I am'. I finished my under-grad and I'm working for a Software company as a developer. I love learning(with earning, of course) and teaching.

One Response »

  1. Pingback: MySQL 5.5 on Ubuntu 10.10 :: Things n' Stuff

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.