1
pipwax
Finding the SQL Database of Xoops
  • 2006/4/14 23:05

  • pipwax

  • Not too shy to talk

  • Posts: 132

  • Since: 2005/9/12


I am using XOOPS by way of my Hosting Comoany. What I would like to know is How do I go about finding out how to log into my Database? Using myphpadmin.

Thanks!
pipwax1@bellsouth.net
Quote:
To win in life one must be fluid like water, taking the shape needed to prevail


aspring IT Professional

2
andycornell
Re: Finding the SQL Database of Xoops

Assuming you have the MySQL username and password, and know what server its on, usualy localhost, but dont know how too set up myphpadmin:

Quoted from MyPhpAdmin install document for version 0.9.2 found on phpbank (not sure if its the original documents, but still a good guide)
Quote:

Uncompress to a web-readable dir on your web server that has PHP and MySQL support
make sure that you use a .htacces with .htpassword with this, because it is not
really secure the way I set it up for now, the next release will have a login
built in.

make the dumps, tabledump, and edittable directories read/writable to user/group "nobody" so that you can use the
backup and restore feature and other editing features.


Next you will need to edit the config.php file and change the username and password variables
and the host that the server is on, usually localhost.

Now you can go give it a shot by opening your browser to the dir where you placed myphpadmin
(ie...http://localhost/myphpadmin)

NOTE: I REMOVED THE AUTHENTICATION PORTION OF THE CODE AS IT CAUSED MORE PROBLEMS THAN IT WAS WORTH
I ALSO PLACED A config.php FILE THAT YOU NEED TO EDIT, YOU WILL NEED TO ADD YOUR OWN PASSWORD
PROTECTION IN THIS RELEASE MAYBE WITH THE USE OF .htaccess .htpasswd FILES.
INFO ON HOW TO DO THIS CAN BE FOUND AT:http://www.linuxhelp.net/guides/djg/htaccess.phtml



if you have any suggestions comments or features you like me to add please email
me at: tim@lvcm.com


or, assuming you know myphpadmin usage, but dont have MySQL login information

Locate the Mainfile.php on trough your control panel, or trough FTP and look for

Quote:

// Database Hostname
// Hostname of the database server. If you are unsure, 'localhost' works in most cases.
define('XOOPS_DB_HOST', 'localhost');

// Database Username
// Your database user account on the host
define('XOOPS_DB_USER', 'dbuser');

// Database Password
// Password for your database user account
define('XOOPS_DB_PASS', 'dbpass');

// Database Name
// The name of database on the host. The installer will attempt to create the database if not exist
define('XOOPS_DB_NAME', 'dbname');


Then setup myphpadmin as above.

Hopes this helps,
Regards,
André Thoresen

3
gestroud
Re: Finding the SQL Database of Xoops
  • 2006/4/15 0:39

  • gestroud

  • Home away from home

  • Posts: 1538

  • Since: 2004/12/22


You could try this module

https://xoops.org/modules/repository/singlefile.php?cid=17&lid=1211

Login

Who's Online

155 user(s) are online (84 user(s) are browsing Support Forums)


Members: 0


Guests: 155


more...

Donat-O-Meter

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

Latest GitHub Commits