1. I've installed MySQL 4.0.24 on Panther 10.3.8.
It appears to be setup correctly. I've installed phpmyadmin,
it also appears to be setup correctly.. except.. when I log in to
phpymyadmin, and try to log in with my admin user, it
does not take the password, rather, it accepts a blank password,
then lets me in.
The same thing happens at the command line. I can log in
to the mysql monitor in the Terminal.. when I try to log in with my
current admin user (djbeta), it prompts me for a password, and
will let me in ONLY if I enter no password. But, there is definitely a password
on this user.. somehow I deleted it for MySQL ?? I don't know how if so,
but can I put it back ?
2. The only way I can call mysqld is by first changing to the /usr/local/mysql directory, and even then, if I type mysql -u djbeta -p -h localhost, it says mysql command not found, it will work if I type bin/mysql -u djbeta -p -h localhost, then it will work.
Is there a way I can set it up so that my MySQL is password protected and also that I don't have to cd to the directory and type bin/mysql when I should only have to type mysql ?
