Web lists-archives.com

Re: Very strange issue while trying to login remotely




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 <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
>



-- 
 - michael dykman
 - mdykman@xxxxxxxxx

 May the Source be with you.