Computersnyou

How to Install MySQL on ubuntu 14.04 with phpmyadmin

Posted on  7/26/2014

This is third part of this series , where I am going to show you setup of MySQL database , First I will show you how you can setup and install MySQL using official UBUNTU repositories . second I will show you how to install Latest MySQL 5.6 Using Official MySQL Downloaded Package or mysql apt repository method .

How to setup MySQL in LINUX
How to setup MySQL in LINUX

Setup

One way to install MySQL is , using default ubuntu repositories .

sudo apt-get install mysql-server mysql-client

lets check installed version

alok@alok:~$ mysql --version
mysql  Ver 14.14 Distrib 5.5.37, for debian-linux-gnu (x86_64) using readline 6.3

Installing MySQL 5.6 on ubuntu

Second if you want to install latest MySQL , then you have to use mysql apt repository method . let me show you how to do that .

MySQL apt repository method .

Vistit : http://dev.mysql.com/downloads/repo/apt/
And download : Ubuntu Linux 14.04 (Architecture Independent), DEB File

sudo apt-get remove mysql-server mysql-client libmysqlclient*
wget https://dev.mysql.com/get/mysql-apt-config_0.2.1-1ubuntu14.04_all.deb
sudo dpkg -i mysql-apt-config_0.2.1-1ubuntu14.04_all.deb

# choose 5.6 

sudo apt-get update 
sudo apt-get install mysql-server mysql-client libmysqlclient18

# for PHP 

sudo apt-get install php5-mysql

mysql 5.6
mysql 5.6

Now MySQL is install lets configure it

Configuration

mysql_secure_installation 

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!


In order to log into MySQL to secure it, we'll need the current
password for the root user.  If you've just installed MySQL, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.

Enter current password for root (enter for none): <

Now MySQL is configured and ready to use .. Please post in forum if you are facing any problem .

MySQL web based GUI tool PHPMYADMIN

phpmyadmin Provide web based MySQL gui interface to manage your databases . its awesome .
lets install phpmyadmin

sudo apt-get install phpmyadmin
# choose apache2 in when prompted 

Choose Yes to configure database for phpmyadmin

db setup for phpmyadmin
db setup for phpmyadmin

Choose apache as your default server

choose apache
choose apache

Enter phpmyadmin Application Password

Screen Shot 2014-07-26 at 6.02.30 pm
Screen Shot 2014-07-26 at 6.02.30 pm

Enter database administrator password ( mysql root password )

phpmyadmin administrator password
phpmyadmin administrator password

Now open yourserveraddress/phpmyadmin http://yourserveraddress/phpmyadmin

phpmyadmin on ubuntu
phpmyadmin on ubuntu
phpmyadmin on ubuntu
phpmyadmin on ubuntu

  • Home
  • About