Dear Marek,
After I type the following command (./bin/mysqladmin -h 192.10.0.113) it
show as below:
# ./bin/mysqladmin -h 192.10.0.113
./bin/mysqladmin Ver 8.23 Distrib 3.23.46, for sun-solaris2.8 on sparc
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: ./bin/mysqladmin [OPTIONS] command command....
-#, --debug=... 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
-?, --help Display this help and exit
--character-sets-dir=...
Set the character set directory
-C, --compress Use compression in server/client protocol
-h, --host=# Connect to host
-p, --password[=...] Password to use when connecting to server
If password is not given it's asked from the tty
-P --port=... Port number to use for connection
-i, --sleep=sec Execute commands again and again with a sleep
between
-r, --relative Show difference between current and previous values
when used with -i. Currently works only with
extended-status
-E, --vertical Print output vertically. Is similar to --relative,
but prints output vertically.
-s, --silent Silently exit if one can't connect to server
-S, --socket=... Socket file to use for connection
-u, --user=# User for login if not current user
-v, --verbose Write more information
-V, --version Output version information and exit
-w, --wait[=retries] Wait and retry if connection is down
Default options are read from the following files in the given order:
/etc/my.cnf /usr/local/mysql/var/my.cnf ~/.my.cnf
The following groups are read: mysqladmin client
The following options may be given as the first argument:
--print-defaults Print the program argument list and exit
--no-defaults Don't read default options from any options file
--defaults-file=# Only read default options from the given file #
--defaults-extra-file=# Read this file after the global files are read
Possible variables for option --set-variable (-O) are:
connect_timeout current value: 0
shutdown_timeout current value: 3600
Where command is a one or more of: (Commands may be shortened)
create databasename Create a new database
drop databasename Delete a database and all its tables
extended-status Gives an extended status message from the server
flush-hosts Flush all cached hosts
flush-logs Flush all logs
flush-status Clear status variables
flush-tables Flush all tables
flush-threads Flush the thread cache
flush-privileges Reload grant tables (same as reload)
kill id,id,... Kill mysql threads
password new-password Change old password to new-password
ping Check if mysqld is alive
processlist Show list of active threads in server
reload Reload grant tables
refresh Flush all tables and close and open logfiles
shutdown Take server down
status Gives a short status message from the server
start-slave Start slave
stop-slave Stop slave
variables Prints variables available
version Get version info from server
Does it mean MySQL server is running fine ?
Thanks again,
Kevin Chan
<Marek Zaradzki Wrote>
Sent: Thursday, December 27, 2001 5:33 PM
Subject: Re: Why I can't run Mysql program ? Please Help !
> try ip__adress__
>
> mysql -h ip_address
>
> ----- Original Message -----
> From: "Kevin Chan" <[EMAIL PROTECTED]>
> To: "Marek Zaradzki" <[EMAIL PROTECTED]>
> Cc: "Phillip B. Bruce" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Thursday, December 27, 2001 10:18 AM
> Subject: Re: Why I can't run Mysql program ? Please Help !
>
>
> > Dear Marek and all,
> >
> > I find out 3306 is listening show as below :
> >
> > # netstat -an
> > *.3306 *.* 0 0 24576 0 LISTEN
> >
> > # pwd
> > /usr/local/mysql-3.23.46-sun-solaris2.8-sparc
> > # ./bin/mysql -h sune250
> > ERROR 2005: Unknown MySQL Server Host 'sune250' (2)
> >
> > Do you know what's wrong ?
> >
> > Thanks a lot,
> > Kevin Chan
> >
> > <Marek Zaradzki Wrote>
> > Sent: Thursday, December 27, 2001 4:09 PM
> > Subject: Re: Why I can't run Mysql program ? Please Help !
> >
> >
> > > try command
> > > netstat -an
> > > to check if file socket is created.
> > >
> > > try
> > > mysql -h sune250
> > >
> > >
> > >
> > > ----- Original Message -----
> > > From: "Kevin Chan" <[EMAIL PROTECTED]>
> > > To: "Marek Zaradzki" <[EMAIL PROTECTED]>; "Phillip B.
> Bruce"
> > > <[EMAIL PROTECTED]>
> > > Cc: <[EMAIL PROTECTED]>
> > > Sent: Thursday, December 27, 2001 8:46 AM
> > > Subject: Re: Why I can't run Mysql program ? Please Help !
> > >
> > >
> > > > Dear Marek and all,
> > > >
> > > > I only can find one file end with err (sune250.trasy.com.err) and I
> > can't
> > > > find any error message on that file after I run the following
command:
> > > >
> > > > # ./bin/mysql
> > > > ERROR 2002: Can't connect to local MySQL server through socket
> > > > 'path-for-socket-file' (2)
> > > > #
> > > > # pwd
> > > > /usr/local/mysql-3.23.46-sun-solaris2.8-sparc/data
> > > > #
> > > > # ls
> > > > mysql sune250.trasy.com.err
> > > > path-for-socket-file test
> > > > #
> > > > # more sune250.trasy.com.err
> > > > 011207 10:59:37 mysqld started
> > > > /usr/local/mysql-3.23.46-sun-solaris2.8-sparc/bin/mysqld: ready for
> > > > connections
> > > > 011221 15:18:28
> > /usr/local/mysql-3.23.46-sun-solaris2.8-sparc/bin/mysqld:
> > > > Normal shutdown
> > > > 011221 15:18:28
> > /usr/local/mysql-3.23.46-sun-solaris2.8-sparc/bin/mysqld:
> > > > Shutdown Complete t: 3306 ?
> > > > 011207 15:11:18 Aborting
> > > > 011207 15:11:18
> > /usr/local/mysql-3.23.46-sun-solaris2.8-sparc/bin/mysqld:
> > > > Shutdown Complete
> > > > 011207 15:11:18 mysqld ended
> > > > 011207 15:35:34 mysqld started
> > > > 011207 15:35:34 Can't start server: Bind on TCP/IP port: Address
> > already
> > > in
> > > > use
> > > > 011207 15:35:34 Do you already have another mysqld server running
on
> > > port:
> > > > 3306 ?
> > > > 011207 15:35:34 Aborting
> > > > 011207 15:35:34
> > /usr/local/mysql-3.23.46-sun-solaris2.8-sparc/bin/mysqld:
> > > > Shutdown Complete
> > > > 011207 15:35:34 mysqld ended
> > > > 011221 12:03:40 mysqld started
> > > > 011221 12:03:40 Can't start server: Bind on TCP/IP port: Address
> > already
> > > in
> > > > use
> > > > 011221 12:03:40 Do you already have another mysqld server running
on
> > > port:
> > > > 3306 ?
> > > > 011221 12:03:40 Aborting
> > > > 011221 12:03:40
> > /usr/local/mysql-3.23.46-sun-solaris2.8-sparc/bin/mysqld:
> > > > Shutdown Complete
> > > > 011221 12:03:40 mysqld ended
> > > > 011221 12:53:16 mysqld started
> > > > 011221 12:53:16 Can't start server: Bind on TCP/IP port: Address
> > already
> > > in
> > > > use
> > > > 011221 12:53:16 Do you already have another mysqld server running
on
> > > port:
> > > > 3306 ?
> > > > 011221 12:53:16 Aborting
> > > > 011221 12:53:16
> > /usr/local/mysql-3.23.46-sun-solaris2.8-sparc/bin/mysqld:
> > > > Shutdown Complete
> > > > 011221 12:53:16 mysqld ended
> > > > 011221 14:46:15 mysqld started
> > > > 011221 14:46:15 Can't start server: Bind on TCP/IP port: Address
> > already
> > > in
> > > > use
> > > > 011221 14:46:15 Do you already have another mysqld server running
on
> > > port:
> > > > 3306 ?
> > > > 011221 14:46:15 Aborting
> > > > 011221 14:46:15
> > /usr/local/mysql-3.23.46-sun-solaris2.8-sparc/bin/mysqld:
> > > > Shutdown Complete
> > > > 011221 14:46:15 mysqld ended
> > > > 011221 15:18:28 mysqld ended
> > > > 011221 15:21:02 mysqld started
> > > > /usr/local/mysql-3.23.46-sun-solaris2.8-sparc/bin/mysqld: ready for
> > > > connections
> > > > 011224 15:03:03
> > /usr/local/mysql-3.23.46-sun-solaris2.8-sparc/bin/mysqld:
> > > > Normal shutdown
> > > > 011224 15:03:04
> > /usr/local/mysql-3.23.46-sun-solaris2.8-sparc/bin/mysqld:
> > > > Shutdown Complete t: 3306 ?
> > > > 011224 12:39:20 Aborting
> > > > 011224 12:39:20
> > /usr/local/mysql-3.23.46-sun-solaris2.8-sparc/bin/mysqld:
> > > > Shutdown Complete
> > > > 011224 12:39:20 mysqld ended
> > > > A mysqld process already exists at Mon Dec 24 12:40:36 CST 2001
> > > > 011224 15:03:04 mysqld ended
> > > > 011224 15:05:37 mysqld started
> > > > /usr/local/mysql-3.23.46-sun-solaris2.8-sparc/bin/mysqld: ready for
> > > > connections
> > > >
> > > > Would you mind to tell me what I must be change to solve the problem
?
> > > > Thanks for your help!
> > > >
> > > > Thanks again,
> > > > Kevin Chan
> > > >
> > > >
> > > > <Marek Zaradzki Wrote>
> > > > Sent: Thursday, December 27, 2001 3:05 PM
> > > > Subject: Re: Why I can't run Mysql program ? Please Help !
> > > >
> > > >
> > > > > Dear Marek and all,
> > > > >
> > > > > The directory for MySQL (/etc/local)as below:
> > > > >
> > > > > lrwxrwxrwx 1 root other 34 Dec 5 16:32 mysql ->
> > > > > mysql-3.23.46-sun-solaris2.8-sparc
> > > > > drwxr-xr-x 13 root mysql 512 Dec 5 16:30
> > > > > mysql-3.23.46-sun-solaris2.8-sparc
> > > > >
> > > > > Thanks and regards,
> > > > > Kevin Chan
> > > > >
> > > > > <Marek Zaradzki Wrote>
> > > > > Sent: Thursday, December 27, 2001 2:58 PM
> > > > > Subject: Re: Why I can't run Mysql program ? Please Help !
> > > > >
> > > > >
> > > > > > Hello
> > > > > > look at the permitions of mysql data directory.
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > ----- Original Message -----
> > > > > > From: "Kevin Chan" <[EMAIL PROTECTED]>
> > > > > > To: "Phillip B. Bruce" <[EMAIL PROTECTED]>
> > > > > > Cc: "Michael Brunson" <[EMAIL PROTECTED]>;
> > > > <[EMAIL PROTECTED]>;
> > > > > > <[EMAIL PROTECTED]>
> > > > > > Sent: Thursday, December 27, 2001 7:49 AM
> > > > > > Subject: Re: Why I can't run Mysql program ? Please Help !
> > > > > >
> > > > > >
> > > > > > > Dear Phillip and all,
> > > > > > >
> > > > > > > I am installing from Binary Distribution and just follow the
> > > > > > INSTALL-BINARY
> > > > > > > file to install. I just did all the steps below:
> > > > > > >
> > > > > > > shell> groupadd mysql
> > > > > > > shell> useradd -g mysql mysql
> > > > > > > shell> cd /usr/local
> > > > > > > shell> gunzip < /path/to/mysql-VERSION-OS.tar.gz | tar xvf -
> > > > > > > shell> ln -s mysql-VERSION-OS mysql
> > > > > > > shell> cd mysql
> > > > > > > shell> scripts/mysql_install_db
> > > > > > > shell> chown -R root /usr/local/mysql
> > > > > > > shell> chown -R mysql /usr/local/mysql/data
> > > > > > > shell> chgrp -R mysql /usr/local/mysql
> > > > > > > shell> chown -R root /usr/local/mysql/bin
> > > > > > > shell> bin/safe_mysqld --user=mysql &
> > > > > > >
> > > > > > > Thanks and regards,
> > > > > > > Kevin Chan
> > > > > > >
> > > > > > >
> > > > > > > <Phillip B. Bruce Wrote>
> > > > > > > Sent: Thursday, December 27, 2001 2:35 PM
> > > > > > > Subject: Re: Why I can't run Mysql program ? Please Help !
> > > > > > >
> > > > > > >
> > > > > > > > Kevin Chan wrote:
> > > > > > > >
> > > > > > > > > Dear Michael and all,
> > > > > > > > >
> > > > > > > > > Hi Michael, do you mind to tell me where is the location
of
> > the
> > > > > my.cnf
> > > > > > > file
> > > > > > > > > in my michane (Sun Solaris2.8) beacuse I can't find it ?
> > > > > > > > >
> > > > > > > > > And what I should change on that file to solve the
problem?
> > ...
> > > > > thanks
> > > > > > !
> > > > > > > > >
> > > > > > > > > Thanks and regards,
> > > > > > > > > Kevin Chan
> > > > > > > > >
> > > > > > > > > <Michael Brunson Wrote>
> > > > > > > > > Sent: Thursday, December 27, 2001 12:35 PM
> > > > > > > > > Subject: Re: Why I can't run Mysql program ? Please Help !
> > > > > > > > >
> > > > > > > > > On Thu, 27 Dec 2001 12:00:08 +0800, "Kevin Chan"
> > > > > <[EMAIL PROTECTED]>
> > > > > > > > > wrote:
> > > > > > > > > [...]
> > > > > > > > > | # ./bin/mysql
> > > > > > > > > | ERROR 2002: Can't connect to local MySQL server through
> > socket
> > > > > > > > > | 'path-for-socket-file' (2)
> > > > > > > > > [...]
> > > > > > > > >
> > > > > > > > > You may want to edit your my.cnf file to have the path to
> the
> > > > socket
> > > > > > > file.
> > > > > > > > >
> > > > > > > > > Thanks,
> > > > > > > > > Michael
> > > > > > > > >
> > > > > > > >
> > > > >
> > > ---------------------------------------------------------------------
> > > > > > > > > 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
> > > <[EMAIL PROTECTED]>
> > > > > > > > > To unsubscribe, e-mail
> > > > > > > <[EMAIL PROTECTED]>
> > > > > > > > > Trouble unsubscribing? Try:
> > > > > http://lists.mysql.com/php/unsubscribe.php
> > > > > > > >
> > > > > > > > Kevin,
> > > > > > > >
> > > > > > > > If you had read the instruction from INSTALL-SOURCE you
> > would
> > > > have
> > > > > > > found the
> > > > > > > > following
> > > > > > > >
> > > > > > > > shell> useradd -g mysql mysql
> > > > > > > > shell> gunzip < mysql-VERSION.tar.gz | tar -xvf -
> > > > > > > > shell> cd mysql-VERSION
> > > > > > > > shell> ./configure --prefix=/usr/local/mysql
> > > > > > > > shell> make
> > > > > > > > shell> make install
> > > > > > > > shell> scripts/mysql_install_db
> > > > > > > > shell> chown -R root /usr/local/mysql
> > > > > > > > shell> chown -R mysql /usr/local/mysql/var
> > > > > > > > shell> chgrp -R mysql /usr/local/mysql
> > > > > > > > shell> cp support-files/my-medium.cnf /etc/my.cnf
> > > > > > <===
> > > > > > > Here is
> > > > > > > > the step you left out
> > > > > > > > shell> /usr/local/mysql/bin/safe_mysqld --user=mysql &
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > --
> > > > > > > > ************************************************************
> > > > > > > > *** Phillip B. Bruce ***
> > > > > > > > *** http://pbbruce.home.mindspring.com ***
> > > > > > > > *** [EMAIL PROTECTED] ***
> > > > > > > > *** ***
> > > > > > > > *** "Have you ever noticed? Anybody going slower than ***
> > > > > > > > *** you is an idiot, and anyone going faster than you ***
> > > > > > > > *** is a maniac." - George Carlin ***
> > > > > > > > ************************************************************
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > >
> ---------------------------------------------------------------------
> > > > > > > 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
> <[EMAIL PROTECTED]>
> > > > > > > To unsubscribe, e-mail
> > > > > >
<[EMAIL PROTECTED]>
> > > > > > > Trouble unsubscribing? Try:
> > > http://lists.mysql.com/php/unsubscribe.php
> > > > > > >
> > > > >
> > > > >
> > > >
> > ---------------------------------------------------------------------
> > > > > 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 <[EMAIL PROTECTED]>
> > > > > To unsubscribe, e-mail
> > > > <[EMAIL PROTECTED]>
> > > > > Trouble unsubscribing? Try:
> http://lists.mysql.com/php/unsubscribe.php
> > > >
> >
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
