Hello,
I went through the install for mysql 4.1.11 on the mac. Two different macs.
When I leave the password empty (don't make changes), I can connect with CocoaMysql and the Mysql Administrator without any problem.
Obviously, I don't want to leave the root (or any user) without a password. So, I follow the instructions. from shell>
mysql -u root
mysql> SET PASSWORD FOR ''@'localhost' = PASSWORD('newpwd');
mysql> SET PASSWORD FOR ''@'host_name' = PASSWORD('newpwd');
doing a select hostname, user from mysql.user; shows me the password is now set.
I do "flush privileges" as it says.
Now, I try logging in with CocoaMysql or the Mysql Administrator and it fails! every time.
I've had no problem doing this on my PC. On the mac I seem to be stuck. I've repeated the process several times.
I tried upgrading the grant tables. Still, no go.
Suggestions? Ideas? I really don't want to leave these open, as I'm sure every agrees would be wrong.
Thanks!
Brett
--
--------------------------------------------------------------------------------
/Brett C. Harvey;
/Creative-Pages.Net, President;
/Facility Management Systems, CTO (www.fmsystems.biz);
/Lasso Partner Association Member ID #LPA135259 (www.omnipilot.com/www.lassopartner.com);
--------------------------------------------------------------------------------
