phpBBHacks.com - How to Install and Use phpMyAdmin
YanksBlog.com, an unofficial New York Yankees fan blog
StatsForums Home   RegisterRegister   ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in
FAQFAQ   SearchSearch   MemberlistMemberlist   TutorialsTutorials   ContactContact Us
Add Us:     MySpace     Facebook     StumbleUpon
Username:    Password:
Remember Me?    
How to Install and Use phpMyAdmin
BlinkList
del.icio.us
Furl
linkaGoGo
reddit
Simpy
Mister Wong
Yahoo! My Web

Post new topic   Reply to topic    phpBBHacks.com Support Forums Forum Index -> phpBB 2: Tools and Related Topics
 See a User Guidelines violation? Please contact us.
Author Message

Acid
VIP

Joined: 29 May 2001
Posts: 5997
Location: Berlin
PostPosted: December 7th 2002, 6:55 am    Post subject: How to Install and Use phpMyAdmin Reply with quote
Step 1 - Download
*Link: phpmyadmin

Step 2 - Untar or unzip the distribution
*be sure to unzip the subdirectories
*after that rename folder to phpmyadmin

Step 3 - Configuration
*open config.inc.php and set the values to access your database
Quote:
$cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname
$cfg['Servers'][$i]['user'] = ''; // MySQL user
$cfg['Servers'][$i]['password'] = ''; // MySQL password
$cfg['Servers'][$i]['only_db'] = ''; // Database name


Step 4 - Upload and..
*upload /phpmyadmin to your server
*point your browser to phpmyadmin (e.g. http://www.domain.com/phpmyadmin/)
*if you see a red error message (The $cfg['PmaAbsoluteUri'] directive MUST be set in your configuration file!) you have to set the directive in config.inc.php
*open config.inc.php and find/change (change the path to phpmyadmin)
Quote:
$cfg['PmaAbsoluteUri'] = 'http://domain.com/phpmyadmin/';


Step 5 - Queries
*click on any table in the left frame
*now youŽll see in the right frame a big textarea ("querybox"), maybe you have to scroll down a little bit
*cut/paste the queries (from a hack install file) into the querybox (the prior text in the querybox will be replaced; itŽs ok)
*hit the Go! (or Ok-) Button (youŽll see if you was successfull or not)

Step 6 - safe is always good
*create a file called .htaccess with the following content
Quote:
AuthType Basic
AuthName "Restricted Directory"
AuthUserFile /home/www/whatever/html/phpmyadmin/.htpasswd
require valid-user

*you have to change the blue part, if you donŽt know how the path should look like, paste the following code in a file called whatever.php, upload to /phpmyadmin and execute
Code:
<?
  echo "the path is: ";
  $path = ereg_replace ("\\\\","/",__FILE__);
  $path = dirname ($path);
  $path = trim($path);
  echo "<b>$path</b>";
?>

*now create a file called .htpasswd, the content should look like (blue is username/red is password)
Quote:
name:2d.JddK0g5454Tls

*to generate a crypted password check :: http://www.inch.com/info/tech/HOWTOS/htaccess/htpasswd.html (paste the result into .htpasswd)
*upload both files to /phpmyadmin

You should now be all set with a running copy of phpMyAdmin.
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    phpBBHacks.com Support Forums Forum Index -> phpBB 2: Tools and Related Topics All times are GMT - 6 Hours
Page 1 of 1
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Links: Big Message Boards - Free JavaScript - phpBB2 - phpbb styles - Suporte phpBB - phpBB.it - phpBB Česky - phpBB Turkiye - phpBBArabia.com - phpBB-fr.com - Romanian phpBB online community - phpBB-TW.net - phpBBservice.nl - phpBB Brasil

Network: iFroggy Network Blog - iFroggy Hosting - SportsForums.net - KarateForums.com - YanksBlog.com - PhotoshopForums.com - DeveloperCube - Managing Online Forums - ManagingCommunities.com - CommunityAdmins.com - DrGregHouse.com - Bad Boy Blog - SodaRatings.com - Patrick O'Keefe

< Advertising - Contact Us - Staff - User Guidelines >

Copyright © 2001-2009. iFroggy Network, phpBBHacks.com. All Rights Reserved. Privacy Policy. We Support phpBBHacks.com (of course!).
Powered by phpBB © phpBB Group. phpBB SEO. Hosted by 100MegsWebHosting. We are in no way affiliated with the phpBB Group. phpBB is copyright to the phpBB Group.