> -----Original Message----- > From: j [mailto:[EMAIL PROTECTED] > Sent: dinsdag 1 februari 2005 10:09 > To: mysql@lists.mysql.com > Subject: Non root user MySQL install possible? > > Hi. Before asking my question I would like to state that I have looked > through the installation documentation, and have also successfully > performed MySQL installations on WindowsXP (along with Apache and > PHP), as well as on Linux machines that I have administrative (root) > access on. However, I am having problems installing MySQL on a Linux > machine as a non root user. My question is: is it possible? I don't > see why it wouldn't be, but after fighting with setting the correct > paths in mysql.server, and making sure ~/.my.cnf looked right, I am > having doubts. Rather than list every error I ran into, I will simply > state that I had problems setting up the proper paths (such as not > being able to alter /var/run/mysql/mysql.pid, which obviously cannot > be done while not root). > > If it is possible to do a local install as a non privileged user, can > someone please point me in the right direction, to a guide or > something? Or, simply state which config files need to be edited > (~/.my.cnf, mysql.server, etc) and I will work from there.
My first reaction was: I have never even heard of MySQL running as root! and I am sticking with that. :) Seriously, you should never run MySQL as root. Create a user, say, mysql, chown mysql:mysql /var/db/mysql/* (or wherever your databases reside), chmod go-rwx /var/db/mysql/*, add "user = mysql" to your my.cnf, and you're pretty much done. Granted, you cannot have your pid in /var/run/ directly. So? Create a subdir under /var/run/, owned by the mysql user, and have the pid in there. - Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
