PDA

View Full Version : mysql help




Stevp1
Jul 5, 2004, 05:41 PM
1st thing, I'm a newbie as far as unix/mysql etc. I'm working on developing a CMS solution for my company. I've got mysql installed and running, and I use PHPmyadmin for access. I'm trying to get more familiar with the terminal, so I'm trying commands from there. When i try a command such as "mysqladmin -u dba_user -p create database" or basically try to call any mysql command, I get "command not found" errors. Even when I use sudo. I'm in the correct directory, and I can see the command I need in the ls results.

any suggestions?



dbauer
Jul 5, 2004, 06:40 PM
this is just a shot in the dark (and I'm sure its not a good one at that) but one thing about unix is that you must use the exact case of a command for it to work. Hope that helps.

-db

robbieduncan
Jul 5, 2004, 06:46 PM
Most sane Unix users do not have the current directory in their PATH. Try ./ in front of the command. If that works add the directory (fully qualified) to your PATH variable (.profile or equivalent file).

jeremy.king
Jul 5, 2004, 06:50 PM
Most sane Unix users do not have the current directory in their PATH. Try ./ in front of the command. If that works add the directory (fully qualified) to your PATH variable (.profile or equivalent file).

I assume you didn't do these steps?

http://dev.mysql.com/doc/mysql/en/Mac_OS_X_installation.html

Pay close attention to the end of that page, where they talk about setting up your PATH or aliasing the commands.

Stevp1
Jul 5, 2004, 11:12 PM
I assume you didn't do these steps?

http://dev.mysql.com/doc/mysql/en/Mac_OS_X_installation.html

Pay close attention to the end of that page, where they talk about setting up your PATH or aliasing the commands.

You assumed correctly. Thanks for getting me to open my eyes. :o