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.