Hi Asad,

Do not put a space between the -p and password. You don't have to put
the password in on the command line as the mysql client will prompt you
for it.

Regards

David Logan
Database Administrator
HP Managed Services
148 Frome Street,
Adelaide 5000
Australia

+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax


-----Original Message-----
From: Asad Habib [mailto:[EMAIL PROTECTED] 
Sent: Friday, 18 March 2005 6:18 PM
To: mysql@lists.mysql.com
Subject: Authenticating a User to MySQL

I just installed MySQL 4.1 on Mac OS X Panther Client. I am now having
trouble authenticating users(root, admin) to MySQL. I am able to start
MySQL but not using a specific user name and password.

When I type ./mysql in /usr/local/mysql/bin, I am able to access MySQL.
However, I have no privileges this way. However, when I try the
following:

./mysql -u root -p password

I get an error that states "ERROR 1045 (28000): Access denied for user
'root'@'localhost' (using password: YES)

Any help would be greatly appreciated. Thanks.

- Asad

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to