From: Rajeev Prasad Date: September 24 2012 9:17pm Subject: (resolved) Re: user not able to login from localhost List-Archive: http://lists.mysql.com/mysql/228263 Message-Id: <1348521422.5556.YahooMailNeo@web161704.mail.bf1.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="-816086408-1517687287-1348521422=:5556" ---816086408-1517687287-1348521422=:5556 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable friends,=A0 i figure that i had to give password in quotes. i was then able= to login. thank you all for your help and time.=0A=0A=0A=0A_______________= _________________=0A From: Rajeev Prasad =0ATo: Rick Ja= mes ; mysql list =0ASent: Mon= day, September 24, 2012 4:11 PM=0ASubject: Re: user not able to login from = localhost=0A =0Amysql> 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 | Up= date_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_ta= bles_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 |=0A+-----------+----------+-----------------------------------= --------+-------------+-------------+-------------+-------------+----------= ---+-----------+-------------+---------------+--------------+-----------+--= ----------+-----------------+------------+------------+--------------+-----= -------+-----------------------+------------------+--------------+---------= --------+------------------+------------------+----------------+-----------= ----------+--------------------+------------------+------------+-----------= ---+----------+------------+-------------+--------------+---------------+--= -----------+-----------------+----------------------+=0A| localhost | myuse= r| *829E20779862ACF47E2B4D9B7C6B1B1B1ADF7925 | 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=0A|=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=0Am= ysql> =0A=0A=0A=0AI am looging in from the same server.=0A=0A=0A=0A=0A_____= ___________________________=0AFrom: Rick James =0ATo:= Rajeev Prasad ; mysql list =0A= Sent: Monday, September 24, 2012 2:09 PM=0ASubject: RE: user not able to lo= gin from localhost=0A=0AThat says that your password in not correct.=A0 You= have not 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 WH= ERE user =3D 'myuser';=0A=0A> -----Original Message-----=0A> From: Rajeev P= rasad [mailto:rp.neuli@stripped]=0A> Sent: Monday, September 24, 2012 10:5= 6 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 sp= ecific=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 user 'myuser'@'localhost' (using=0A> password: YES)=0A> =0A> =0A> what= other privilege do i need to give this user?=0A=0A--=0AMySQL General Maili= ng List=0AFor list archives: http://lists.mysql.com/mysql=0ATo unsubscribe:= =A0 =A0 http://lists.mysql.com/mysql ---816086408-1517687287-1348521422=:5556--