Today I asked someone to make some changes to the /etc/my.cnf file as this setting needed changing for a release.
However they made a small mistake by putting this is the [client] section. This then caused the error in the subject above.
To set this it needs to be under the [mysqld] section of the file, once you do this you can then type mysql from the command prompt.
I am always interested in feedback so please feel free to add any comments, or you can mail me here. If you would like to submit a quick tip with full credit and links back to your site then also feel free to contact me.