List:General Discussion« Previous MessageNext Message »
From:Rajeev Prasad Date:September 24 2012 9:17pm
Subject:(resolved) Re: user not able to login from localhost
View as plain text  
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.neuli@stripped>
To: Rick James <rjames@stripped>; mysql list <mysql@stripped> 
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 <rjames@stripped>
To: Rajeev Prasad <rp.neuli@stripped>; mysql list <mysql@stripped> 
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.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
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