It's not enough to just specify the user name in the grant statement. You need to specify the host or '%' for any host (section 4.3.1 GRANT and REVOKE Syntax in the manual).
Try... mysql> grant all on marksstuff.* to 'mark'@'localhost' identified by 'password'; mysql> flush privileges; Then to login as that user... > mysql --user=mark --password=password marksstuff If you still get an error logging in, login as root using the '-E' option so the output from queries is printed vertically (more readable) then do a select * from table user where user = mark. This will help us find the answer. ----- Original Message ----- From: "Mark Healey" <[EMAIL PROTECTED]> To: "Jeff Weeks" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, August 13, 2003 11:23 PM Subject: Re: Cant login as a user I thought I created > On Wed, 13 Aug 2003 15:50:02 -0700, Jeff Weeks wrote: > > >How did you create user mark? > > I figured the grant statement would take care of that. That's what > the books I bought imply anyway. > > >BTW, after issuing a grant you must issue "flush privileges". > > Did that, the problem still persists. > > > >Check out mark in the user table in the mysql database. There's your > >problem! > > What am I supposed to look for in the user table? There is a user > "mark" with a password but all the permissions are N. > > > >On Wednesday, August 13, 2003, at 12:24 PM, Mark Healey wrote: > > > >> 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] > >> > > > 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] > > --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.507 / Virus Database: 304 - Release Date: 05/08/2003 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]