I was doing a flush privileges. but this was coming up with the same thing no rows affected which to me was concerning.
I have now got 1 user working but 1 user not. I am going to delete all users and start again with the users, as at the start I was not doing flush privileges and I was also trying put hostnames without DNS into the hosts field. I may have corrupted the user accounts in some way. I'll keep you posted. Thanks for the help and the good explainations though. I am sure it will be a user error on my part if 1 user is working and another 1 not. Cheers. Matt. -----Original Message----- From: James Montebello [mailto:[EMAIL PROTECTED]] Sent: 09 January 2002 19:43 To: Matthew Darcy Cc: Ho Kam; Gerald Clark; MySql List Subject: RE: command mysql -u $user without typing it ???? You must do a "FLUSH PRIVILEGES" after making any changes to the user permissions before they will actually take effect. This is documented. james montebello On Wed, 9 Jan 2002, Matthew Darcy wrote: > query ok I would expect to see, but "no rows affected" ??? this must mean it > has not altered the database at all ?? > > I created a 2 new users, dba and matt > > I did grant all privileges to *.* to dba@"%" > > I cannot conntect from anything host as dba. > > I then did > > grant all privileges to *.* to matt@"jaguar.no-dns.co.uk" (my laptop) > > I got the no rows affected message and I cannot connect from the machine > jaguar. > > something must be wrong. I used stand the pricinpals of the grant command > but I cannot understand why no rows are affected. It does not surprise me > that I cannot connect when no rows are affected. > > any other suggestions. > > Thanks for going into detail on this I am learning. > > Matt. > > > -----Original Message----- > From: Ho, Kam [mailto:[EMAIL PROTECTED]] > Sent: 09 January 2002 16:57 > To: '[EMAIL PROTECTED]'; Ho, Kam; Gerald Clark > Cc: MySql List > Subject: RE: command mysql -u $user without typing it ???? > > > The "Query OK, 0 rows affected" indicate that the user table is updated so > test2 on localhost can access the mysql databases. > > Do you still get the "access is denyed for user @localhostto database mysql" > message? > > > -----Original Message----- > From: Matthew Darcy [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 09, 2002 11:51 AM > To: Ho Kam; Gerald Clark > Cc: MySql List > Subject: RE: command mysql -u $user without typing it ???? > > > tired that but I am getting > > Query OK, 0 rows affected (0.00 sec) > > > don't understand why it is not granting to the user ? > > Matt. > > > -----Original Message----- > From: Ho, Kam [mailto:[EMAIL PROTECTED]] > Sent: 09 January 2002 16:10 > To: '[EMAIL PROTECTED]'; Gerald Clark > Cc: MySql List > Subject: RE: command mysql -u $user without typing it ???? > > > Try this: > > mysql> grant all privileges on *.* to test2@"localhost" > > also read manual about the grant command. > > -----Original Message----- > From: Matthew Darcy [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 09, 2002 11:04 AM > To: Gerald Clark > Cc: MySql List > Subject: RE: command mysql -u $user without typing it ???? > > > I read similar notes on this in the manual, saying that invoking mysql > without the username will try to take the unix username if it exists in the > database. > > I tried this with test2, it opened an mysql session no problem, but when I > did a connect mysql it said "access is denyed for user @localhostto database > mysql" > > to me this looks like it is trying to connect with no user instead of > test2@localhost > > can you explain this ? > > Thanks, > > Matt. > > > -----Original Message----- > From: Gerald Clark [mailto:[EMAIL PROTECTED]] > Sent: 09 January 2002 15:56 > To: [EMAIL PROTECTED] > Cc: MySql List > Subject: Re: command mysql -u $user without typing it ???? > > > > > Matthew Darcy wrote: > > > > >I have 3 UNIX users on my server. > > > >test1, test2, and test3. > > > >I have created 3 users for mysql test1, test2, and test3 (shock horror) > > > >If I want to connect to the database as root then I understand I must do > >mysql -u root -p > > > >but I would like test1 2 and 3 to be able to type mysql and be either > logged > >in as their unix username, ie test2 types mysql and connects to the > database > >as test2 (mysql account) > >or at least be prompted for the password for test2. > > > >The only way I can think of doing this is by setting up an alias ie > > > >alias mysql_connect=`mysql -u $username -p` > > > >there must be some sort of autologin from username like in oracle. > > > >Thanks, > > > >Matt. > > > The user defaults to the unix user. > You can put a .my.cnf file in their home directory with > > [client] > password=whatever > > to make it even easier. > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
