i have sent unsubscribe email to [EMAIL PROTECTED] and im still getting mail. how do i get of the list?
----- Original Message ----- From: "Mark Healey" <[EMAIL PROTECTED]> To: "Matthew McNicol" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, August 14, 2003 12:25 AM Subject: Re: Cant login as a user I thought I created > On Thu, 14 Aug 2003 00:49:52 +0100, Matthew McNicol wrote: > > > > >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. > > Here's the output. I just don't get it. > > I gotta tell you. Both books I'm using are terrible. The O'reilly > tells you to immediately do things that aren't explained until half > way through the book and the Sams gives entries that just don't work. > > mysql> select * from user where user='mark'; > *************************** 1. row *************************** > Host: % > User: mark > Password: [I deleted this] > Select_priv: N > Insert_priv: N > Update_priv: N > Delete_priv: N > Create_priv: N > Drop_priv: N > Reload_priv: N > Shutdown_priv: N > Process_priv: N > File_priv: N > Grant_priv: N > References_priv: N > Index_priv: N > Alter_priv: N > *************************** 2. row *************************** > Host: blossom > User: mark > Password: [I deleted this] > Select_priv: N > Insert_priv: N > Update_priv: N > Delete_priv: N > Create_priv: N > Drop_priv: N > Reload_priv: N > Shutdown_priv: N > Process_priv: N > File_priv: N > Grant_priv: N > References_priv: N > Index_priv: N > Alter_priv: N > *************************** 3. row *************************** > Host: localhost > User: mark > Password: [I deleted this] > Select_priv: N > Insert_priv: N > Update_priv: N > Delete_priv: N > Create_priv: N > Drop_priv: N > Reload_priv: N > Shutdown_priv: N > Process_priv: N > File_priv: N > Grant_priv: N > References_priv: N > Index_priv: N > Alter_priv: N > > > > > > > >----- 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 > > > > 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]
