List:General Discussion« Previous MessageNext Message »
From:Michael Satterwhite Date:July 5 2010 4:10pm
Subject:Re: Why is Host option Failing?
View as plain text  
On Monday, July 05, 2010 10:46:48 am Bob Cole wrote:

> 
> The remote computer let me into mysql and I typed:
> mysql> use mysql
> mysql> select host, user, Password, Select_priv from user;
> +------------------+----------+-------------------------------------------+
> -------------+
> 
> | host             | user     | Password                                  |
> | Select_priv |
> 
> +------------------+----------+-------------------------------------------+
> -------------+
> 
> | localhost        | myUserNm | *ABC8C800D9A264876A32F5175DE21C1A0B89XYZ  |
> | Y           | %                | myUserNm |
> | *ABC8C800D9A264876A32F5175DE21C1A0B89XYZ  | Y           |
> 
> +------------------+----------+-------------------------------------------+
> -------------+
> 
> Your results should be similar.
> HTH,
> Bob

Bob, I thought you'd identified the problem, but I don't think it is. Here's my 
output
+-----------+------------------+-------------------------------------------+
| host      | user             | password                                  |
+-----------+------------------+-------------------------------------------+
| localhost | root             | *135A6626293E0699534358EE0AB1230BF69067A5 |
| PHOTON    | root             | *135A6626293E0699534358EE0AB1230BF69067A5 |
| 127.0.0.1 | root             | *135A6626293E0699534358EE0AB1230BF69067A5 |
| localhost | debian-sys-maint | *2BA4FF2E2728588CB18B3A06924A8C37B5467F11 |
| localhost | michael          | *101CC8AAEAEBFDC7571307AD2B51F34D95B80572 |
| localhost | webcalendar      | *135A6626293E0699534358EE0AB1230BF69067A5 |
| photon    | michael          | *101CC8AAEAEBFDC7571307AD2B51F34D95B80572 |
| %         | michael          | *101CC8AAEAEBFDC7571307AD2B51F34D95B80572 |
+-----------+------------------+-------------------------------------------+

I'm sure you know more than I do, but it looks good to me.
Thread
Why is Host option Failing?Michael Satterwhite5 Jul
  • Re: Why is Host option Failing?Michael Dykman5 Jul
Re: Why is Host option Failing?Michael Satterwhite5 Jul
Re: Why is Host option Failing?Michael Satterwhite5 Jul
  • Re: Why is Host option Failing?Bob Cole5 Jul
    • Re: Why is Host option Failing?Michael Satterwhite5 Jul
  • Re: Why is Host option Failing?burhan.khalid5 Jul