change .bash_login environment variable to reflect a sym link to mysql install directory

[JRough]

This is my current .bash_login:
export PATH="/usr/local/bin:/usr/local/sbin:/usr/local/mysql*/bin:
$PATH"

I need it to be this:
/usr/local/bin:/usr/local/sbin:/usr/local/mysql*/bin:/usr/bin:/bin:/
usr/sbin:/sbin:/usr/local/bin:/usr/X11/bin

Do I just add the end that is missing of this before the ending :
$PATH"?
/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin:/usr/X11/bin

I figured out what was wrong. The mysql* in the path is a sym link to
the mysql-5.1.40-osx10.5-powerpc directory so you don't have to type
in the whole thing. I don't know why all this part was missing but
hopefully it will work now. I got this by doing a pwd in the mysql
directory and I guess the sym link adds the rest of it.

thanks,

[Bill Marcum]

On 2009-12-22, JRough <jlr...@yahoo.com> wrote:
> This is my current .bash_login:
> export PATH="/usr/local/bin:/usr/local/sbin:/usr/local/mysql*/bin:
> $PATH"
>
> I need it to be this:
> /usr/local/bin:/usr/local/sbin:/usr/local/mysql*/bin:/usr/bin:/bin:/
> usr/sbin:/sbin:/usr/local/bin:/usr/X11/bin
>
> Do I just add the end that is missing of this before the ending :
> $PATH"?
> /usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin:/usr/X11/bin
>

Some of those directories will probably already be in PATH, but it's harmless
if a directory is listed twice. You can type "echo $PATH" at a command
prompt to see what is in there.

[JRough]

On Dec 22, 1:04 pm, Bill Marcum <marcumb...@bellsouth.net> wrote:

Well something seems wrong already. There is a scripts directory with
a mysql_install_db script. It doesn't run. I tried it in the script
directory and one level above.
janis-roughs-power-mac-g5:scripts jlrough$ ls
mysql_install_db
janis-roughs-power-mac-g5:scripts jlrough$ mysql_install_db --
user=mysql
-bash: mysql_install_db: command not found
janis-roughs-power-mac-g5:scripts jlrough$ pwd
/usr/local/mysql/scripts
janis-roughs-power-mac-g5:scripts jlrough$

This is frustrating because I followed the instructions word for
word.
janis-roughs-power-mac-g5:mysql jlrough$ scripts/mysql_install_db --
user=mysql

FATAL ERROR: Could not find mysqld

The following directories were searched:

/usr/local/mysql-5.0.82-osx10.5-powerpc/bin//libexec
/usr/local/mysql-5.0.82-osx10.5-powerpc/bin//sbin
/usr/local/mysql-5.0.82-osx10.5-powerpc/bin//bin

If you compiled from source, you need to run 'make install' to
copy the software into the correct location ready for operation.

If you are using a binary release, you must either be at the top
level of the extracted archive, or pass the --basedir option
pointing to that location.

Is it the path or because I need to run make and make install?
I tried both of them and that didn't work either.

janis-roughs-power-mac-g5:mysql jlrough$ make
make: *** No targets specified and no makefile found. Stop.
janis-roughs-power-mac-g5:mysql jlrough$ make install
make: *** No rule to make target `install'. Stop.

any ideas would be appreciated.

[Jon LaBadie]

Do you have a directory literally named "mysql*" ?

I ask because the "*" will be taken literally in the PATH.
It will not be expanded to version numbers for example.

[OldSchool]

"I need it to be this:
/usr/local/bin:/usr/local/sbin:/usr/local/mysql*/bin:/usr/bin:/bin:/
usr/sbin:/sbin:/usr/local/bin:/usr/X11/bin

.
.
.

The mysql* in the path is a sym link to the mysql-5.1.40-osx10.5-

powerpc directory..."

As Jon noted, the directory is probably NOT "/usr/local/mysql*", but
rather "/usr/local/mysql". I'd bet the "*" is an artifact of a GNU
derived "ls" command. You can find out by trying "cd /usr/local/
mysql". if that works, remove the "*" from the above...

The fact that its a symbolic link doesn't matter one way or the
other...i.e. you can use either (provided the symlink is correctly
entered).

one advantage of the using the symlink over the full path is that the
correct full path may change if you subsequently upgrade, while the
symlink *should* remain the same name and always point at the
installation......

[JRough]

Well thanks that did something. It does have a sym link so you don't
have to type the long directory name. I was able to try to start the
mysql
demon but it still seems like it still has some path issues.

sh-3.2# /usr/local/mysql/bin/mysqld_safe --user=_mysql

091223 09:59:48 mysqld_safe Logging to '/usr/local//usr/local/
mysql-5.0.82-osx10.5-powerpc/data/janis-roughs-power-mac-
g5.local.err'.
touch: /usr/local//usr/local/mysql-5.0.82-osx10.5-powerpc/data/janis-
roughs-power-mac-g5.local.err: No such file or directory
chown: /usr/local//usr/local/mysql-5.0.82-osx10.5-powerpc/data/janis-
roughs-power-mac-g5.local.err: No such file or directory
091223 09:59:49 mysqld_safe Starting mysqld daemon with databases
from /usr/local//usr/local/mysql-5.0.82-osx10.5-powerpc/data
/usr/local/mysql/bin/mysqld_safe: line 100: /usr/local//usr/local/
mysql-5.0.82-osx10.5-powerpc/data/janis-roughs-power-mac-g5.local.err:
No such file or directory
/usr/local/mysql/bin/mysqld_safe: line 137: /usr/local//usr/local/
mysql-5.0.82-osx10.5-powerpc/data/janis-roughs-power-mac-g5.local.err:
No such file or directory
091223 09:59:49 mysqld_safe mysqld from pid file /usr/local//usr/local/
mysql-5.0.82-osx10.5-powerpc/data/janis-roughs-power-mac-g5.local.pid
ended
/usr/local/mysql/bin/mysqld_safe: line 100: /usr/local//usr/local/
mysql-5.0.82-osx10.5-powerpc/data/janis-roughs-power-mac-g5.local.err:
No such file or directory

Is it still the $PATH variable that is wrong and it can't find
something or what? What is line 100 & 137 about? It needs the data
directory which is what I saved from the old install since it has
databases in there. I think the user and groups are right. I am
starting it as _mysql user.
Here is my directory
drwxr-xr-x 17 root _mysql 578 Dec 23 09:54 .
drwxr-xr-x 8 root wheel 272 Dec 22 11:14 ..
-rw-r--r-- 1 root _mysql 19071 Oct 6 15:51 COPYING
-rw-r--r-- 1 root _mysql 5139 Oct 6 15:51 EXCEPTIONS-CLIENT
-rw-r--r-- 1 root _mysql 9439 Oct 6 15:51 INSTALL-BINARY
-rw-r--r-- 1 root _mysql 62989 Oct 6 15:51 README
drwxr-xr-x 46 root _mysql 1564 Oct 6 15:51 bin
drwxr-xr-x 4 _mysql _mysql 136 Dec 23 09:50 data
drwxr-xr-x 4 root _mysql 136 Oct 6 15:50 docs
drwxr-xr-x 34 root _mysql 1156 Oct 6 15:50 include
drwxr-xr-x 22 root _mysql 748 Oct 6 15:51 lib
drwxr-xr-x 4 root _mysql 136 Oct 6 15:50 man
drwxr-xr-x 15 root _mysql 510 Oct 6 15:51 mysql-test
drwxr-xr-x 3 root _mysql 102 Oct 6 15:51 scripts
drwxr-xr-x 35 root _mysql 1190 Oct 6 15:51 share
drwxr-xr-x 29 root _mysql 986 Oct 6 15:51 sql-bench
drwxr-xr-x 16 root _mysql 544 Oct 6 15:51 support-files

[OldSchool]

> something or what?  What is line 100 & 137 about? ....

lines 100 and 137 appear to refer to those lines in the script " /usr/
local/mysql/bin/mysqld_safe"

the remainder of the errors seem to indicate that it can't find:
"/usr/local//usr/local/mysql-5.0.82-osx10.5-powerpc/data/'

to create files in...but the path names are so attrocious, I'm not
sure..I'd bet it is supposed to be:

"/usr/local/mysql-5.0.82-osx10.5-powerpc/data/"

which may mean there was an error / typo in the installation process,
or that the environment variables aren't properly set-up in the
profile

[JRough]

Would that be the $PATH environment variable? That is probably it.
How can I fix it? I guess what I added is wrong. I changed it above
because of the sym link.
When I did pwd in the mysql symlink directory I got this path so I
changed my $PATH from this:

export PATH="/usr/local/bin:/usr/local/sbin:/usr/local/mysql*/bin:

to

this:
/usr/local/bin:/usr/local/sbin:/usr/local/mysql*/bin:/usr/bin:/bin:/
usr/sbin:/sbin:/usr/local/bin:/usr/X11/bin

Now I know the * should be deleted for reasons mentioned above so
should I just take off the appendage and will that fix it?THANKS,
I don't know why adding the sym link changed it from the first to the
second but I can just change it back I guess.

[OldSchool]

its probably NOT that PATH variable thats hosed at this point. You
need to find the script you ran, and examine the two lines noted (100
and 137??). You may see a reference to a variable in that line. If
so, thats the one that is currently not right....

As to how it got to be "not right", that could have been done during
installation, or when you set up whatever had to be added
to .profile / .bashrc or whatever.

I'm not familiar w/ the install process for MySQL, nor do I have it
installed anywhere handy, so I can't look into what else might be
wrong. You might also try to locate a MySQL forum / group. They
might have somebody that's seen similar issues before, and knows what
it is off the top of there head.

you could also run "env > somefile" and see if you can indentify a
variable that's set to something begining "/usr/local//usr/
local......."