cancel
Showing results for 
Search instead for 
Did you mean: 

Managing users and privileges in MySQL

Boxersoft
Grafter
Posts: 104
Thanks: 1
Registered: ‎25-07-2009

Managing users and privileges in MySQL

I can't see a way (in PlusNet's implementation of phpMyAdmin) to manage separate users in my database. How can I grant my php scripts lesser privileges (e.g. SELECT only) than my own 'admin' user?
4 REPLIES 4
jelv
Community Veteran
Posts: 26,786
Thanks: 990
Fixes: 10
Registered: ‎10-04-2007

Re: Managing users and privileges in MySQL

Move to PAYH instead of using ccgi?
jelv (a.k.a Spoon Whittler)
   Why I have left Plusnet (warning: long post!)   
Broadband: Andrews & Arnold Home::1 (FTTC 80/20)
Line rental: Pulse 8 Home Line Rental (£14.40/month)
Mobile: iD mobile (£4/month)
Boxersoft
Grafter
Posts: 104
Thanks: 1
Registered: ‎25-07-2009

Re: Managing users and privileges in MySQL

So there's really no facility for restricting privileges in the ccgi setup? That seems highly dodgy Sad
jelv
Community Veteran
Posts: 26,786
Thanks: 990
Fixes: 10
Registered: ‎10-04-2007

Re: Managing users and privileges in MySQL

What do you expect from a free service? If you want something more sophisticated like a proper hosting service you have to look at PAYH.
jelv (a.k.a Spoon Whittler)
   Why I have left Plusnet (warning: long post!)   
Broadband: Andrews & Arnold Home::1 (FTTC 80/20)
Line rental: Pulse 8 Home Line Rental (£14.40/month)
Mobile: iD mobile (£4/month)
Boxersoft
Grafter
Posts: 104
Thanks: 1
Registered: ‎25-07-2009

Re: Managing users and privileges in MySQL

When I joined up I saw hosting as being "inclusive" rather than "free". I didn't expect fully-featured, but I'm rather surprised that such a bad practice is required.