Setting Up phpMyAdmin

General Information

If you are a point-and-click kind of person and have to manage one or more MySQL servers, you may find this web-based utility to be a goldmine.


Requirements

  1. Local root access on the box or be able to su to root.
  2. A SSH client such as puTTy or SecureCRT (if you aren’t on the box).
  3. Your favorite text editor (I prefer nano).

Installation

Installation is straight forward. adidas gazelle soldes ugg bailey button boots nike pegasus adidas superstar Either download the source from http://www.phpmyadmin.net/ or install it from your favorite package manager. nike air max soldes Asics 2017 adidas nmd I will be installing it on FreeBSD using the ports tree. ugg homme bottes ugg pour homme nike air max 90 nike air max 90 chaussure timberland pas cher If you grabbed the source, just extract it to whichever directory you want it to be accessed from the web. nike air max 90 femme 2017 new balance femme Chaussures adidas running air max pas cher nike free run If you install it via ports or packages, it will get installed in /usr/local/www/phpMyAdmin.

 # cd /usr/ports/databases/phpmyadmin # make install clean 


Configuration

The configuration of the newer versions (2.7.x and above) can be done by pointing your browser to http://mydomain.com/phpMyAdmin/scripts/setup.php or whatever virtualhost you are using. nike blazer nike air max 2016 soldes nike roshe run nike chaussure Now, what we effectively want to accomplish is populating /usr/local/www/phpMyAdmin/config.inc.php with the proper settings that you want. ffxiv Items bottes ugg Adidas Running buy ffxiv Items Once you loaded the setup script in your browser, run through all of the setup options configuring what you need. adidas nmd nike air max 2018 https://www.goldufo.com A quick and dirty setup includes adding the server you are connecting to with cookie authentication. ugg bailey bow asics gel lyte new balance france ugg femme france Now there are a couple of ways to save this configuration.

Method One

Once you click ‘Add’ click ‘Display’ and copy all of the php text, open a ssh connection to your phpMyAdmin server and paste it into /usr/local/www/phpMyAdmin/config.inc.php.

Method Two

Click ‘Add’ as above, but this time you want to make the config.inc.php file writable by the web server so you can save your configuration from the web interface.

Note: This method is the least secure because anybody could change your config file, so use with caution.
 # cd /usr/local/www/phpMyAdmin # chmod g+w config.inc.php 

Make your changes in the setup page and then click ‘Save’ to save to the writable config file.

Now point your browser to your phpMyAdmin site and log in using your MySQL credentials.

Speak Your Mind

*