Installing MySQL Server 5.1 and MySQL Workbench 5.2.39 in Ubuntu 11.10

Here we will see how to install MySQL server and MySQL workbench in Ubuntu 11.10. I will install MySQL server 5.1 as part of this tutorial.

So here we go....

Install MySQL Server 5.1

1. Check for existing mysql installations.
   
2. sudo apt-get install mysql-server
   
   
   Enter root password and click OK.
   
   Retype root password and click OK.
3. By now MySQL should be running. Test it using the command
   sudo netstat -tap | grep mysql
   
4. In case mysql is not started, you can restart it using below command
   sudo service mysql restart
   

Install MySQL Workbench 5.2.39

You can install workbench in 2 ways. One is by using sudo apt-get and other is by downloading .DEB file from mysql.com, here is the link. In the above step we have seen installing using sudo apt-get, lets try using GUI installer this time.

GUI installation using .DEB file

1. Download the .deb file from mysql site.
   
   
   
2. Double click the .deb file to launch installer
   
   
3. Click Install
   
   
4. Installation complete
   
5. Test it once
   
   

For those who are interested in sudo apt-get, use the below commands

1. sudo add-apt-repository ppa:olivier-berten/misc
2. sudo apt-get update
3. sudo apt-get install mysql-workbench-gpl

Read more on Ubuntu site about installing MySQL Server and MySQL Workbench.