user not able to login from localhost

2012-09-24 Thread Rajeev Prasad 
i have given select/insert/update/delete rights to a user on a specific 
database, from localhost. when i try to login to mysql using the uid, i get 
error:



ERROR 1045 (28000): Access denied for user 'myuser'@'localhost' (using 
password: YES)


what other privilege do i need to give this user?

RE: user not able to login from localhost

2012-09-24 Thread Rick James 
That says that your password in not correct.  You have not gotten to specific 
privileges.

Did you previously do
GRANT ... TO myuser@localhost IDENTFIED BY '...';
?

If you can get in via root, do
SHOW GRANTS FOR myuser@localhost;
SELECT * FROM mysql.user WHERE user = 'myuser';

 -Original Message-
 From: Rajeev Prasad [mailto:rp.ne...@yahoo.com]
 Sent: Monday, September 24, 2012 10:56 AM
 To: mysql list
 Subject: user not able to login from localhost
 
 i have given select/insert/update/delete rights to a user on a specific
 database, from localhost. when i try to login to mysql using the uid, i
 get error:
 
 
 
 ERROR 1045 (28000): Access denied for user 'myuser'@'localhost' (using
 password: YES)
 
 
 what other privilege do i need to give this user?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: user not able to login from localhost

2012-09-24 Thread Michael Dykman 
On Mon, Sep 24, 2012 at 1:55 PM, Rajeev Prasad rp.ne...@yahoo.com wrote:
 i have given select/insert/update/delete rights to a user on a specific 
 database, from localhost. when i try to login to mysql using the uid, i get 
 error:



 ERROR 1045 (28000): Access denied for user 'myuser'@'localhost' (using 
 password: YES)


 what other privilege do i need to give this user?

The permission set you describe should be complete, so look more
closely at what was actually granted and how you are trying to log in.

The obvious questions:

How did you create and grant privileges to that user? Did you use:

grant select,insert,update,delete on mydb.* to mysql@localhost
identified by password('password');

or what variant exactly?

When you are trying to log in, are you doing that explicitly from the
same server or are you accessing remotely?

-- 
 - michael dykman
 - mdyk...@gmail.com

 May the Source be with you.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: user not able to login from localhost

2012-09-24 Thread Ben Mildren 
Also ensure you issue: FLUSH PRIVILEGES; after making any changes to
permissions..

On 24 September 2012 20:09, Rick James rja...@yahoo-inc.com wrote:
 That says that your password in not correct.  You have not gotten to specific 
 privileges.

 Did you previously do
 GRANT ... TO myuser@localhost IDENTFIED BY '...';
 ?

 If you can get in via root, do
 SHOW GRANTS FOR myuser@localhost;
 SELECT * FROM mysql.user WHERE user = 'myuser';

 -Original Message-
 From: Rajeev Prasad [mailto:rp.ne...@yahoo.com]
 Sent: Monday, September 24, 2012 10:56 AM
 To: mysql list
 Subject: user not able to login from localhost

 i have given select/insert/update/delete rights to a user on a specific
 database, from localhost. when i try to login to mysql using the uid, i
 get error:



 ERROR 1045 (28000): Access denied for user 'myuser'@'localhost' (using
 password: YES)


 what other privilege do i need to give this user?

 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:http://lists.mysql.com/mysql


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: user not able to login from localhost

2012-09-24 Thread Rajeev Prasad 
this is what i see:

| GRANT USAGE ON *.* TO 'myuser'@'localhost' IDENTIFIED BY PASSWORD 
'*829E20779862ACF47E2B4D9B7C6B1B1B1ADF7925' |
| GRANT SELECT, INSERT, UPDATE, DELETE, LOCK TABLES ON `mydatabase`.* TO 
'myuser'@'localhost' |
+-+


I am using phpmyadmin to manage mysql, including user privileges.




 From: Ben Mildren ben.mild...@gmail.com
To: Rajeev Prasad rp.ne...@yahoo.com 
Cc: mysql list mysql@lists.mysql.com 
Sent: Monday, September 24, 2012 2:49 PM
Subject: Re: user not able to login from localhost
 
Also ensure you issue: FLUSH PRIVILEGES; after making any changes to
permissions..

On 24 September 2012 20:09, Rick James rja...@yahoo-inc.com wrote:
 That says that your password in not correct.  You have not gotten to specific 
 privileges.

 Did you previously do
 GRANT ... TO myuser@localhost IDENTFIED BY '...';
 ?

 If you can get in via root, do
 SHOW GRANTS FOR myuser@localhost;
 SELECT * FROM mysql.user WHERE user = 'myuser';

 -Original Message-
 From: Rajeev Prasad [mailto:rp.ne...@yahoo.com]
 Sent: Monday, September 24, 2012 10:56 AM
 To: mysql list
 Subject: user not able to login from localhost

 i have given select/insert/update/delete rights to a user on a specific
 database, from localhost. when i try to login to mysql using the uid, i
 get error:



 ERROR 1045 (28000): Access denied for user 'myuser'@'localhost' (using
 password: YES)


 what other privilege do i need to give this user?

 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:    http://lists.mysql.com/mysql


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql

Re: user not able to login from localhost

2012-09-24 Thread Rajeev Prasad 
mysql SELECT * FROM mysql.user WHERE user ='myuser';
+---+--+---+-+-+-+-+-+---+-+---+--+---++-+++--++---+--+--+-+--+--++-++--++--+--++-+--+---+-+-+--+
| Host  | User | Password  | 
Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv 
| Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | 
References_priv | Index_priv | Alter_priv | Show_db_priv | Super_priv | 
Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | 
Repl_client_priv | Create_view_priv | Show_view_priv | Create_routine_priv | 
Alter_routine_priv | Create_user_priv | Event_priv | Trigger_priv | ssl_type | 
ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates | 
max_connections | max_user_connections |
+---+--+---+-+-+-+-+-+---+-+---+--+---++-+++--++---+--+--+-+--+--++-++--++--+--++-+--+---+-+-+--+
| localhost | myuser| *829E20779862ACF47E2B4D9B7C6B1B1B1ADF7925 | N   | 
N   | N   | N   | N   | N | N   
| N | N    | N | N  | N   | 
N  | N  | N    | N  | N | 
N    | N    | N   | N    | 
N    | N  | N   | N  | 
N    | N  | N    |  |    
| |  | 0
 |   0 |   0 |    0 |
+---+--+---+-+-+-+-+-+---+-+---+--+---++-+++--++---+--+--+-+--+--++-++--++--+--++-+--+---+-+-+--+
1 row in set (0.02 sec)

mysql 



I am looging in from the same server.





 From: Rick James rja...@yahoo-inc.com
To: Rajeev Prasad rp.ne...@yahoo.com; mysql list mysql@lists.mysql.com 
Sent: Monday, September 24, 2012 2:09 PM
Subject: RE: user not able to login from localhost
 
That says that your password in not correct.  You have not gotten to specific 
privileges.

Did you previously do
GRANT ... TO myuser@localhost IDENTFIED BY '...';
?

If you can get in via root, do
SHOW GRANTS FOR myuser@localhost;
SELECT * FROM mysql.user WHERE user = 'myuser';

 -Original Message-
 From: Rajeev Prasad [mailto:rp.ne...@yahoo.com]
 Sent: Monday, September 24, 2012 10:56 AM
 To: mysql list
 Subject: user not able to login from localhost
 
 i have given select/insert/update/delete rights to a user on a specific
 database, from localhost. when i try to login to mysql using the uid, i
 get error:
 
 
 
 ERROR 1045 (28000): Access denied for user 'myuser'@'localhost' (using
 password: YES)
 
 
 what other privilege do i need to give this user?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql

(resolved) Re: user not able to login from localhost

2012-09-24 Thread Rajeev Prasad 
friends,  i figure that i had to give password in quotes. i was then able to 
login. thank you all for your help and time.




 From: Rajeev Prasad rp.ne...@yahoo.com
To: Rick James rja...@yahoo-inc.com; mysql list mysql@lists.mysql.com 
Sent: Monday, September 24, 2012 4:11 PM
Subject: Re: user not able to login from localhost
 
mysql SELECT * FROM mysql.user WHERE user ='myuser';
+---+--+---+-+-+-+-+-+---+-+---+--+---++-+++--++---+--+--+-+--+--++-++--++--+--++-+--+---+-+-+--+
| Host  | User | Password  | 
Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv 
| Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | 
References_priv | Index_priv | Alter_priv | Show_db_priv | Super_priv | 
Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | 
Repl_client_priv | Create_view_priv | Show_view_priv | Create_routine_priv | 
Alter_routine_priv | Create_user_priv | Event_priv | Trigger_priv | ssl_type | 
ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates | 
max_connections | max_user_connections |
+---+--+---+-+-+-+-+-+---+-+---+--+---++-+++--++---+--+--+-+--+--++-++--++--+--++-+--+---+-+-+--+
| localhost | myuser| *829E20779862ACF47E2B4D9B7C6B1B1B1ADF7925 | N   | 
N   | N   | N   | N   | N | N   
| N | N    | N | N  | N   | 
N  | N  | N    | N  | N | 
N    | N    | N   | N    | 
N    | N  | N   | N  | 
N    | N  | N    |  |    
| |  | 0
|   0 |   0 |    0 |
+---+--+---+-+-+-+-+-+---+-+---+--+---++-+++--++---+--+--+-+--+--++-++--++--+--++-+--+---+-+-+--+
1 row in set (0.02 sec)

mysql 



I am looging in from the same server.





From: Rick James rja...@yahoo-inc.com
To: Rajeev Prasad rp.ne...@yahoo.com; mysql list mysql@lists.mysql.com 
Sent: Monday, September 24, 2012 2:09 PM
Subject: RE: user not able to login from localhost

That says that your password in not correct.  You have not gotten to specific 
privileges.

Did you previously do
GRANT ... TO myuser@localhost IDENTFIED BY '...';
?

If you can get in via root, do
SHOW GRANTS FOR myuser@localhost;
SELECT * FROM mysql.user WHERE user = 'myuser';

 -Original Message-
 From: Rajeev Prasad [mailto:rp.ne...@yahoo.com]
 Sent: Monday, September 24, 2012 10:56 AM
 To: mysql list
 Subject: user not able to login from localhost
 
 i have given select/insert/update/delete rights to a user on a specific
 database, from localhost. when i try to login to mysql using the uid, i
 get error:
 
 
 
 ERROR 1045 (28000): Access denied for user 'myuser'@'localhost' (using
 password: YES)
 
 
 what other privilege do i need to give this user?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql