Installing Ubuntu 14 with MySQL 5.5/5.6 and PHP 5.6 (with Apache 2.4)
Things change quickly and you often find yourself on an older version of Ubuntu, but need non-standard installations.
This build was completed on 4-27-2017 and should remain relatively stable in terms of instructions.
This configuration also picks up after installing a clean copy of Ubuntu. LAMP installation was not chosen as an installation option (but don’t forget to add SSH Server!).
Looking for a way to set static IP and DNS on Ubuntu?
After you SSH in:
DO NOT RUN ‘do-release-upgrade’ to upgrade to 16.04.2 LTS SINCE WE NEED TO STAY ON 14. You will see this message every time you login.
We’re going to do New Repos, Apache, MySQL, then PHP
New Repos
I do this first, just to make sure no other dependencies are left unmet.
I used the standard ondrej repos found here.
BTW, I always use
sudo -i
because I’m lazy and get sick of tying in sudo all the time.
apt-get update add-apt-repository ppa:ondrej/php Then install some stuff I will need later:
apt-get update apt-get install software-properties-common python-software-properties
Apache 2.4.7
apt-get update apt-get install apache2 apache2 -v shutdown -r now
I always reboot (because I can) and installing major packages.
MySQL 5.6 (or 5.5)
apt-get update apt-get install mysql-server-5.5 apt-get install mysql-server-5.6 mysql_secure_installation
If you installed 5.6 and need to uninstall/remove it make sure to do:
apt-get update service mysql status service mysql shutdown apt-get remove mysql-server-5.6 apt-get purge mysql-server-5.6 shutdown -r now
If you get errors, it might be because of the /var/lib/mysql folder
rm -r -f /var/lib/mysql
Then run the install again
Unlike installing MySQL on CentOS for example, you have one more install step to do:
mysql_install_db
Note: you might get an error that says FATAL ERROR: Could not find my-default.cnf.
cp /etc/mysql/my.cnf /usr/share/mysql/my-default.cnf mysql_install_db service mysql status mysqladmin -p -u root version
Problems accessing the server remotely? Try this:
sudo nano /etc/mysql/my.cnf
comment out this line:
bind-address = 127.0.0.1 to #bind-address = 127.0.0.1
PHP 5.6.3
You’ve already added the ondrej repo, but take a look at the files if you want to. If you don’t see them, re-add the repo from above.
nano /etc/apt/sources.list dir /etc/apt/sources.list.d
You should see the ondrej/php repos:
nano /etc/apt/sources.list.d/ondrej-php-trusty.list nano /etc/apt/sources.list.d/ondrej-php-trusty.list.save
You can also search what’s in the repo:
apt-cache search php5.6 --names-only apt-cache search lib --names-only
Now install PHP 5.6
apt-get update apt-get install php5.6
Here’s sample output so you can see what is installed with the base 5.6 package, then add stuff later
Reading package lists... Done Building dependency tree Reading state information... Done The following extra packages will be installed: libapache2-mod-php5.6 libssl1.0.2 php-common php5.6-cli php5.6-common php5.6-json php5.6-opcache php5.6-readline Suggested packages: php-pear The following NEW packages will be installed: libapache2-mod-php5.6 libssl1.0.2 php-common php5.6 php5.6-cli php5.6-common php5.6-json php5.6-opcache php5.6-readline 0 upgraded, 9 newly installed, 0 to remove and 45 not upgraded. Need to get 6,864 kB of archives. After this operation, 19.8 MB of additional disk space will be used. Do you want to continue? [Y/n] Enter Y and enter
Installing some other usually needed PHP modules (there may be others):
apt-get update apt-get -y install php5.6-curl php5.6-gd php5.6-intl php5.6-mbstring php5.6-mcrypt php5.6-mysql php5.6-soap php5.6-xml php5.6-xmlrpc php5.6-xsl php5.6-zip apt-get -y install php-pear mcrypt php -v
Optional: WEBMIN
I like using Webmin to take care of some basic maintenance tasks. It can be easier to go to a web page than SSH in. Note: make sure to change the version of the URL below to match the latest. Look here for that.
wget http://downloads.sourceforge.net/webadmin/webmin_1.831_all.deb
then run the command :
dpkg --install webmin_1.831_all.deb
If Ubuntu complains about dependencies:
apt-get -f install
That’s it.
Update
Need to run Ubuntu 16 and MySQL 5.5? It is not supported, so you need to install it manually.