mysql>
I am looging in from the same server.
From: Rick James
To: Rajeev Prasad ; mysql list
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 go
sql>
I am looging in from the same server.
From: Rick James
To: Rajeev Prasad ; mysql list
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 go
ase`.* TO
'myuser'@'localhost' |
+-+
I am using phpmyadmin to manage mysql, including user privileges.
From: Ben Mildren
To: Rajeev Prasad
Cc: mysql list
Sent: Monday, Sep
Also ensure you issue: FLUSH PRIVILEGES; after making any changes to
permissions..
On 24 September 2012 20:09, Rick James 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 '.
On Mon, Sep 24, 2012 at 1:55 PM, Rajeev Prasad 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
>
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 Me
