Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
  • How to install MySQL on Ubuntu 14.04

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 428
    Comment on it

    How to Install MySQL on Ubuntu:

    Step 1 - Installing MySQL

    To install MySQL you need to update the package index on your server and then install the package with apt-get.

    Write the following commands to install MySQL

    $ sudo apt-get update
    $ sudo apt-get install mysql-server

    Now you'll be prompted to create a root password during the installation. Choose a secure password as you will be asked for the same password later.

    Step 2- Configuring MySQL

     

    $ sudo mysql_secure_installation

    This command will prompt you for the root password you created in step one. Now you can press ENTER to accept the defaults for all the questions.

    Next, we'll initialize the MySQL data directory, which is where MySQL stores its data. You can now check your version of MySQL with the following command.

    $ mysql --version

     

    You'll see some output like this:

    OUTPUT
    
    mysql  Ver 14.14 Distrib 5.7.11, for Linux (x86_64) using  EditLine wrapper

     

    Step 3- Testing MySQL

    MySQL should have started running automatically. To test this, check its status.

    $ service mysql status

    You'll see the following output (with a different PID).

    mysql start/running, process 2689

    If MySQL is not running, you can start MySQL with following commad line:

    $ sudo service mysql start

     

    All done now, MySQL is successfully installed on Ubuntu.

     

    Thanks for reading this blog

 0 Comment(s)

Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: