On fredag, nov 29, 2002, at 19:49 Europe/Stockholm, Richard Lanyon wrote:

On Thursday, November 28, 2002, at 12:45  pm, Richard Lanyon wrote:

Hmmm... OK, have done that (and many thanks!), but now am back to the problem I had in the first place, i.e. that it doesn't create the /sw/var/mysql/test and /sw/var/mysql/mysql databases.
Aha! Sorted out one problem - now for the next one. Basically, the problem was that there was an /etc/my.cnf file lying around from one of my previous installation, and that defined MySQL's data directory as being /var/database/mysql. It would appear this caused the installation process to put the databases there instead of /sw/var/mysql...

Great!

BUT...
Although MySQL installs properly, attempting to run safe_mysqld gives some more permissions errors:

pc-80-193-231-14-ca:~% safe_mysqld
touch: /sw/var/mysql/pc-80-193-231-14-ca.blueyonder.co.uk.err: Permission denied
chown: /sw/var/mysql/pc-80-193-231-14-ca.blueyonder.co.uk.err: Permission denied
Starting mysqld daemon with databases from /sw/var/mysql
/sw/bin/safe_mysqld: /sw/var/mysql/pc-80-193-231-14-ca.blueyonder.co.uk.err: Permission denied
rm: /sw/var/mysql/pc-80-193-231-14-ca.blueyonder.co.uk.pid: Permission denied
/sw/bin/safe_mysqld: /sw/var/mysql/pc-80-193-231-14-ca.blueyonder.co.uk.err: Permission denied
tee: /sw/var/mysql/pc-80-193-231-14-ca.blueyonder.co.uk.err: Permission denied
021129 18:48:24 mysqld ended
tee: /sw/var/mysql/pc-80-193-231-14-ca.blueyonder.co.uk.err: Permission denied
You need to do 'sudo safe_mysqld', so that the process can switch over to user mysql by itself, thus gaining permission to the files above. What I'd do is install daemonic, and then have daemonic start mysqld automatically at every startup -- much more convenient.

---
Oscar Erlandsson [erlandsson at mac dot com]



-------------------------------------------------------
This SF.net email is sponsored by: Get the new Palm Tungsten T handheld. Power & Color in a compact size! http://ads.sourceforge.net/cgi-bin/redirect.pl?palm0002en
_______________________________________________
Fink-beginners mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/fink-beginners

Reply via email to