On Thu, September 2, 2004 5:36 pm, Reno L said: > > --- timmy <[EMAIL PROTECTED]> wrote: > > <snipped question 1> > > Questions2: > I can turn on mysql under ROOT with that command > ./mysql start within /etc/init.d. Somehow, there is no > error message output when I execute the same command under user mode, but > could not turn on the mysql server. Why? I can not figure it out.
Linux (actually most/all Unix-based OSes) by default don't have the current directory on your path, so what you were actually doing is running the mysql client application from /usr/bin/mysql (most likely). That will produce the error message you noted about unable to connect. The second part -- even if you had run the mysql script as your user, you would have seen that it would have failed with an error. This is because MySQL is normally run as the user mysql, and programs run by you can't change their user ID on-the-fly like that. Programs run by root can change their user to another without a problem. This is part of the security profile of most/all *nixes - they don't allow unprivileged users to do things that could be dangerous. (changing your user ID without authenticating is one of those things) Jamie Furtner _______________________________________________ clug-talk mailing list [EMAIL PROTECTED] http://clug.ca/mailman/listinfo/clug-talk_clug.ca
