slider

Stay Connected Elegance Beauty Features Simplicity

Sunday, May 25, 2014

Mysql and Mysql WorkBench

Install MySQL

To install MySQL , you can search in Software Center. Type MySQL and select MySQL  Server and install it




Or else you can type the following in the Terminal

:~$ sudo apt-get install mysql-server

Once the installation is complete, the MySQL server should be started automatically. You can run the following command from a terminal prompt to check whether the MySQL server is running

 :~$ sudo netstat -tap | grep mysql

When you run this command, you should see the following line or something similar

tcp    0   0  localhost:mysql *:*     LISTEN   2556/mysqld

If the server is not running correctly, you can type the following command to start it

sudo service mysql restart


Install MySQL workbench

To install the mysql workbench, you must first install mysql server. Then You can either install it from Software Center or Open up the Terminal and enter the following code.
sudo add-apt-repository ppa:olivier-berten/misc

The above code will add the necessary repository. Then to update the repo's type the following line
 
sudo apt-get update
 

And a last enter folowing code to instal the workbench
sudo apt-get install mysql-workbench

 
Enjoy databases...!!! :) :) :)



No comments:

Post a Comment