[mythtv-users] Can't grant remote permissions in mysql

[Bruce Markey]

Nowhere wrote:
> Hi everyone. I need to bring this back up. I am still unable to grant
...
>>You see I have 0 rows affected and flushing privs and trying to access
>>remotely results in failed connection to the database.

If the problem was user access, the error would be:

ERROR 1045: Access denied for user: mythtv at ...

but if the message is something like 'failed connection' as
you say, that would mean that the mysql server may not be allowing
network connections. Edit your "/etc/mysql/my.cnf" file to comment
out the line:

#skip-networking

Don't use a character that isn't "#" so that it will not undo
telling it that it shouldn't not overlook skipping the option to
not do the networking and negate undoing it instead. Then restart
the mysqld server. It should then be listening in TCP port 3306.

--  bjm