How to Install MySQL on Ubuntu 14.04 LTS

Pre-Flight Check
  • These instructions are intended for installing MySQL on a single Ubuntu 14.04 LTS node.
  • I’ll be working from a Liquid Web Self Managed Ubuntu 14.04 LTS server, and I’ll be logged in as root.

Step 1: Install MySQL

First, you’ll follow a simple best practice: ensuring the list of available packages is up to date before installing anything new.

apt-get update

Installing MySQL is as simple as running just one command:

apt-get install mysql-server php5-mysql

You may receive the following prompt or something similar:

After this operation, 98.2 MB of additional disk space will be used.
Do you want to continue? [Y/n]

Enter Y to continue.

Next you’ll be asked:

New password for the MySQL “root” user:

How To Install MySQL on Ubuntu 14.04 LTS

This is an administrative account in MySQL with elevated privileges; enter a strong password.

Then you’ll be asked to verify the root MySQL password:

Repeat password for the MySQL “root” user:

How To Install MySQL on Ubuntu 14.04 LTS

That’s it! Your basic MySQL installation is now complete!

Step 2: Configure and Secure MySQL for Use

Now we’ll instruct MySQL to create its database directory structure:

mysql_install_db

And now let’s secure MySQL by removing the test databases and anonymous user created by default:

mysql_secure_installation

You’ll be prompted to enter your current password. Enter the root MySQL password set during installation:

Enter current password for root (enter for none):

Then, assuming you set a strong root password, go ahead and enter n at the following prompt:

Change the root password? [Y/n] n

Remove anonymous users, Y:

Remove anonymous users? [Y/n] Y

Disallow root logins remotely, Y:

Disallow root login remotely? [Y/n] Y

Remove test database and access to it, Y:

Remove test database and access to it? [Y/n] Y

And reload privilege tables, Y:

Reload privilege tables now? [Y/n] Y

Step 3: Verify MySQL Installation

You can check the version of the MySQL installation with the following command:

mysql -V

Enter the MySQL command client:

mysql -p

You’ll be asked for the root password for the MySQL server, which was set earlier in this tutorial:

Enter password:

And then you should be greeted with the following:

Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 47
Server version: 5.5.40-0ubuntu0.14.04.1 (Ubuntu)

Copyright (c) 2000, 2014, 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>

Exit the command line with the following command:

exit

To stop MySQL:

service mysql stop

To start MySQL:

service mysql start

To check the status of MySQL:

service mysql status

To restart MySQL:

service mysql restart

Be Sociable, Share!
Here's $75, Launch a New VPS Today. Find out why 30,000 customers have chosen our Best-in-Class Performance & 24x7 Heroic Support.