Setting up phpMyAdmin on CentOS 6

Here's how to get phpMyAdmin, the MySQL GUI, working under CentOS 6:

Step 1: Turn on EPEL repository

phpMyAdmin is not included in default RHEL / CentOS repo. So turn on EPEL repo like this:
$ cd /tmp$ wget http://download.fedoraproject.org/pub/epel/6/i386/epel-release-6-8.noarch.rpm# rpm -ivh epel-release-6-8.noarch.rpm

Step 2: Install phpMyAdmin on a CentOS / RHEL Linux

Type the following yum command to download and install phpMyAdmin:
# yum search phpmyadmin# yum -y install phpmyadmin


Step 3: Fix phpMyAdmin permission

WARNING! What I'm about to show you is very dangerous, unless you are accessing phpMyAdmin using an ssh tunnel*

As root, edit:
/etc/httpd/conf.d/phpmyadmin.conf
Comment out lines that look like this:

#Order Allow,Deny #Deny from all Allow from 127.0.0.1

Restart apache with:

# service httpd restart

*To make using an ssh tunnel easier, edit your ~/.ssh/config file like this:

Host <anyNameYouLike>    HostName ec2-x-x-x-x.compute-1.amazonaws.com     User <username>    LocalForward 8080 ec2-x-x-x-x.compute-1.amazonaws.com:8080    LocalForward 8088 ec2-x-x-x-x.compute-1.amazonaws.com:80


After you save the changes to the config file, you can now setup the tunnel to forward local ports to your MySQL server with:

ssh <anyNameYouLike>

Then just go to "http://localhost:8088/phpMyAdmin". If you are not asked for a user name and password, refer the the above permission changes.

Comments

Post a Comment

Popular posts from this blog

Authentication for RESTful APIs

Lately I've been working on designing authentication (authN) and authorization (authZ) services for an API Gateway layer sitting on top of a collection supposedly RESTful APIs written by a diverse and disconnected population of developers. One of the many challenges I've faced is that it turns out that "REST" means different things to different people. I've been looking for a simple way to explain to developers what a high quality RESTful API looks and functions like. While I have found some good material, I felt I needed pull together a few different concepts, so I wrote this. Why is being fully RESTful important? Turns out that poorly designed and implemented, RESTful APIs are harder to design authentication and authorization services. First I want to discuss  RESTful APIs in general, so we can agree on what they are and are not. Then I will explain why weakly RESTful APIs are harder to implement authN/Z. Reading the documentation for supposedly "RE
Read more

Security From Happiness

The data is beginning to paint an interesting picture about the relationship between security and developer happiness. The 2020 DevSecOps survey from Sonatype indicates that happy developers are 3.6 times less likely to neglect security in their code. And 2.3 times more likely to set up automated security tools, and 1.3 times more likely to follow open source security policies. In addition, developers working within a mature DevOps practice are 1.5 times more likely to enjoy their work, and 1.6 times more likely to recommend their employer to their peers. These last conclusions about the relationship between DevOps maturity and developer happiness are also supported in multiple versions of the DORA State of DevOps survey data. Businesses actually want five things from developers, but usually only ask for one and assume the  other four take care of themselves. What they want, and ask for the most are new features. The next ask is improvements in new feature velocity. Rarely do they ask
Read more

How to build a simple RESTful API with Flask

I built this proof of concept (POC) for another project someone else was working on. They had built a basic RESTful API using Flask. But needed to add authentication and HTTPS support. I was pleasantly surprised how easy it was to go from zero to a basic RESTful API with TLS HTTPS and authentication via URL argument or headers. I'm writing this post to demonstrate how easy it truly is to setup a simple, safe and secure RESTful API using Flask. Step 1  Install Python I'll skip the steps on how to install Python. But I will just say that I got this working easily with both Python 2.7 on Linux and Python 3.5 on Windows. Step 2  Install Flask and clone my repo Flask is also easy to install by following their Quickstart Installation Guide. However, stop before doing the "mkdir myproject" step and clone my " flask-api-key " repo instead. Step 3  Activate a venv Then do: $ cd flask-api-key $ virtualenv venv New python executa
Read more