11
incama
Re: Website Dead
  • 2003/12/19 6:00

  • incama

  • Friend of XOOPS

  • Posts: 513

  • Since: 2003/10/24


Since you're hosting at home it would be easy to just install phpmyadmin to a directory where you can reach it with your webbrowser (or the same directory where you installed xoops)

Download it here: http://www.phpmyadmin.net/home_page/

unpack the package and edit in the config.inc.php the follwing lines:

$cfg['Servers'][$i]['host']          = 'localhost'; (server location)
$cfg['Servers'][$i]['user']          = 'root'; (database username)
$cfg['Servers'][$i]['password']      = ''; (user password)
$cfg['Servers'][$i]['only_db']       = ''; (database name,leave blank like this to let phpmyadmin show you all the databases you have)


It's really the easy way if you don't know how to handle your MySQL via the shell.

12
mdicker
Re: Website Dead
  • 2003/12/19 12:00

  • mdicker

  • Just popping in

  • Posts: 8

  • Since: 2003/12/15


THANK YOU! That Fixed it! I got my site Back!

Thanks, phpmyadmin looks pretty cool..wish I'd installed it in the first place...live and learn I guess :)

-Mitch

13
F3ign
Re: Website Dead
  • 2003/12/19 19:08

  • F3ign

  • Just popping in

  • Posts: 10

  • Since: 2003/12/17


I am bit new to Linux/mySQL/phpMyAdmin myself, so when I first setup phpMyAdmin I used my root account as well (providing you followed the above example verbatium).

However you may want to create a new db user for phpMyAdmin to authenticate with, I beleive it's a bit insecure to use the root account for this.

Also throw a htaccess file in your phpMyAdmin directory that way if anyone guesses it's path they won't be able to get to it without proper authentication.

Just my two cents.

14
mdicker
Re: Website Dead
  • 2003/12/20 18:50

  • mdicker

  • Just popping in

  • Posts: 8

  • Since: 2003/12/15


Thanks, I have done this..this comunity is great! Thanks you all so much

-Mitch

Login

Who's Online

316 user(s) are online (251 user(s) are browsing Support Forums)


Members: 0


Guests: 316


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits