Doug, I am running redhat linux 7.1.
I have tried these commands, and re-read your mails for earlier, and I understand what these commands should be doing, and how the tables work for secuirty. I have done all that I should have done and I am still stuck. I have have made sure the linux box does not have any login - or network restrictions on and all ports are open, no deny/allow rules etc. all fine. I truley am stumpped. -----Original Message----- From: Doug Thompson [mailto:[EMAIL PROTECTED]] Sent: 10 January 2002 04:39 To: James Montebello; [EMAIL PROTECTED] Cc: Gerald Clark; Ho Kam; MySql List Subject: RE: command mysql -u $user without typing it ???? Matt: I don't remember you saying what machine you're running mysql on. Try adding another copy of the same user only @localhost. My win32 installation requires that for a dos box. The hosting service I use doesn't seem to care as it almost seems to ignore the Host column. GRANT ALL PRIVILEGES ON *.* TO foo@localhost IDENTIFIED BY 'password' WITH GRANT OPTION; GRANT ALL PRIVILEGES ON *.* TO foo@"%" IDENTIFIED BY 'password' WITH GRANT OPTION; Good luck. Doug On Wed, 9 Jan 2002 20:38:46 -0000, Matthew Darcy wrote: >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 > --------------------------------------------------------------------- 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