Skip to main content

How To Install and Secure phpMyAdmin on Ubuntu 14.04

Install phpMyAdmin :


To get started, we can simply install phpMyAdmin from the default Ubuntu repositories.
$ sudo apt-get update
$ sudo apt-get install phpmyadmin
The only thing we need to do is explicitly enable the php5-mcrypt extension, which we can do by typing:

$ sudo php5enmod mcrypt
Afterwards, you'll need to restart Apache for your changes to be recognized:
$ sudo service apache2 restart
You can now access the web interface by visiting your server's domain name or public IP address followed by /phpmyadmin:

http://localhost/phpmyadmin
phpmyadmin login screen
When you log in, you'll see the user interface, which will look something like this:
phpmyadmin user interface

 
$ sudo service apache2 restart

 Issues : 

 ## Server is not found Issue ##

 
sudo service apache2 restart
 * Restarting web server apache2                                                                                                                AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1. Set the 'ServerName' directive globally to suppress this message
and when I was typed the,localhost/phpmyadmin it showing the message
-NOT FOUND The requested URL /phpmyadmin was not found on this server. Apache/2.4.7 (Ubuntu) Server at localhost Port 80
I believe this is because You haven't configured your phpmyadmin with the apache server well. If you installed the apache server and phpmyadmin using sudo apt-get install (Because you can install them using source code etc.) below procedure may work for you.
$ sudo ln -s /etc/phpmyadmin/apache.conf /etc/apache2/conf-available/phpmyadmin.conf

$ sudo ln -s /usr/share/phpmyadmin /var/www/html/phpmyadmin

$ sudo service apache2 restart
now type localhost/phpmyadmin in web browser address bar



$ sudo apt-get install php-mbstring
$ sudo ln -s /usr/share/phpmyadmin/ /var/www/html/phpmyadmin
$ sudo service apache2 restart


Labels:

Comments

  1. curiousviral26 August 2020 at 13:06

    I'm not able to access from the outside the Ubuntu machine even after stopped the firewall. install and secure phpmyadmin could you please tell me how?

    ReplyDelete

Post a Comment

Popular posts from this blog

Java Currency Formatter Solution

Given a  double-precision  number,  , denoting an amount of money, use the  NumberFormat  class'  getCurrencyInstance  method to convert   into the US, Indian, Chinese, and French currency formats. Then print the formatted values as follows: US: formattedPayment India: formattedPayment China: formattedPayment France: formattedPayment where   is   formatted according to the appropriate  Locale 's currency. Note:  India does not have a built-in Locale, so you must  construct one  where the language is  en  (i.e., English). Input Format A single double-precision number denoting  . Constraints Output Format On the first line, print  US: u  where   is   formatted for US currency.  On the second line, print  India: i  where   is   formatted for Indian currency.  On the third line...
7 comments
Read more

Java Stdin and Stdout II Code

In this challenge, you must read an  integer , a  double , and a  String  from stdin, then print the values according to the instructions in the  Output Format  section below. To make the problem a little easier, a portion of the code is provided for you in the editor. Note:  We recommend completing  Java Stdin and Stdout I  before attempting this challenge. Input Format There are three lines of input: The first line contains an  integer . The second line contains a  double . The third line contains a  String . Output Format There are three lines of output: On the first line, print  String:  followed by the unaltered  String  read from stdin. On the second line, print  Double:  followed by the unaltered  double  read from stdin. On the third line, print  Int:  followed by the unaltered  integer  read from stdin. To make the pr...
2 comments
Read more

How to Unirest HTTP API Requests Call in Java

Unirest is a set of lightweight HTTP libraries available in multiple languages, built and maintained by Mashape, who also maintain the open-source API Gateway Kong. Do yourself a favor, and start making HTTP requests like this: Creating Function : /** * Unirest API call return jsonResponse handle * Function Name: ApiCallFunction * @param vEmail, Url * @return status */ public static String ApiCallFunction(String vEmail, String Url) { try{ HttpResponse<JsonNode> jsonResponse = Unirest.post(Url) .field("vEmail",vEmail) .asJson(); JSONObject output= jsonResponse.getBody().getObject(); String status= output.getString("status"); return status; }catch(UnirestException e){ return "error"; } } Type Of   Response Handle : // Response to String Sting bookResponse = Unirest.get(Url).asString(); //Respo...
Post a Comment
Read more