it will not prompt for a password with the '-p' try this: mysql --host 5.6.7.8 -uroot db_name -p
I assume you do have a password set? On Mon, May 25, 2015 at 11:24 AM, Ajay Garg <ajaygargn...@gmail.com> wrote: > Hi All. > > I have two servers, 1.2.3.4 and 5.6.7.8 > I wish to login remotely FROM 1.2.3.4 onto 5.6.7.8. > > > a) > On 5.6.7.8, > > mysql> show grants for 'root'@'%'; > +-------------------------------------------------------------+ > | Grants for root@% | > +-------------------------------------------------------------+ > | GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION | > +-------------------------------------------------------------+ > 1 row in set (0.00 sec) > > > > > b) > From 1.2.3.4, I do > > mysql --host=5.6.7.8 -uroot db_name > ERROR 1045 (28000): Access denied for user 'root'@'1.2.3.4' (using > password: NO) > > > I am at complete loss, I have done all that I could find from google. > I will be really, really grateful for ideas that could help me recover from > this mess, that is aching me since last 3 hours :( > > > Thanks and Regards, > Ajay > > > -- > Regards, > Ajay > -- - michael dykman - mdyk...@gmail.com May the Source be with you.
