Thursday, February 27, 2014

How to install MYSQL on ubuntu Linux

Step 1: Open Terminal (CTRL+ALT+T)
Step 2: Type following command
          sudo apt-get install mysql-server
            After few minutes it will ask for mysql root user password .Repeat
            password for two  times that will be used to login on mysql server as a
            root user. Please do remember the password.
Step 3: Start mysql service.Type following command.
          sudo service mysql start
Step 4: Connet to mysql server.Type following command
          mysql -u root -p
            Then it will ask for password given at the time of installation .After
            successful login credentials you will get  message and mysql prompt as
            below:


Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 64
Server version: 5.1.69-0ubuntu0.11.10.1 (Ubuntu)

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

No comments:

Post a Comment