At 12:24 -0800 3/17/04, ryan@stripped wrote:
>Hey,
>Thanks for replying.
>
>I see that my mysql server IS running...
>
>> Do you have a /var/lib/mysql/mysql.sock file? How about /tmp/mysql.sock?
>
>**That didnt work.
"Didn't work"? I didn't ask you do try anything, I just asked if either
of those files exist.
>
>**And neither did this:
>[root@bestwebhosters root]# mysqladmin -u root -h 127.0.0.1 variables
>mysqladmin: connect to server at '127.0.0.1' failed
>
>error: 'Access denied for user: 'root@bestwebhosters' (Using password: NO)'
That's a good sign, actually. I means that mysqladmin was able to
find the server and attempt to connect to it. That's good. The server rejected
the connection attempt, so that's not so good. :-)
I would next ask you to try specifying your password:
mysqladmin -u root -p -h 127.0.0.1 variables
except that you may not know it, correct?
>
>
>**Then tried to do a search:
>
>[root@bestwebhosters root]# find / -name *mysql.sock*
>find: /proc/23989/fd: No such file or directory
>/home/virtual/site1/fst/var/lib/mysql/mysql.sock
>[root@bestwebhosters root]#
>
>**Finally this gave some results
The following occurs because you didn't tell mysqladmin to do anything,
so it prints its help message. This would happen regardless of whether
the server is running.
>
>[root@bestwebhosters root]# mysqladmin -u root -p
>mysqladmin Ver 8.40 Distrib 4.0.18, for pc-linux on i686
>Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
>This software comes with ABSOLUTELY NO WARRANTY. This is free software,
>and you are welcome to modify and redistribute it under the GPL license
>
>Administration program for the mysqld daemon.
>Usage: mysqladmin [OPTIONS] command command....
> -c, --count=# Number of iterations to make. This works with -i
> (--sleep) only
> -#, --debug[=name] Output debug log. Often this is 'd:t:o,filename'
> -f, --force Don't ask for confirmation on drop database; with
> multiple commands, continue even if an error occurs.
> -C, --compress Use compression in server/client protocol
[etc]
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
MySQL Users Conference: April 14-16, 2004
http://www.mysql.com/uc2004/
