Installing MySQL 5.5.12 on Ubuntu 10.04 (Lucid)

Here we have a step by step tutorial for installing MySQL 5.5.12 on a machine with a fresh install of Ubuntu 10.04 (lucid).

I could not find a tutorial and we needed MySQL 5.5 over MySQL 5.1 for one of our development farms.

Let’s start:

Get MySQL 5.5.12

Change directory into mysql-5.5.12 and make && make install

Chown/Chgrp and copy files

Start the services and create MySQL users

Task: MySQL list databases MySQL is a simple command-line tool. MySQL is command line and it is very easy to use. Invoke it from the prompt of your command interpreter as follows:


Output:

You may need to provide mysql username, password and hostname, use:


To list database type the following command

information_schema and mysql are name of databases. To use these database and to list available tables type the following two commands:
mysql> use mysql;Output:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Now list tables:

Share on FacebookShare on Google+Email this to someoneShare on RedditShare on LinkedInShare on TumblrTweet about this on TwitterShare on StumbleUpon

Leave a Reply

Your email address will not be published.