mysqld can't resolve the path

  • Follow


when I start the mysql server it cannot resolve the path?

sh-3.2# sudo /usr/local/mysql/bin/mysqld -h localhost --user=root
100716 17:02:42 [ERROR] /usr/local/mysql/bin/mysqld: unknown option '--
Path to installation directory. All paths are usually resolved
relative to this.'
sh-3.2#

It should be the one with the symlink Mysql-5.0.77-osx10.4-powerpc
Why can't it resolve the path?
drwxr-xr-x   9 root  wheel  306 Oct 31  2009 .
drwxr-xr-x@ 12 root  wheel  408 Oct 14  2009 ..
drwxr-xr-x   9 root  wheel  306 May 30  2009 bin
drwxr-xr-x   7 root  wheel  238 Mar 23 14:24 dyndns
lrwxr-xr-x   1 root  wheel   28 Apr  3  2009 mysql -> mysql-5.0.77-
osx10.4-powerpc
drwxr-xr-x  19 root  wheel  646 Jan 29  2009 mysql-5.0.77-osx10.4-
powerpc
drwxr-xr-x   3 root  wheel  102 Apr  3  2009 mysql-standard-4.1.22-
apple-darwin8.6.0-powerpc
drwxr-xr-x  11 root  wheel  374 Apr  3  2009 php5
drwxrwxr-x   3 jr    wheel  102 Jan 16  2009 share

Here is my.cnf

[mysqld]
user= root
pid-file = /var/run/mysqld.pid
socket = /tmp/mysql.sock
port = 3306
#Path to the temporary directory.
tmpdir = /tmp
#language = /usr/share/mysql/English
bind-address = 99.40.53.42

Path to installation directory. All paths are usually resolved
relative to this.
basedir=/usr/local/mysql-5.0.77-osx10.4-powerpc
Path to the database root
datadir=/usr/local/mysql-5.0.77-osx10.4-powerpc/data


key_buffer_size=8192k
#Each thread that needs to do a sort allocates a buffer of this size.
sort_buffer_size=2M
#If no specific storage engine/table type is defined in an SQL-Create
statement the default type will be used.
default-storage-engine=myisam


#[client]
socket=/tmp/mysql.sock


thanks,
0
Reply JRough 7/17/2010 12:11:39 AM

>when I start the mysql server it cannot resolve the path?
>
>sh-3.2# sudo /usr/local/mysql/bin/mysqld -h localhost --user=root
>100716 17:02:42 [ERROR] /usr/local/mysql/bin/mysqld: unknown option '--
>Path to installation directory. All paths are usually resolved
>relative to this.'
>sh-3.2#
>
>It should be the one with the symlink Mysql-5.0.77-osx10.4-powerpc
>Why can't it resolve the path?

Were you under the impression that the big, long sentence quoted
above with all the spaces and punctuation was a valid path?  

>drwxr-xr-x   9 root  wheel  306 Oct 31  2009 .
>drwxr-xr-x@ 12 root  wheel  408 Oct 14  2009 ..
>drwxr-xr-x   9 root  wheel  306 May 30  2009 bin
>drwxr-xr-x   7 root  wheel  238 Mar 23 14:24 dyndns
>lrwxr-xr-x   1 root  wheel   28 Apr  3  2009 mysql -> mysql-5.0.77-
>osx10.4-powerpc
>drwxr-xr-x  19 root  wheel  646 Jan 29  2009 mysql-5.0.77-osx10.4-
>powerpc
>drwxr-xr-x   3 root  wheel  102 Apr  3  2009 mysql-standard-4.1.22-
>apple-darwin8.6.0-powerpc
>drwxr-xr-x  11 root  wheel  374 Apr  3  2009 php5
>drwxrwxr-x   3 jr    wheel  102 Jan 16  2009 share

I don't see any filenames containing the word "resolved" or "relative",
or any over 80 characters long, either.

>Here is my.cnf
>
>[mysqld]
>user= root
>pid-file = /var/run/mysqld.pid
>socket = /tmp/mysql.sock
>port = 3306
>#Path to the temporary directory.
 ^That's a comment.
>tmpdir = /tmp
>#language = /usr/share/mysql/English
 ^That's a comment
>bind-address = 99.40.53.42
>
>Path to installation directory. All paths are usually resolved
 ^That's not a comment.  Why is this here?
>relative to this.
 ^That's not a comment either.
>basedir=/usr/local/mysql-5.0.77-osx10.4-powerpc
>Path to the database root
 ^That's not a comment
>datadir=/usr/local/mysql-5.0.77-osx10.4-powerpc/data
>
>
>key_buffer_size=8192k
>#Each thread that needs to do a sort allocates a buffer of this size.
 ^That's a comment.
>sort_buffer_size=2M
>#If no specific storage engine/table type is defined in an SQL-Create
 ^That's a comment
>statement the default type will be used.
 ^That's not a comment unless it's really part of the previous line.
>default-storage-engine=myisam
>
>
>#[client]
 ^This is a comment, which is probably not advisable
>socket=/tmp/mysql.sock
 ^Isn't the socket variable supposed to be in the client section, which
  you commented out?


0
Reply gordonb 7/17/2010 1:25:52 AM


Gordon Burditt wrote:
>> when I start the mysql server it cannot resolve the path?
>>
>> sh-3.2# sudo /usr/local/mysql/bin/mysqld -h localhost --user=root
>> 100716 17:02:42 [ERROR] /usr/local/mysql/bin/mysqld: unknown option '--
>> Path to installation directory. All paths are usually resolved
>> relative to this.'
>> sh-3.2#
>>
>> It should be the one with the symlink Mysql-5.0.77-osx10.4-powerpc
>> Why can't it resolve the path?
> 
> Were you under the impression that the big, long sentence quoted
> above with all the spaces and punctuation was a valid path?  
>

Gordon, I believe everything after the first line is the error message 
she gets back.


-- 
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
0
Reply Jerry 7/17/2010 1:33:37 AM

>>> when I start the mysql server it cannot resolve the path?
>>>
>>> sh-3.2# sudo /usr/local/mysql/bin/mysqld -h localhost --user=root
>>> 100716 17:02:42 [ERROR] /usr/local/mysql/bin/mysqld: unknown option '--
>>> Path to installation directory. All paths are usually resolved
>>> relative to this.'
>>> sh-3.2#
>>>
>>> It should be the one with the symlink Mysql-5.0.77-osx10.4-powerpc
>>> Why can't it resolve the path?
>> 
>> Were you under the impression that the big, long sentence quoted
>> above with all the spaces and punctuation was a valid path?  
>>
>
>Gordon, I believe everything after the first line is the error message 
>she gets back.

So why does the error message also appear in my.cnf uncommented?

0
Reply gordonb 7/17/2010 1:53:03 AM

Gordon Burditt wrote:
>>>> when I start the mysql server it cannot resolve the path?
>>>>
>>>> sh-3.2# sudo /usr/local/mysql/bin/mysqld -h localhost --user=root
>>>> 100716 17:02:42 [ERROR] /usr/local/mysql/bin/mysqld: unknown option '--
>>>> Path to installation directory. All paths are usually resolved
>>>> relative to this.'
>>>> sh-3.2#
>>>>
>>>> It should be the one with the symlink Mysql-5.0.77-osx10.4-powerpc
>>>> Why can't it resolve the path?
>>> Were you under the impression that the big, long sentence quoted
>>> above with all the spaces and punctuation was a valid path?  
>>>
>> Gordon, I believe everything after the first line is the error message 
>> she gets back.
> 
> So why does the error message also appear in my.cnf uncommented?
> 

I'm not sure how much of that is my.cnf and how much is jr.  But you 
could be right.  In fact, you probably are.

-- 
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
0
Reply Jerry 7/17/2010 2:09:10 AM

JRough wrote:
> when I start the mysql server it cannot resolve the path?
> 
> sh-3.2# sudo /usr/local/mysql/bin/mysqld -h localhost --user=root
> 100716 17:02:42 [ERROR] /usr/local/mysql/bin/mysqld: unknown option '--
> Path to installation directory. All paths are usually resolved
> relative to this.'

You see this error message, saying:

Path to installation directory. All paths are usually resolved
 relative to this.


> Here is my.cnf
> 
> [mysqld]
> user= root
> pid-file = /var/run/mysqld.pid
> socket = /tmp/mysql.sock
> port = 3306
> #Path to the temporary directory.
> tmpdir = /tmp
> #language = /usr/share/mysql/English
> bind-address = 99.40.53.42
> 
> Path to installation directory. All paths are usually resolved
> relative to this.

Have you seen the above row(s) before?
You should make it to a a comment, add the # of each row (can't say if it's
two or one row).

> basedir=/usr/local/mysql-5.0.77-osx10.4-powerpc
> Path to the database root
> datadir=/usr/local/mysql-5.0.77-osx10.4-powerpc/data
> 
> 
> key_buffer_size=8192k
> #Each thread that needs to do a sort allocates a buffer of this size.
> sort_buffer_size=2M
> #If no specific storage engine/table type is defined in an SQL-Create
> statement the default type will be used.
> default-storage-engine=myisam
> 
> 
> #[client]
> socket=/tmp/mysql.sock
> 
> 
> thanks,


-- 

  //Aho
0
Reply J 7/17/2010 4:24:14 AM

On Jul 16, 9:24=A0pm, "J.O. Aho" <u...@example.net> wrote:
> JRough wrote:
> > when I start the mysql server it cannot resolve the path?
>
> > sh-3.2# sudo /usr/local/mysql/bin/mysqld -h localhost --user=3Droot
> > 100716 17:02:42 [ERROR] /usr/local/mysql/bin/mysqld: unknown option '--
> > Path to installation directory. All paths are usually resolved
> > relative to this.'
>
> You see this error message, saying:
>
> Path to installation directory. All paths are usually resolved
> =A0relative to this.
>
> > Here is my.cnf
>
> > [mysqld]
> > user=3D root
> > pid-file =3D /var/run/mysqld.pid
> > socket =3D /tmp/mysql.sock
> > port =3D 3306
> > #Path to the temporary directory.
> > tmpdir =3D /tmp
> > #language =3D /usr/share/mysql/English
> > bind-address =3D 99.40.53.42
>
> > Path to installation directory. All paths are usually resolved
> > relative to this.
>
> Have you seen the above row(s) before?
> You should make it to a a comment, add the # of each row (can't say if it=
's
> two or one row).
>
>
>
> > basedir=3D/usr/local/mysql-5.0.77-osx10.4-powerpc
> > Path to the database root
> > datadir=3D/usr/local/mysql-5.0.77-osx10.4-powerpc/data
>
> > key_buffer_size=3D8192k
> > #Each thread that needs to do a sort allocates a buffer of this size.
> > sort_buffer_size=3D2M
> > #If no specific storage engine/table type is defined in an SQL-Create
> > statement the default type will be used.
> > default-storage-engine=3Dmyisam
>
> > #[client]
> > socket=3D/tmp/mysql.sock
>
> > thanks,
>
> --
>
> =A0 //Aho

Okay, thanks, here is the real error message:
h-3.2# /usr/local/mysql/bin/mysqld -h localhost --user=3Droot
100717  5:27:29 [Warning] Can't create test file /usr/local/
mysql-5.0.77-osx10.4-powerpc/localhost/Janis-Rough.lower-test
100717  5:27:29 [Warning] Can't create test file /usr/local/
mysql-5.0.77-osx10.4-powerpc/localhost/Janis-Rough.lower-test
/usr/local/mysql/bin/mysqld: Can't change dir to '/usr/local/
mysql-5.0.77-osx10.4-powerpc/localhost/' (Errcode: 2)
100717  5:27:29 [ERROR] Aborting

100717  5:27:29 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

and the revised my.cnf with the socket in the client:


Why can't it resolve the path?  Here is the directory again.
drwxr-xr-x   9 root  wheel  306 Oct 31  2009 .
drwxr-xr-x@ 12 root  wheel  408 Oct 14  2009 ..
drwxr-xr-x   9 root  wheel  306 May 30  2009 bin
drwxr-xr-x   7 root  wheel  238 Mar 23 14:24 dyndns
lrwxr-xr-x   1 root  wheel   28 Apr  3  2009 mysql -> mysql-5.0.77-
osx10.4-powerpc
drwxr-xr-x  19 root  wheel  646 Jan 29  2009 mysql-5.0.77-osx10.4-
powerpc
drwxr-xr-x   3 root  wheel  102 Apr  3  2009 mysql-standard-4.1.22-
apple-darwin8.6.0-powerpc
drwxr-xr-x  11 root  wheel  374 Apr  3  2009 php5
drwxrwxr-x   3 jr    wheel  102 Jan 16  2009 share
thanks,
0
Reply JRough 7/17/2010 12:32:13 PM

In article <2098aa42-4c9c-4a21-8593-dd831b605cf3@q21g2000prm.googlegroups.com>, JRough <jlrough@yahoo.com> wrote:
>Okay, thanks, here is the real error message:
>h-3.2# /usr/local/mysql/bin/mysqld -h localhost --user=root
>100717  5:27:29 [Warning] Can't create test file /usr/local/
>mysql-5.0.77-osx10.4-powerpc/localhost/Janis-Rough.lower-test

Has it occurred to you to wonder why that file can't be created? If so, has it 
occurred to you to investigate the possible causes?

>100717  5:27:29 [Warning] Can't create test file /usr/local/
>mysql-5.0.77-osx10.4-powerpc/localhost/Janis-Rough.lower-test

Same questions.

>/usr/local/mysql/bin/mysqld: Can't change dir to '/usr/local/
>mysql-5.0.77-osx10.4-powerpc/localhost/' (Errcode: 2)
>100717  5:27:29 [ERROR] Aborting

What possible reasons could there be for a change-directory command to fail?

0
Reply spambait 7/17/2010 4:17:18 PM

Doug Miller wrote:
> In article <2098aa42-4c9c-4a21-8593-dd831b605cf3@q21g2000prm.googlegroups.com>, JRough <jlrough@yahoo.com> wrote:
>> Okay, thanks, here is the real error message:
>> h-3.2# /usr/local/mysql/bin/mysqld -h localhost --user=root
>> 100717  5:27:29 [Warning] Can't create test file /usr/local/
>> mysql-5.0.77-osx10.4-powerpc/localhost/Janis-Rough.lower-test
> 
> Has it occurred to you to wonder why that file can't be created? If so, has it 
> occurred to you to investigate the possible causes?

I dont think so, no. :-(
> 
>> 100717  5:27:29 [Warning] Can't create test file /usr/local/
>> mysql-5.0.77-osx10.4-powerpc/localhost/Janis-Rough.lower-test
> 
> Same questions.
> 
>> /usr/local/mysql/bin/mysqld: Can't change dir to '/usr/local/
>> mysql-5.0.77-osx10.4-powerpc/localhost/' (Errcode: 2)
>> 100717  5:27:29 [ERROR] Aborting
> 
> What possible reasons could there be for a change-directory command to fail?
> 
Now you are expecting stuff like thinking, and figgering stuff out. 
Hardly FAIR.

Years and years ago, I met a girl. Who attached herself to me for the 
evening.

At one point I as thinking about something, not paying attention to her. 
It might have been philosophy, or maths or science. Anyway it was a 
large amount more interesting than she was..

'Waddya doin?'
'Thinking'
'Hey I can figger stuff out, too, ya know!'

I became even more speechless than before as I considered the 
implications.. of the fact that she felt that was a statement that 
anyone would need to even make, let alone whether or not it was true.

I am strangely reminded of that girl... reading this thread..
0
Reply The 7/17/2010 4:26:22 PM

In article <i1sl2r$8sq$1@news.eternal-september.org>, spambait@milmac.com (Doug Miller) wrote:
>In article <2098aa42-4c9c-4a21-8593-dd831b605cf3@q21g2000prm.googlegroups.com>,
> JRough <jlrough@yahoo.com> wrote:
>>Okay, thanks, here is the real error message:
>>h-3.2# /usr/local/mysql/bin/mysqld -h localhost --user=root
>>100717  5:27:29 [Warning] Can't create test file /usr/local/
>>mysql-5.0.77-osx10.4-powerpc/localhost/Janis-Rough.lower-test
>
>Has it occurred to you to wonder why that file can't be created? If so, has it 
>occurred to you to investigate the possible causes?
>
>>100717  5:27:29 [Warning] Can't create test file /usr/local/
>>mysql-5.0.77-osx10.4-powerpc/localhost/Janis-Rough.lower-test
>
>Same questions.
>
>>/usr/local/mysql/bin/mysqld: Can't change dir to '/usr/local/
>>mysql-5.0.77-osx10.4-powerpc/localhost/' (Errcode: 2)
>>100717  5:27:29 [ERROR] Aborting
>
>What possible reasons could there be for a change-directory command to fail?
>
And have you checked to see what Errcode: 2 means?
0
Reply spambait 7/17/2010 4:27:24 PM

On Jul 17, 9:17=A0am, spamb...@milmac.com (Doug Miller) wrote:
> In article <2098aa42-4c9c-4a21-8593-dd831b605...@q21g2000prm.googlegroups=
..com>, JRough <jlro...@yahoo.com> wrote:
>
> >Okay, thanks, here is the real error message:
> >h-3.2# /usr/local/mysql/bin/mysqld -h localhost --user=3Droot
> >100717 =A05:27:29 [Warning] Can't create test file /usr/local/
> >mysql-5.0.77-osx10.4-powerpc/localhost/Janis-Rough.lower-test
>
> Has it occurred to you to wonder why that file can't be created? If so, h=
as it
> occurred to you to investigate the possible causes?
>
> >100717 =A05:27:29 [Warning] Can't create test file /usr/local/
> >mysql-5.0.77-osx10.4-powerpc/localhost/Janis-Rough.lower-test
>
> Same questions.
>
> >/usr/local/mysql/bin/mysqld: Can't change dir to '/usr/local/
> >mysql-5.0.77-osx10.4-powerpc/localhost/' (Errcode: 2)
> >100717 =A05:27:29 [ERROR] Aborting
>
> What possible reasons could there be for a change-directory command to fa=
il?

I'm not using the password on connecting to the localhost because I
need to access the server without the password to add accounts
and fix it.  I'm not sure if that is the issue.  In any case , I
changed permissions on the
adsl-99-40-53-42.dsl.pltn13.sbcglobal.net.err
file to



-rwxrwxrwx   1 root  wheel      1078 Jul 16 16:51
adsl-99-40-53-42.dsl.pltn13.sbcglobal.net.err


I don't know if the WHEEL group is limiting my access but if it is I
don't know what the solution is?
thanks,
Janis

0
Reply jr 7/17/2010 4:56:03 PM

On Jul 17, 9:27=A0am, spamb...@milmac.com (Doug Miller) wrote:
> In article <i1sl2r$8s...@news.eternal-september.org>, spamb...@milmac.com=
 (Doug Miller) wrote:
> >In article <2098aa42-4c9c-4a21-8593-dd831b605...@q21g2000prm.googlegroup=
s.com>,
> > JRough <jlro...@yahoo.com> wrote:
> >>Okay, thanks, here is the real error message:
> >>h-3.2# /usr/local/mysql/bin/mysqld -h localhost --user=3Droot
> >>100717 =A05:27:29 [Warning] Can't create test file /usr/local/
> >>mysql-5.0.77-osx10.4-powerpc/localhost/Janis-Rough.lower-test
>
> >Has it occurred to you to wonder why that file can't be created? If so, =
has it
> >occurred to you to investigate the possible causes?
>
> >>100717 =A05:27:29 [Warning] Can't create test file /usr/local/
> >>mysql-5.0.77-osx10.4-powerpc/localhost/Janis-Rough.lower-test
>
> >Same questions.
>
> >>/usr/local/mysql/bin/mysqld: Can't change dir to '/usr/local/
> >>mysql-5.0.77-osx10.4-powerpc/localhost/' (Errcode: 2)
> >>100717 =A05:27:29 [ERROR] Aborting
>
> >What possible reasons could there be for a change-directory command to f=
ail?
>
> And have you checked to see what Errcode: 2 means?

I would like to know if the only answer is to reinstall mysql?
I created a localhost directory.  Mysql started but got a fatal
error.  I still don't have a mysql daemon.
sh-3.2# /usr/local/mysql/bin/mysqld -h localhost --user=3Droot
100717 10:49:39 [Warning] Setting lower_case_table_names=3D2 because
file system for /usr/local/mysql-5.0.77-osx10.4-powerpc/localhost/ is
case insensitive
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
100717 10:49:39  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
100717 10:49:40  InnoDB: Log file ./ib_logfile0 did not exist: new to
be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
100717 10:49:40  InnoDB: Log file ./ib_logfile1 did not exist: new to
be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
100717 10:49:40  InnoDB: Started; log sequence number 0 0
100717 10:49:40 [ERROR] Fatal error: Can't open and lock privilege
tables: Table 'mysql.host' doesn't exist
thanks,
0
Reply jlrough (485) 7/17/2010 5:55:03 PM

jr wrote:
> On Jul 17, 9:17 am, spamb...@milmac.com (Doug Miller) wrote:
>> In article <2098aa42-4c9c-4a21-8593-dd831b605...@q21g2000prm.googlegroups.com>, JRough <jlro...@yahoo.com> wrote:
>>
>>> Okay, thanks, here is the real error message:
>>> h-3.2# /usr/local/mysql/bin/mysqld -h localhost --user=root
>>> 100717  5:27:29 [Warning] Can't create test file /usr/local/
>>> mysql-5.0.77-osx10.4-powerpc/localhost/Janis-Rough.lower-test
>>
>> Has it occurred to you to wonder why that file can't be created? If so, has it
>> occurred to you to investigate the possible causes?
>>
>>> 100717  5:27:29 [Warning] Can't create test file /usr/local/
>>> mysql-5.0.77-osx10.4-powerpc/localhost/Janis-Rough.lower-test
>>
>> Same questions.
>>
>>> /usr/local/mysql/bin/mysqld: Can't change dir to '/usr/local/
>>> mysql-5.0.77-osx10.4-powerpc/localhost/' (Errcode: 2)
>>> 100717  5:27:29 [ERROR] Aborting
>>
>> What possible reasons could there be for a change-directory command to fail?
> 
> I'm not using the password on connecting to the localhost because I
> need to access the server without the password to add accounts
> and fix it.

Connecting without or with a passowrd don't matter in this case, as you get
"Can't change dir", did you ever look if the directory does exists? Or that
your user has the right to enter the directory, the privileges on the
directories before it will affect things too.


>  I'm not sure if that is the issue.  In any case , I
> changed permissions on the
> adsl-99-40-53-42.dsl.pltn13.sbcglobal.net.err
> file to
> 
> 
> -rwxrwxrwx   1 root  wheel      1078 Jul 16 16:51
> adsl-99-40-53-42.dsl.pltn13.sbcglobal.net.err

You aren't using microsoft windows, execution privilege on a log file is just
wrong.


> I don't know if the WHEEL group is limiting my access but if it is I
> don't know what the solution is?

If your user isn't belonging to the group, then yes it will cause problems.

-- 

  //Aho
0
Reply J 7/17/2010 5:55:36 PM

jr wrote:

> 100717 10:49:40 [ERROR] Fatal error: Can't open and lock privilege
> tables: Table 'mysql.host' doesn't exist

First time you run, you need first to run the mysql_install_db command, then
it will crerate the mysql database which will contain your mysql users and
their privileges.

-- 

  //Aho
0
Reply J 7/17/2010 5:57:47 PM

In article <ac7fddec-ff5b-4510-bc52-f5da21448a0e@n19g2000prf.googlegroups.com>, jr <jlrough@yahoo.com> wrote:
>On Jul 17, 9:27=A0am, spamb...@milmac.com (Doug Miller) wrote:
>> In article <i1sl2r$8s...@news.eternal-september.org>, spamb...@milmac.com=
> (Doug Miller) wrote:
>> >In article <2098aa42-4c9c-4a21-8593-dd831b605...@q21g2000prm.googlegroup=
>s.com>,
>> > JRough <jlro...@yahoo.com> wrote:
>> >>Okay, thanks, here is the real error message:
>> >>h-3.2# /usr/local/mysql/bin/mysqld -h localhost --user=3Droot
>> >>100717 =A05:27:29 [Warning] Can't create test file /usr/local/
>> >>mysql-5.0.77-osx10.4-powerpc/localhost/Janis-Rough.lower-test
>>
>> >Has it occurred to you to wonder why that file can't be created? If so, =
>has it
>> >occurred to you to investigate the possible causes?
>>
>> >>100717 =A05:27:29 [Warning] Can't create test file /usr/local/
>> >>mysql-5.0.77-osx10.4-powerpc/localhost/Janis-Rough.lower-test
>>
>> >Same questions.
>>
>> >>/usr/local/mysql/bin/mysqld: Can't change dir to '/usr/local/
>> >>mysql-5.0.77-osx10.4-powerpc/localhost/' (Errcode: 2)
>> >>100717 =A05:27:29 [ERROR] Aborting
>>
>> >What possible reasons could there be for a change-directory command to fail?
>>
>> And have you checked to see what Errcode: 2 means?
>
>I would like to know if the only answer is to reinstall mysql?

I would like to know if you have investigated the reasons for the error 
messages you've received. In particular, do you know what Errcode 2 means?
0
Reply spambait 7/17/2010 7:55:36 PM

14 Replies
206 Views

(page loaded in 0.018 seconds)

Similiar Articles:


















7/17/2012 4:38:18 AM


Reply: