On 12/5/02 at 12:18, [EMAIL PROTECTED] (Paul DuBois) wrote: > At 13:36 +0100 5/12/02, Phil Dobbin wrote: [...] > >20512 00:13:18 mysqld restarted > >rm: /usr/local/mysql/data/localhost.pid: Permission denied > >../bin/safe_mysqld: permission denied: > >/usr/local/mysql/data/localhost.err [235] > >tee: /usr/local/mysql/data/localhost.err: Permission denied > > > >ad infinitum (I eventually have to "sudo kill -9 PID" to stop it). > > > >I've added a ~/.my.cnf file (per instructions in the MySQL manaul) > >but that makes no difference. Could someone advise me on which file > >I have to edit to enable start up and use of MySQL (huge_cnf?)? > > > >Also, I'm using Marc Liyange's Entropy installation. Has anybody > >used his uninstall script and, if so, how safe was it (it looks like > >I may have to uninstall and start again)? > > Doesn't look like a configuration file problem, looks like a file > ownership > problem. The server needs to be able to access its files. Try (as > root): > > # cd /usr/local > # chown -R mysql mysql > > My guess is that the mysql hierarchy is owned by root, and that when > you > specify --user=mysql to run the server, it can't write to root-owned > directories.
I got finally got it started by doing: su mysql password xxxxxx mysql% cd /usr/local/mysql mysql% ./bin/safe_mysqld --user=mysql but now I get 1045 error messages when I try to access mysql whether as me or root: [localhost:~] phil% mysqladmin reload ../bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'phil@localhost' (Using password: YES)' [localhost:~] phil% mysqladmin -u root -p create database_name Enter password: ../bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' [localhost:~] phil% This is just a small selection of the error messages I'm getting. I've added a ~/.my.cnf file but to no avail and studied the appropriate pages of the manual but I cannot connect to mysql. Any further help appreciated (the original lines you suggested I used when I installed). Regards, Phil. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php