Register

If this is your first visit, please click the Sign Up now button to begin the process of creating your account so you can begin posting on our forums! The Sign Up process will only take up about a minute of two of your time.

Results 1 to 6 of 6
Like Tree1Likes
  • 1 Post By Squeakypants

Thread: Installing phpMyAdmin

  1. #1
    Member
    Join Date
    Dec 2004
    Posts
    67
    Member #
    8452
    Liked
    1 times
    I wasn't sure to put this in Design or here, so you can move it if you want.

    phpMyAdmin is a database handler in php. It is simply all the scripts you would normally make manually to view and edit your database. It can even translate from php to sql and sql to php! It is a must-have for anyone who uses mysql.

    Now, on to the installation. Your server must be able to use SSH for this to work.

    1. You need an SSH client. SSH is almost like DOS, except it is for the internet. I use a simple one called PuTTy.

    2. Open PuTTy and enter your domain name or IP address. If your database is on a separate server, do not enter it here. You can leave the port at 22. Now connect. If this is the first time, a message will come up. Press yes.

    3. Enter your SSH username and password. Your password won't show up as you type it (not even *s), but once you are done press enter. You are now connected by SSH.

    4. Now that you are connected, you have to put this in (sorry, but no copy and paste):
    Code:
    wget http://aleron.dl.sourceforge.net/sourceforge/phpmyadmin/phpMyAdmin-2.5.3-php.tar.gz
    This will download phpmyadmin in to your home directory.

    5. Now you have to 'unzip' phpMyAdmin. Put this in:
    Code:
    tar xvfz phpMyAdmin-2.5.3-php.tar.gz
    6. Now, don't be freaked out by this (I know I was). People always break their knees when they see a lot of code. What you need to do is modify the config to your database's settings. First, put in this:
    Code:
    cd phpMyAdmin-2.5.3
    then
    Code:
    vi config.inc.php
    Now the file will open. Press the insert key on your keyboard to modify the file. Look for each of these and change them accordingly:

    Code:
    $cfg['PmaAbsoluteUri'] = 'http://mysite.com/phpMyAdmin-2.5.3/';
    The phpMyAdmin directory.
    
    $cfg['Servers'][$i]['host'] = 'mydatabase.database.net';
    Place your database host here (localhost is acceptable)
    
    $cfg['Servers'][$i]['auth_type'] = 'config';
    Make sure this option is set to config.
    
    $cfg['Servers'][$i]['user'] = 'username';
    Your mySQL username
    
    $cfg['Servers'][$i]['password'] = 'password';
    Your mySQL password
    
    $cfg['Servers'][$i]['only_db'] = 'awesomedatabase';
    Your database's name
    Now press Esc, then type:
    Code:
    :x
    7. If you can, now protect the phpMyAdmin with a username and password (if your host has that option).

    Now you simply go to the directory in your favorite browser *cough*firefox*cough* and you'll have it all good.
    Steve7 likes this.
    Brian : This must be the physics department.
    Chris : That explains all the gravity.

  2.  

  3. #2
    Member
    Join Date
    Aug 2013
    Location
    Venice, Florida
    Posts
    38
    Member #
    37112
    I love this tutorial, i was honestly really stumped over this task!!

  4. #3
    Junior Member
    Join Date
    Aug 2013
    Posts
    12
    Member #
    36949
    Liked
    1 times
    thanks. i could use this in the future.

  5. #4
    Unpaid WDF Intern TheGAME1264's Avatar
    Join Date
    Dec 2002
    Location
    Not from USA
    Posts
    14,485
    Member #
    425
    Liked
    2783 times
    IT'S A NINE-YEAR-OLD TUTORIAL, PEOPLE. Chances are the instructions would have long changed.

    Why would anyone bump an old thread and say this?
    If I've helped you out in any way, please pay it forward. My wife and I are walking for Autism Speaks. Please donate, and thanks.

    If someone helped you out, be sure to "Like" their post and/or help them in kind. The "Like" link is on the bottom right of each post, beside the "Share" link.

    My stuff (well, some of it): My bowling alley site | Canadian Postal Code Info (beta)

  6. #5
    Senior Member Webzarus's Avatar
    Join Date
    May 2011
    Location
    South Carolina Coast
    Posts
    3,322
    Member #
    27709
    Liked
    770 times
    Expect it from Bettis... He's bumped so many old threads... And put useless garbage... To get his signature more counts... That's it...

    I know I've challenged his post, he just ignores me and keeps doing it.

  7. #6
    WDF Staff AlphaMare's Avatar
    Join Date
    Oct 2009
    Location
    Montreal, Canada
    Posts
    4,570
    Member #
    20277
    Liked
    878 times
    Well, they'll be surprised when they try to use the information in this old thread!

    They obviously don't realize that phpMyAdmin has a very different installation procedure now, involving a leaf blower, two lizards, a peanut-butter cookie and a magic wand.

    Good design should never say "Look at me!"
    It should say "Look at this." ~ David Craib


    http://digitalinsite.ca ~ my current site . . info@digitalinsite.ca ~ my email

    If you feel that someone's post helped you fix your problem, answered your question, or just made you feel better, feel free to "Like" their post. The "Like" link is at the bottom right of each post, along side the "reply" link. And if you are being helped here, try to help someone else - pass it on!


Remove Ads

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
All times are GMT -6. The time now is 09:58 PM.
Powered by vBulletin® Version 4.2.3
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved.
vBulletin Skin By: PurevB.com