The mysql user permissions are just a table in the mysql database. Whenever you do a GRANT, you're really just doing an INSERT or UPDATE against this table. You can do SELECTs, INSERTs, UPDATEs, etc. against this table (the 'user' table), just like any other table. The only way to "corrupt user accounts" is to corrupt this table in some way. There is no magic here.
james montebello On Wed, 9 Jan 2002, 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
