[Gslug-general] Stuck on what should be easy

[Frank Paterra]

Sorry, I don't thin it did (or I missed it)

mysql>  show grants for root;
+-------------------------------------------------------------------------------------------------------+
| Grants for root@%
                                 |
+-------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY PASSWORD
'78901ed626334092' WITH GRANT OPTION |
| GRANT ALL PRIVILEGES ON `db`.* TO 'root'@'%'
                                 |
| GRANT ALL PRIVILEGES ON `mysql`.* TO 'root'@'%'
                                 |
+-------------------------------------------------------------------------------------------------------+
3 rows in set (0.00 sec)

and

mysql> select user,host,password from mysql.user where user = 'root';
+------+---------------+------------------+
| user | host          | password         |
+------+---------------+------------------+
| root | localhost     | 78901ed626334092 |
| root | 192.168.1.%   | 78901ed626334092 |
| root | 127.0.0.1     |                  |
| root | %             | 78901ed626334092 |
| root | 192.168.1.100 |                  |
| root | %.%.%.%       | 78901ed626334092 |
+------+---------------+------------------+
6 rows in set (0.09 sec)

Does this tell you anything interesting?  It just seems to confirm
that I should have access right?

Frank

On Tue, Feb 10, 2009 at 10:28 AM, Josh Miller <joshua at itsecureadmin.com> wrote:
> Frank Paterra wrote:
>>
>> Yep, agree.  I know that the firewall is open and I am able to "talk"
>> to the machine/port but for some reason mysql is not allowing me in.
>> I'm also pretty sure that mysql is listening on the right port now.
>
> I sent this already, don't think it went through:
>
> What is the output of:
>
>  show grants for root;
>
> ...and...
>
>  select user,host,password from mysql.user where user = 'root';
>
> --
> Josh Miller, RHCE/VCP
> Seattle, WA
>



-- 
Frank Paterra
fcp at wittykids.com