Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!news.albasani.net!eternal-september.org!feeder.eternal-september.org!.POSTED!not-for-mail From: "Peter H. Coffin" Newsgroups: comp.databases.mysql Subject: Re: modify my.cnf Date: Fri, 22 Apr 2011 14:47:58 -0500 Organization: A noiseless patient Spider Lines: 41 Message-ID: References: <4cde199c-2021-4d9e-96ec-8947372893c2@a21g2000prj.googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Injection-Info: mx03.eternal-september.org; posting-host="le/2G4+BNpieVhQI6uJ2Lw"; logging-data="25343"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/UfyXCU+cOCstfMa8ix4v3" User-Agent: slrn/0.9.9p1 (OpenBSD) Cancel-Lock: sha1:rFSscE3SyFC44K1JtgNwVIaZUys= Xref: x330-a1.tempe.blueboxinc.net comp.databases.mysql:594 On Fri, 22 Apr 2011 07:50:46 -0700 (PDT), jrough wrote: > On Apr 22, 6:19?am, "Peter H. Coffin" wrote: > > This is a test computer, the data is test data. I wouldn't want > someone taking over my computer but I'm not worried about the data > being exposed. I commented out the line about binding with a #. > I tried to start mysqld and I got this error. I would like to get > mysql running :-) > ----- > adsl-XX-XXX-30-80:mysql jr$ /usr/local/mysql/bin/mysqld > 110422 7:36:22 [Warning] Setting lower_case_table_names=2 because > file system for /usr/local/mysql-5.0.77-osx10.4-powerpc/data/ is case > insensitive vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv > 110422 7:36:22 [Warning] One can only use the --user switch if > running as root ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242881 > bytes > InnoDB: than specified in the .cnf file 0 5242880 bytes! > 110422 7:36:22 [ERROR] /usr/local/mysql/bin/mysqld: Can't create/ > write to file '/var/run/mysqld.pid' (Errcode: 13) > 110422 7:36:22 [ERROR] Can't start server: can't create PID file: > Permission denied > ---- > So permission is denied in the /var/run/ it can't create a pid file. > The /var/run/ directory is owned by root. See permissions. Since > root is running the mysql server I don't know It isn't running as root. If it was, you wouldn't be getting the warning above. > what permission to give the /var/run/ directory. > drwxrwxr-x 25 root daemon 850 Apr 22 07:36 . > drwxr-xr-x 26 root wheel 884 Oct 14 2009 .. -- Compared to system administration, being cursed forever is a step up. -- Paul Tomko