XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. Q and A 
  4.  / xoops mysql table
Register
1
GOwin
xoops mysql table

  • 2004/4/18 4:23

  • GOwin

  • Just popping in

  • Posts: 78

  • Since: 2003/5/2 9


which MySQL table (if that's the right place) should i look into to find the MySQL username/password for my installation?

I can't remember the password i used for installation. :(
2
Dave_L
Re: xoops mysql table

  • 2004/4/18 4:41

  • Dave_L

  • XOOPS is my life!

  • Posts: 2277

  • Since: 2003/11/7


The xoops_users table contains that information, but the password is one-way encoded.

You could try the "Lost Password?" function, which will generate a new password and send it to the email address you registered with.

If that doesn't work, you could use this query to get the username for user #1:

SELECT uname FROM xoops_users WHERE uid = 1


and this query to reset the password:

UPDATE xoops_users SET pass = MD5('whatever') WHERE uid = 1
3
GOwin
Re: xoops mysql table

  • 2004/4/18 4:48

  • GOwin

  • Just popping in

  • Posts: 78

  • Since: 2003/5/2 9


I'm sorry i wasn't able to explain myself right on my first post.

I'm referring to the mySQL database account, not to the XOOPS user account.
4
Dave_L
Re: xoops mysql table

  • 2004/4/18 5:01

  • Dave_L

  • XOOPS is my life!

  • Posts: 2277

  • Since: 2003/11/7


Oh. That's in mainfile.php. Unless you're talking about the username/password used for installing MySQL, not Xoops.
5
GOwin
Re: xoops mysql table

  • 2004/4/18 5:16

  • GOwin

  • Just popping in

  • Posts: 78

  • Since: 2003/5/2 9


that's it! thanks a lot!

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

210 user(s) are online (146 user(s) are browsing Support Forums)

Members: 0

Guests: 210

more...

Donat-O-Meter

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

Latest GitHub Commits