List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:January 8 2002 7:26pm
Subject:Re: Mysql connection problem
View as plain text  
The server is not telling you that mysql is not found.
The shell is telling you that mysql is not found because the the current 
directory
is not included in the PATH searched by the shell.

try ./mysql
or
/usr/local/bin/mysql.

Cindy Yu wrote:

>Hi Simon, 
>
>I appreicate your help. 
>
>Our server is a Solaris 5.6 server. After I cd to the mysql bin directory
> bindir=/usr/local/bin and connect to mysql server by using mysql or mysqladmin, the server
> shows me mysql not found and mysqladmin not found.  Can you give my some clue? You have
> much much more experience than me. I am frustrated and can not figure it out.
>
>mysql.server file shows:
>
>path=/sbin: /usr/sbin:/usr/bin
>basedir=/usr/local
>bindir=/usr/local/bin
>datadir=/usr/local/var
>pid-file=/usr/local/var/mysqld.pid
>log-file=/usr/local/var/mysqld.log
>
>Cindy
>
>>>>Simon Green <sgreen@stripped> 01/08 1:26 AM >>>
>>>>
>Ok.........
>Bring down server:
>Find the process by useing ps command.
>Then use the kill command and then send a TERM signal to the server to see
>if it will respond by shutting down normally.
>Check tables using myisamchk and isamchk.
>Restart server with  --skip-grant-tables   option.
>Set new root password.
>Now restart the server with mysqladmin and flush-privileges.
>
>Hope this helps....
>
>Simon 
>
>-----Original Message-----
>From: Cindy Yu [mailto:cyu@stripped] 
>Sent: 07 January 2002 18:17
>To: sgreen@stripped; Heikki.Tuuri@stripped;
>prabhu@stripped 
>Cc: mysql@stripped 
>Subject: Re: RE: Mysql connection problem
>
>
>Hi Simon, 
>
>Thanks for your reply. Can you tell me how to do it? I tried, but it shows
>me the error:
>
>"mysql not found".  How can I find mysql server?
>
>Cindy
>
>>>>Simon Green <sgreen@stripped> 01/07 10:05 AM >>>
>>>>
>No but you can start MySQL with out grant tables.
>See on line manual and don't know password.
>Or ./mysql --help
>
>Simon
>
>-----Original Message-----
>From: Cindy Yu [mailto:cyu@stripped] 
>Sent: 07 January 2002 17:48
>To: Heikki.Tuuri@stripped; prabhu@stripped 
>Cc: mysql@stripped 
>Subject: Mysql connection problem
>
>
>Hello,
>
>
>I have a question for you. I have a Solaris 5.6 server running Mysql. It is
>our company' website. I just know the server's root password and I don't
>know mysql database user name and password. Is it possible to login to Mysql
>database by using the server root and its password?  How can I do it?
>
>Your answer will be appreciated!
>
>Cindy
>
>
>
>---------------------------------------------------------------------
>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 <mysql-thread95603@stripped>
>To unsubscribe, e-mail
><mysql-unsubscribe-sgreen=eurobell.net@stripped>
>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 <mysql-thread95722@stripped>
>To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


Thread
Re: RE: RE: Mysql connection problemCindy Yu8 Jan
  • Re: Mysql connection problemGerald Clark8 Jan
RE: RE: RE: Mysql connection problemGary.Every8 Jan