I've installed MySQL and started the server with:
mysqld_safe &
I've confirmed the server is running with:
ps -ef | grep mysql
and
mysqladmin status
-----------
I'm trying to connect using:
shell> mysql -u root -p
It says 'command not found' - I find the mysql command location and confirm it is executable - from that location I retry - same thing.
Your PATH variable might not include ".", the current directory. Try this instead while you're in the directory where the mysql program is located:
./mysql -u root -p
If that works, then the mysql program is installed correctly, and you should just set your PATH to include the directory where mysql is located: http://www.kitebird.com/mysql-cookbook/path.pdf
If that doesn't work, you probably have the mysqladmin program, but not the other clients. See below.
----------
This may sound silly, but how can I confirm that I've installed the client?
I ask because I installed from a binary tarball. It was odd how it was one file (referred to as Standard) vs. two files one being the Client and the other Server.
If you installed on Linux using RPM files, you need to install both the server RPM and the client RPM.
-- 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/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]