From: Rajeev Prasad Date: September 24 2012 9:11pm Subject: Re: user not able to login from localhost List-Archive: http://lists.mysql.com/mysql/228262 Message-Id: <1348521103.71549.YahooMailNeo@web161705.mail.bf1.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="454768137-2050243023-1348521103=:71549" --454768137-2050243023-1348521103=:71549 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable mysql> SELECT * FROM mysql.user WHERE user =3D'myuser';=0A+-----------+----= ------+-------------------------------------------+-------------+----------= ---+-------------+-------------+-------------+-----------+-------------+---= ------------+--------------+-----------+------------+-----------------+----= --------+------------+--------------+------------+-----------------------+-= -----------------+--------------+-----------------+------------------+-----= -------------+----------------+---------------------+--------------------+-= -----------------+------------+--------------+----------+------------+-----= --------+--------------+---------------+-------------+-----------------+---= -------------------+=0A| Host=A0=A0=A0=A0=A0 | User=A0=A0=A0=A0 | Password= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0 | Select_priv | Insert_priv | Update_priv | Delete= _priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_pri= v | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Sh= ow_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execut= e_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 |=0A+-= ----------+----------+-------------------------------------------+---------= ----+-------------+-------------+-------------+-------------+-----------+--= -----------+---------------+--------------+-----------+------------+-------= ----------+------------+------------+--------------+------------+----------= -------------+------------------+--------------+-----------------+---------= ---------+------------------+----------------+---------------------+-------= -------------+------------------+------------+--------------+----------+---= ---------+-------------+--------------+---------------+-------------+------= -----------+----------------------+=0A| localhost | myuser| *829E20779862AC= F47E2B4D9B7C6B1B1B1ADF7925 | N=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 | N=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0 | N=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 | N=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0 | N=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 | N=A0=A0=A0=A0=A0=A0=A0= =A0 | N=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 | N=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0 | N=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 | N=A0=A0=A0=A0=A0=A0=A0=A0 | N=A0= =A0=A0=A0=A0=A0=A0=A0=A0 | N=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 | N= =A0=A0=A0=A0=A0=A0=A0=A0=A0 | N=A0=A0=A0=A0=A0=A0=A0=A0=A0 | N=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0 | N=A0=A0=A0=A0=A0=A0=A0=A0=A0 | N=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 | N=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0 | N=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 | N=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0 | N=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0 | N=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 | N=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0 | N=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0 | N=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 | N=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 | N=A0=A0=A0=A0=A0=A0=A0=A0=A0 | N=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 |=A0=A0=A0=A0=A0=A0=A0=A0=A0 |=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0 |=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 |=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0 |=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 0 |=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 0 |=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0 0 |=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 0 |=0A+---= --------+----------+-------------------------------------------+-----------= --+-------------+-------------+-------------+-------------+-----------+----= ---------+---------------+--------------+-----------+------------+---------= --------+------------+------------+--------------+------------+------------= -----------+------------------+--------------+-----------------+-----------= -------+------------------+----------------+---------------------+---------= -----------+------------------+------------+--------------+----------+-----= -------+-------------+--------------+---------------+-------------+--------= ---------+----------------------+=0A1 row in set (0.02 sec)=0A=0Amysql> =0A= =0A=0A=0AI am looging in from the same server.=0A=0A=0A=0A=0A______________= __________________=0A From: Rick James =0ATo: Rajeev = Prasad ; mysql list =0ASent: Mo= nday, September 24, 2012 2:09 PM=0ASubject: RE: user not able to login from= localhost=0A =0AThat says that your password in not correct.=A0 You have n= ot gotten to specific privileges.=0A=0ADid you previously do=0AGRANT ... TO= myuser@localhost IDENTFIED BY '...';=0A?=0A=0AIf you can get in via root, = do=0ASHOW GRANTS FOR myuser@localhost;=0ASELECT * FROM mysql.user WHERE use= r =3D 'myuser';=0A=0A> -----Original Message-----=0A> From: Rajeev Prasad [= mailto:rp.neuli@stripped]=0A> Sent: Monday, September 24, 2012 10:56 AM=0A= > To: mysql list=0A> Subject: user not able to login from localhost=0A> =0A= > i have given select/insert/update/delete rights to a user on a specific= =0A> database, from localhost. when i try to login to mysql using the uid, = i=0A> get error:=0A> =0A> =0A> =0A> ERROR 1045 (28000): Access denied for u= ser 'myuser'@'localhost' (using=0A> password: YES)=0A> =0A> =0A> what other= privilege do i need to give this user?=0A=0A--=0AMySQL General Mailing Lis= t=0AFor list archives: http://lists.mysql.com/mysql=0ATo unsubscribe:=A0 = =A0 http://lists.mysql.com/mysql --454768137-2050243023-1348521103=:71549--