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. XOOPS general usage questions 
  4.  / mySQL user account configuration
Register
1
cavergary
mySQL user account configuration

  • 2006/10/6 15:49

  • cavergary

  • Just popping in

  • Posts: 16

  • Since: 2005/3/30


I would be interested in what grants the mySQL user account should have for the reasonable operation of Xoops.
Options include:
Select Insert Update Delete Create Drop Reload Shutdown Process File Grant References Index Alter


I'm sure Grant is not good and Shutdown too. But the others?
2
justtupeu
Re: mySQL user account configuration

  • 2006/10/7 19:22

  • justtupeu

  • Just popping in

  • Posts: 78

  • Since: 2005/6/7 8


All of them.
Can't you select them all ?
Vineri triskaideka - contest for Vineri triskaideka phrase
3
iHackCode
Re: mySQL user account configuration

mine has.

Quote:
[X]ALL
[ ]ALTER
[ ]CREATE TEMPORARY TABLES
[ ]CREATE
[ ]DELETE
[ ]DROP
[ ]SELECT
[ ]INSERT
[ ]UPDATE
[ ]REFERENCES
[ ]INDEX
[ ]LOCK TABLES


thats the list i get on a shared hosting account.
CBB / LatestNews / Publisher / XM-Spotlight

(ﾉ◕ヮ◕)ﾉ*:･ﾟ✧
4
cavergary
Re: mySQL user account configuration

  • 2006/10/10 18:00

  • cavergary

  • Just popping in

  • Posts: 16

  • Since: 2005/3/30


All priviliges would be the same as root. Do you really want full root access? I mean think of the possibilities! I can't believe that is really the best security posture.

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

303 user(s) are online (178 user(s) are browsing Support Forums)

Members: 0

Guests: 303

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