OS X 10.2.2: MySQL is running but I can not acces it with the terminal

Hello together,
Early this year I created some test-db's. They are still accessable via
the Internet-Explorer.
Today I wanted to make some changes to the structure but could not
access MySQL.

Please can anybody help me what is possibly wrong?
Can it be that the "SQL4X MySQL Manager" is the reason?

Tomorrow I should do a presentation ...

Kind regards
Helmuth Lutz

This is the terminal response:
Welcome to Darwin!
[hlutz:~] hlutz% MySQL -u root -p
MySQL: Command not found.

[hlutz:~] hlutz% cd /usr/local/mysql
[hlutz:/usr/local/mysql] hlutz% mysql -u root -p
mysql: Command not found.

[hlutz:/usr/local/mysql] hlutz% ps ax | grep mysql
645 ?? S 0:00.14 sh ./bin/safe_mysqld
687 ?? S 0:00.17 /usr/local/mysql/bin/mysqld
709 std R+ 0:00.01 grep mysql




------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail
To unsubscribe, e-mail
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: OS X 10.2.2: MySQL is running but I can not acces it with theterminal

At 18:54 +0100 12/15/02, Helmuth Lutz wrote:
>Hello together,
>Early this year I created some test-db's. They are still accessable
>via the Internet-Explorer.
>Today I wanted to make some changes to the structure but could not
>access MySQL.
>
>Please can anybody help me what is possibly wrong?
>Can it be that the "SQL4X MySQL Manager" is the reason?
>
>Tomorrow I should do a presentation ...
>
>Kind regards
>Helmuth Lutz
>
>This is the terminal response:
>Welcome to Darwin!
>[hlutz:~] hlutz% MySQL -u root -p
>MySQL: Command not found.

Try mysql, not MySQL. And make sure that the directory in which the
mysql program is located is in your PATH. From the looks of your ps output
below, I'd guess it's in the same directory as mysqld (/usr/local/mysql/bin).

>
>[hlutz:~] hlutz% cd /usr/local/mysql
>[hlutz:/usr/local/mysql] hlutz% mysql -u root -p
>mysql: Command not found.
>
>[hlutz:/usr/local/mysql] hlutz% ps ax | grep mysql
> 645 ?? S 0:00.14 sh ./bin/safe_mysqld
> 687 ?? S 0:00.17 /usr/local/mysql/bin/mysqld
> 709 std R+ 0:00.01 grep mysql


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail
To unsubscribe, e-mail
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: OS X 10.2.2: MySQL is running but I can not acces it with the

Paul, nice to here from you,

Could you please tell me where probably to find (directory / file) the line
where PATH has to be set?

Some month ago I created my databases and php-scripts on a small partition
with OS X 10.1.4. Here I installed the package from Marc Lyanage including
php 4 but I do not remeber the hints and small things to keep an eye to.

Thereafter I changed my partition which runs now with OS X 10.2.2. I copied
some visible directories within the Finder but did not install anything. I
found the directory /usr/local/mysql/ and assumed everything to be ok
because all databases could be accessed with Internet-Explorer and they
work as always.

In the StartupItems I found two files: "my.conf" which is called by the
file "MySQL".

The configuration-file under my old partition should contain the right PATH
- but what should be the name of this file and where should it be located.

Thanks and kind regards
Helmuth Lutz



At 21:43 +0100 12/15/02, Helmuth Lutz wrote:
>Does anybody have an idea:
>
>- WHY does my currently installed MySQL 3.23.46 start at System-Start?

Becasue something or someone installed the proper startup stuff under
System/Library/StartupItems.

>- WHY do the currently installed db's work within Internet-Explorer?

I have no idea what that is supposed to mean.

>- WHY does the terminal not know the commands: mysql or mysqladmin?
>---- Not as user neither as root
>
>The terminal response:
>[hlutz:/usr/local/mysql] hlutz# mysqladmin -u root user -p version
>mysqladmin: Command not found.

Because your PATH doesn't include the directory where these programs
are located.

>
>Any help is welcome.
>
>Kind regards
>Helmuth Lutz



------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail
To unsubscribe, e-mail
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php