Hello.
Use mysqlmanager. MySQL Instance Manager is included in MySQL distributions from version 5.0.3, and can be used in place of the mysqld_safe script to start and stop the MySQL Server, even from a remote host. See: http://dev.mysql.com/doc/refman/5.0/en/instance-manager.html mel list_php wrote: > Hi, > > This may be a strange question, but I was wondering if it is possible to > have a user starting/stopping the mysql server who wouldn't have access > to the data. > To explain: I want to set up a server as user "Groupinstaller" for > example. This is a virtual user to allow other people of my group to > start/stop the server by becoming "Groupinstaller". > But I don't want this user to be able to see the different databases of > the different people, nor touch the data directory. For example, I have > a database called db1 and my coworker has a db called db2. > I am root of mysql, so I have access to all the databases, but he is > just a user with access to his db and not to mine. If no other solution, > I could eventually do with a read access, but I really don't want to > allow write. > I was thinking at replacing the typical "mysql" user by the > "Groupinstaller" one, but this user owns the data directory... > > Does anybody know if it is possible, and how? > thanks, > melanie > > _________________________________________________________________ > The new MSN Search Toolbar now includes Desktop search! > http://toolbar.msn.co.uk/ > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]