I JUST had a problem very similar to this. However, it could be a number of different reasons, but here's what my problem was. I had two users in my users table that could connect via any name, any host, with any password but had no priveleges. You can probably test this by connecting to mysql without using a password - i.e.
mysql -umark Don't ask me how those two accounts got there - probably a stray query somewhere. Anyhow, I deleted those two users, and everything worked perfectly from there. - Jonathan ----- Original Message ----- From: "Mark Healey" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 13, 2003 12:24 PM Subject: Cant login as a user I thought I created > I'm trying to learn to use mysql. I don't want to mess with the > system databases so I decided create a database and user to play > with but I can't seem to do it right. > > I logged in as root and created a database > > mysql> create database marksstuff; > Query OK, 1 row affected (0.00 sec) > > I then granted priveleges to mark > > mysql> grant all on marksstuff.* to mark identified by 'password'; not the real password > Query OK, 0 rows affected (0.01 sec) > > I then logged out and tried to login as mark > > [EMAIL PROTECTED] mark]$ mysql -u mark -ppassword > ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) > > What am I doing wrong? > > > > Mark Healey > [EMAIL PROTECTED] > > This account is only for lists to which I've subscribed. > Any spammers invite the worst revenge I think I can get away with. > > > -- > 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]
