Your Webhosting Questions
Answered by the Webhosting Experts
See where the internet lives
Back to: Operating System
Create a Free Account
Chat with an Expert
Configure a Bare Metal Server
Latest
Categories +
...

How to install Mysql on Ubuntu 14.04 LTS server

  1. Login to your Ubuntu server with root user with your favorite SSH client

  2. Let’s first update the operating system with all the latest packages with the command

    sudo apt-get update

  1. In order to install mysql use the command as below

    apt-get install mysql-server php5-mysql

  1. On the next screen , set the root password for Mysql server , Use the tab to move the cursor on OK button and press enter.

  1. We are done with installing Mysql

  1. Let’s configure and secure the Mysql server in order to use it with the commands

    mysql_install_db
    mysql_secure_installation

  1. In order to secure the Mysql installation you will need to answer a series of questions as below

  • Enter current password for root (enter for none): Provide the root password

  • Change the root password n

  • Remove anonymous users Y

  • Remove anonymous users Y

  • Disallow root logins remotely Y

  • Disallow root login remotely Y

  • Remove test database and access to it Y

  • And reload privilege tables Y

  • Reload privilege tables now Y

     

  1. We are done with securing the Mysql server installation. Let’s verify it with the command

    mysql –V

  1. Lets restart the Mysql service with the command

    service mysql restart

  1. You are done.

Need More Personalized Help?

If you have any further issues, questions, or would like some assistance checking on this or anything else, please reach out to us from your my.hivelocity.net account and provide your server credentials within the encrypted field for the best possible security and support.

If you are unable to reach your my.hivelocity.net account or if you are on the go, please reach out from your valid my.hivelocity.net account email to us here at: support@hivelocity.net. We are also available to you through our phone and live chat system 24/7/365.