Matt: Try the following: Use mysql select * from user (take a note on users that you're granting rights to) run the grant command select * from user (see if there is any differences)
OR try grant all privileges to *.* to matt@"ipaddress" (where ipaddress == 999.999.999.999 your real ip address) -----Original Message----- From: Matthew Darcy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 2:26 PM To: Ho Kam; Gerald Clark Cc: MySql List Subject: RE: command mysql -u $user without typing it ???? 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
