Groups | Search | Server Info | Login | Register

Groups > comp.databases.mysql > #593

Re: modify my.cnf

Show all headers | View raw

On 4/22/2011 10:50 AM, 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
> 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
> 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 ..
>
>

No, your problem is the first error - your innodb log file than what 
your my.cnf specifies.
-- 
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

Back to comp.databases.mysql | Previous | Next — Previous in thread | Next 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