Groups | Search | Server Info | Login | Register

Groups > comp.databases.mysql > #595

Re: modify my.cnf

Show all headers | View raw

On Apr 22, 12:47 pm, "Peter H. Coffin" <hell...@ninehells.com> wrote:
thanks very much,
> On Fri, 22 Apr 2011 07:50:46 -0700 (PDT), jrough wrote:
> > On Apr 22, 6:19?am, "Peter H. Coffin" <hell...@ninehells.com> 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

Back to comp.databases.mysql | Previous | Next — Previous in thread | Find similar

Thread

modify my.cnf jrough <janis.rough@gmail.com> - 2011-04-21 18:07 -0700
  Re: modify my.cnf "Peter H. Coffin" <hellsop@ninehells.com> - 2011-04-21 22:10 -0500
    Re: modify my.cnf Jerry Stuckle <jstucklex@attglobal.net> - 2011-04-22 07:10 -0400
      Re: modify my.cnf "Peter H. Coffin" <hellsop@ninehells.com> - 2011-04-22 08:19 -0500
        Re: modify my.cnf jrough <janis.rough@gmail.com> - 2011-04-22 07:50 -0700
          Re: modify my.cnf Jerry Stuckle <jstucklex@attglobal.net> - 2011-04-22 11:12 -0400
          Re: modify my.cnf "Peter H. Coffin" <hellsop@ninehells.com> - 2011-04-22 14:47 -0500
            Re: modify my.cnf jrough <janis.rough@gmail.com> - 2011-04-23 09:15 -0700

csiph-web