OS 10.2, mysql 4.0, command not found

mgm_03

I don't know what happened....

Last week I had mysql running (4.01) on OS 10.2. I had the "Welcome to MyQL Monitor" message and a mysql> prompt.

I downloaded phpMyadmin and am trying to configure it properly (or test if it is).

Now, when I get into my Terminal and go to:

cd /user/local/mysql/bin

and enter: sudo mysqld_safe, all I get is "command not found"

sudo mysqladmin ...pls enter password....I enter password and get

"sudo: mysqladmin : command not found"

I try:
sudo mysql -u root mysql ....pls enter password... command not found.

Any ideas as to what I am doing wrong?

Did I screw up my maching?

Mark

yelvington

I dumped OS X in favor of Linux, but my guess would be that you have mysql installed in a location that is not in the path. It's likely that sudo is configured not to execute files in the current director.

Try adding dot-slash in front of the command you are passing to sudo:

sudo ./mysql_safe

sudo ./mysqladmin

(Although I do not understand why you would need to run mysqladmin as the operating system's superuser. Try ./mysqladmin -uroot -ppassword.)

mgm_03

Thanks...that worked.
The reason I used sudo is because I don't know what what the hell I am doing in Unix. 😕

Now, when I run ./bin/mysqld_safe, I get 7 statements telling "...permission denied..."

once is enough, don't you think?

Thx.

yelvington

You do need to be superuser in order to start the server, but not to use mysql (even as the mysql administrator).

So, run mysqld_safe as root (or using sudo), but mysqladmin, mysql, etc., as your ordinary identity. In order to assume admin powers once the server is running, do

mysqladmin -uroot -ppassword
or
mysql -uroot -ppassword

et cetera.

I think the raw install comes with no password for the root account. You should change that right away.

The reason the startup program gives more than one error is that it's actually a script that does a number of things, including spawning multiple database server daemons.

greg252

Originally posted by yelvington
I dumped OS X in favor of Linux

I dumped RH Linux for OS X... funny how people are different.

mgm_03

Your continuing patience is much appreciated on this issue. Rest assured I have been trying to rely on doc, tutorials, and google searches to learn what I can before posting ... didn't anticipate the need to understand the workings of OSX in so much depth.

Right now, this is what I'm getting:

Starting mysqld daemon with databases from /usr/local/mysql/data
030809 20:11:09 mysqld ended

I think I located my err log but don't know how to open it. the file name is :

Marks-Computer.local..err (odd?)