Monday 4 November 2013

Season of Dark : MySQL in Ubuntu 12.04


Now, this time lets install MySQL in our Ubuntu 12.04. MySQL is a popular open source database. MySQL is more supported than any other types in Ubuntu. MySQL Workbench, which is an administrative and development tool for MySQL DB, released its newer version 6.0, which looks great, and easy to handle in Ubuntu. The GUI of workbench is seems to be user friendly as well as attractive. And I like dark themes particularly :) Lets see what all are the essential steps to install MySQL. Before trying this, please see the sitepoint.com webpage . It helped me a lot to know more things during installation. Thanks for that. I will mention only the basic things.

1. Install mysql client & server :
          
         Open Terminal (Ctrl+Alt+T)

    sudo apt-get install mysql-server mysql-client

It wont take much time to install if you have a good Internet connection.
          
         sudo mysql_secure_installation

You may have to give a password, remember to note it somewhere, because it is so important. There are some steps, where we just leave by give 'Y' as input to continue with the installation. If you are really interested, check that previously mentioned site for more info.

2. Configuration can be done on the my.cnf file by editing it in a text editor :
       
         sudo gedit /etc/mysql/my.cnf

3. Install MySQL Workbench :
         
        sudo apt-get install mysql-workbench

You can also create a short cut in the desktop for easy access. So start doing sql in 'Your MySQL'.


MySQL Workbench Home page

No comments:

Post a Comment