- 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.
First, you’ll follow a simple best practice: ensuring the list of available packages is up to date before installing anything new.
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:
Do you want to continue? [Y/n]
Next you’ll be asked:
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:
That’s it! Your basic MySQL installation is now complete!
Now we’ll instruct MySQL to create its database directory structure:
And now let’s secure MySQL by removing the test databases and anonymous user created by default:
You’ll be prompted to enter your current password. Enter the root MySQL password set during installation:
Then, assuming you set a strong root password, go ahead and enter n at the following prompt:
Remove anonymous users, Y:
Disallow root logins remotely, Y:
Remove test database and access to it, Y:
And reload privilege tables, Y:
You can check the version of the MySQL installation with the following command:
Enter the MySQL command client:
You’ll be asked for the root password for the MySQL server, which was set earlier in this tutorial:
And then you should be greeted with the following:
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
Type ‘help;’ or ‘h’ for help. Type ‘c’ to clear the current input statement.
Exit the command line with the following command:
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