Can you login using the mysql command line client from your Mac? mysql -u username -p
That will make sure the password is set and working.
What do you mean by failed? You get a message about incorrect password?
I've never had a problem with installing and using mysql on a Mac.
On Apr 15, 2005, at 11:45 AM, Brett Harvey wrote:
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);
----------------------------------------------------------------------- ---------
-- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
