en log out, and log back in with the root pw.
Good luck.
-Original Message-
From: Ajay Garg [mailto:ajaygargn...@gmail.com]
Sent: May-25-15 11:24 AM
To: Mailing-List mysql
Subject: Very strange issue while trying to login remotely
Hi All.
I have two servers, 1.2.3.4 and 5.6.7.8
I wish to
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 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.
>
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 wrote:
> Hi All.
>
> I have two servers, 1.2.3.4 and 5.6.7.8
> I wish to login
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@% |
+
