LEMP Development Server
in [Debian]
|
From: GNUbie on 22 Jun 2010 21:00 Hello all, I am seeking an advice on the best way to setup a LEMP development server. The web service is OK already since all the users will have its own UserDir directive. My only remaining problem is on how I can give an administrative privileges on the MySQL server to all the users that will not affect other users. Please advice. Thank you in advance. GNUbie -- To UNSUBSCRIBE, email to debian-user-REQUEST(a)lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmaster(a)lists.debian.org Archive: http://lists.debian.org/AANLkTinuja96Oj4sQlM57RvwZvFodNTVNTmB0KA0FEs5(a)mail.gmail.com
From: Camaleón on 23 Jun 2010 02:30 On Wed, 23 Jun 2010 08:55:39 +0800, GNUbie wrote: > I am seeking an advice on the best way to setup a LEMP development > server. The web service is OK already since all the users will have its > own UserDir directive. My only remaining problem is on how I can give an > administrative privileges on the MySQL server to all the users that will > not affect other users. LAMP, Linux Apache Mysql PHP http://wiki.debian.org/LaMp Create only one user with admin rights and the rest with the required/ needed privileges so they can "develop" but not "destroy" the DB server :-) Greetings, -- Camaleón -- To UNSUBSCRIBE, email to debian-user-REQUEST(a)lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmaster(a)lists.debian.org Archive: http://lists.debian.org/pan.2010.06.23.06.29.13(a)gmail.com
From: GNUbie on 23 Jun 2010 05:10 Hello Camaleón, Thank you for taking time answering my question. On Wed, Jun 23, 2010 at 2:29 PM, Camaleón <noelamac(a)gmail.com> wrote: > On Wed, 23 Jun 2010 08:55:39 +0800, GNUbie wrote: > >> I am seeking an advice on the best way to setup a LEMP development >> server. The web service is OK already since all the users will have its >> own UserDir directive. My only remaining problem is on how I can give an >> administrative privileges on the MySQL server to all the users that will >> not affect other users. > > LAMP, Linux Apache Mysql PHP > http://wiki.debian.org/LaMp Oh, I'm sorry. I'm using Nginx HTTP server <http://wiki.nginx.org/> by the way. > Create only one user with admin rights and the rest with the required/ > needed privileges so they can "develop" but not "destroy" the DB > server :-) I want to give the users their own "UserDir" or "virtual hosted" kind of MySQL (if that's possible) so that if they wanted to create a database, add users, etc, they can do it on their own. Regards, GNUbie -- To UNSUBSCRIBE, email to debian-user-REQUEST(a)lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmaster(a)lists.debian.org Archive: http://lists.debian.org/AANLkTilrmuYCkzpTuIs2VtUOsUr3azudBEI3dCC5q_t-(a)mail.gmail.com
From: Camaleón on 23 Jun 2010 05:40 On Wed, 23 Jun 2010 17:09:05 +0800, GNUbie wrote: > On Wed, Jun 23, 2010 at 2:29 PM, Camaleón wrote: >> LAMP, Linux Apache Mysql PHP >> http://wiki.debian.org/LaMp > > Oh, I'm sorry. I'm using Nginx HTTP server <http://wiki.nginx.org/> by > the way. Ah! I thought you said "lamp" and "lamp" tends to involve apache :-) But anyway, the webserver does not care about mysql "virtual" users, you have to setup mysql as described in the above link (see "mysql" section). >> Create only one user with admin rights and the rest with the required/ >> needed privileges so they can "develop" but not "destroy" the DB server >> :-) > > I want to give the users their own "UserDir" or "virtual hosted" kind of > MySQL (if that's possible) so that if they wanted to create a database, > add users, etc, they can do it on their own. Yes, that is possible, regardless the webserver in use. Just choose your desired mysql admin tool (there are many of them, GUI, command line, web-based... I used to use "phpmyadmin" for this task), then create the users and grant permission to them for managing databases and tables. Greetings, -- Camaleón -- To UNSUBSCRIBE, email to debian-user-REQUEST(a)lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmaster(a)lists.debian.org Archive: http://lists.debian.org/pan.2010.06.23.09.33.13(a)gmail.com
From: GNUbie on 23 Jun 2010 09:50
Hello Camaleón, On Wed, Jun 23, 2010 at 5:33 PM, Camaleón <noelamac(a)gmail.com> wrote: > > Just choose your desired mysql admin tool (there are many of them, GUI, > command line, web-based... I used to use "phpmyadmin" for this task), > then create the users and grant permission to them for managing databases > and tables. You mean, it's possible that a user can create MySQL users, databases, tables, etc. anytime they wanted to? Likewise, they can change the MySQL configuration, change DB engine, restart the service, and many others without affecting the other users? Regards, GNUbie -- To UNSUBSCRIBE, email to debian-user-REQUEST(a)lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmaster(a)lists.debian.org Archive: http://lists.debian.org/AANLkTimgP0BbFhZDd5ChPsrt2cbUxYsLiEDLoC0rePFK(a)mail.gmail.com |