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: access denied after installation of mysql(from source) - comp ...... path to /usr/local/mysql/var The GRANT tables has been created (mysql_install_db), but I can't ... MYSQL won't overwrite an existing OUTFILE. How can I ... t resolve to ... IN6ADDR_ANY_INIT doesn't resolve to localhost? - comp.unix.solaris ...IN6ADDR_ANY_INIT doesn't resolve to localhost? - comp.unix ..... can't resolve the path - comp.databases.mysql ... is in DNS, and can resolve its own hostname ... 127.0 ... Java Applets connecting to Databases: access denied (java.net ...... doesn't resolve to localhost? - comp.unix.solaris ..... java.net.SocketPermission "localhost:1-9000", "connect,accept,listen,resolve ... try ... can't resolve the path ... can't get real path - comp.unix.solarisNow, when I issue $ pfexec /home/myuser/patchadd patchadd: can't get real path I got. ... I dived into opensolaris sources and found a macro ... mysqld can't ... IPv6 addresses in mysql databases - comp.databases.mysql ...Resolving ... the loopback interface also does ... mpc can't resolve "localhost" if ... IPv6 addresses in the database is going to be a bit more difficult, as MySQL doesn’t ... Libname Function and Connection Strings - comp.soft-sys.sas ...... DATAIN' then do; libn = libname(parameter, resolve(value ... value (for all other libname assignments) is the path. ... If you can't get it to work you may be able to use CALL ... Can't connect to local MySQL server through socket '/var/mysql ...... usr/local/mysql/bin/mysql -user=mysql ERROR 2002 (HY000): Can't connect to local MySQL s... ... var/mysql/mysql.sock >> >> The entire MY.CONF >> [mysqld] >> #Path to ... mysqldump error - comp.databases.mysql... LIKE' filename : Commands out of sync: you can't run ... Nevermind, I just used mysqldump db_name mysql.dump and ... comp.unix.solaris > I am a bit lost on how to resolve the ... [error] Can't load Perl module DBI for server localhost:80 ...I am very sure that @INC contains the right path, and simple DBI stuff can run on the ... MySQL: Why can't I ... the server can be ... Why can't I find ... No breakpoints with GUI - comp.soft-sys.matlab... has been ongoing for quite a while, but I just can't ... two copies of the file, one that is on the path (and so can ... try what they recommended and if so, did it resolve ... Installing perl DBD::mysql - comp.unix.solaris... for DBD::mysql () chmod 644 mysql.bs rm -f blib/arch/auto/DBD/mysql/mysql.so LD_RUN_PATH ... DBD/mysql/mysql.so' /usr/ccs/bin/make -- NOT OK Running make test Can't ... Runtime error -- mclmcrrt**.dll version conflict - comp.soft-sys ...Need help on Java server configuration - comp.sys.tandem ..... link Path used to resolve the DLL. Check the API manual for your version of ... have been lucky in that ... Can't modify httpd.conf under apache 2.2.16 - comp.infosystems.www ...Installing MySQL-Cluster: can't start management server - comp ... Can ... IN6ADDR_ANY_INIT doesn't resolve to localhost? - comp.unix.solaris ... Can't modify httpd.conf under ... remsh between HPUX and Linux - comp.sys.hp.hpuxHow can I change this so that the PATH I'm working with is the one for the account on the Linux ... work with pointed out that the particular quotes used resolve $PATH before ... differences between /bin, /usr/bin and /usr/local/bin - comp.unix ...... presumably continue to work, and there's no reason you can't ... bin and /usr/local/bin - comp.unix ..... server it cannot resolve the path? sh-3.2# sudo /usr/local/mysql ... MySQL :: InnoDB can't find "the path" specifiedInnoDB: for how to resolve the issue ... directory named "tmp" within the MySQL and InnoDB Data-Dir. But this hasn't ... InnoDB can't find "the path" specified: 2478: Marc Richter MySQL :: MySQL 5.5 Reference Manual :: 5.1.2 Server Command OptionsWhen you start the mysqld server, you can specify program ... --skip-name-resolve. Do not resolve host names when ... t path 7/17/2012 4:38:18 AM
|