Web lists-archives.com

Re: Very strange issue while trying to login remotely




Sorry,

The user had multiple passwords set up in mysql.user table.
Clearing the "other" passwords solved the issue.

Sorry for the inconvenience.


Thanks and Regards,
Ajay

On Mon, May 25, 2015 at 8:54 PM, Ajay Garg <ajaygargnsit@xxxxxxxxx> 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
>



-- 
Regards,
Ajay