List:General Discussion« Previous MessageNext Message »
From:Rajeev Prasad Date:September 24 2012 9:08pm
Subject:Re: user not able to login from localhost
View as plain text  
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.mildren@stripped>
To: Rajeev Prasad <rp.neuli@stripped> 
Cc: mysql list <mysql@stripped> 
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 <rjames@stripped> 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.neuli@stripped]
>> 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
Thread
user not able to login from localhostRajeev Prasad24 Sep
  • RE: user not able to login from localhostRick James24 Sep
    • Re: user not able to login from localhostBen Mildren24 Sep
      • Re: user not able to login from localhostRajeev Prasad24 Sep
    • Re: user not able to login from localhostRajeev Prasad24 Sep
      • (resolved) Re: user not able to login from localhostRajeev Prasad24 Sep
  • Re: user not able to login from localhostMichael Dykman24 Sep