PHPMyAdmin

From Site5Wiki

PHPMyAdmin is the control panel and GUI interaction that we have installed for you to manage your MySQL databases.

Subpages:

Contents 1 Information and Manuals 2 Localization 3 Versioning 4 Management and Usage 4.1 From within SiteAdmin 4.2 From within Site5, in general: Tips and tricks

[edit] Information and Manuals

• official PHPMyAdmin documentation
  • official wiki
• demos on the official site, so that you may manipulate it without making any changes to your own databases.
  
• Learn SQL by Using PHPMyAdmin, by Marc Delisle:

This tutorial is aimed at programmers, analysts, and designers of dynamic Web sites who want to learn the basics of SQL. I will use the MySQL database server and its powerful phpMyAdmin interface. The latter is an excellent tool for learning SQL.

[edit] Localization

Different languages are available for PHPMyAdmin, and its MySQL database management:

• PHPMyAdmin interface languages
• MySQL character collation

[edit] Versioning

[edit] Management and Usage

[edit] From within SiteAdmin

As seen in this screenshot, from within SiteAdmin, click the menu entry MySQL Databases, then click the drop-down choice PHPMyAdmin.
PHPMyAdmin will then open in a new window/tab for you.

[edit] From within Site5, in general: Tips and tricks

• From with your already-installed scripts:
  • 

    

    WP-PHPMyAdmin in action within a Site5-WordPress installation
    WordPress has a plugin, WP-PHPMyAdmin, that allows full usage and management from within your WordPress installation.
    

Once logged into your WordPress installation, click Manage, then click the submenu PHPMyAdmin.

• By using the server's own scripts:
  • .htaccess tweaking, thanks to B&T:

If you would like an easy way to have phpmyadmin.yourdomain.tld automatically go to a secure page for PHPMyAdmin, just put these three lines at the top of your .htaccess file:

RewriteEngine On
RewriteCond %{HTTP_HOST} ^phpmyadmin\.

RewriteRule ^(.*)$ https://yourserver.site5.com:2083/3rdparty/phpMyAdmin/index.php [L]

Substitute yourserver with the name of your site5 server.

One more fine point: If you are using MultiSite, you will need to put that code in the primary domain name's .htaccess file.

source: tips-scripts.com/phpmyadmin
This code is available via .txt file download as well from this wiki: pmaaccess.txt (download)