mysql: command not found

[BfB]

I'm fairly new to freeBSD and what not. I have played around with the unix command line before. I've been trying to run the mysql command to reload a sql dump, I've tried it in the dir of the sql dump and the dir with the mysql/mysqldump commands. No matter what I try this is what I get

-bash: mysql: command not found

Help please

[filburt1]

It means mysql is not in the path. Try:

locate mysql

I think it's in /usr/local/mysql/bin .

[BfB]

if I run that command it finds alooooot of matches, so i try locate "mysqldump" to get a shorter list ( /usr/local/psa/mysql/bin ) and i make that the working directory, and run the "mysql -u username -p dbnam < /usr/local/........./*.sql

and it still comes back with "mysql: command not found"

[filburt1]

Try ./mysql when you're in the directory.

[BfB]

ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

[filburt1]

At this point, it's a MySQL issue rather than a shell issue. Make sure that you are connecting to MySQL as a valid user. When in doubt, see what your config.php is using.

[BfB]

I have a valid mysql user setup, but I cannot log into the shell with that login. Right now I am testing moving boards so the config.php is not edited yet.

[filburt1]

Are you using ./mysql -uusername -p dbname, then entering the proper password when asked?

[BfB]

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 998 to server version: 3.23.56

btw .... thank you for your help!

[BfB]

just for the hell of it I did the ./ before the command to run the dump, it worked great .....

whats the "./" for just so I know for future reference