[mythtv-users] MySQL remote access not possible
ramonhofer at bluewin.ch
Sat May 28 08:30:43 UTC 2011
On 05/28/2011 02:01 AM, Nick Morrott wrote:
> On 27 May 2011 22:59, Ramon Hofer<ramonhofer at bluewin.ch> wrote:
>> Hi all
>> I'm trying to install MythTV Backend on Debian Squeeze.
>> After installing the base system with SSH access I install mysql-server.
>> There's no problem. I can reboot and there's no error message.
>> But when I simply change the bind-address to the system's IP address and
>> then reboot I get an error message when mysqld should be started.
> > From your syslog, it looks like networking is starting /after/ mysqld.
> This is causing mysqld to fail to bind to the as-yet-unconfigured IP
> address. When you restart mysqld, networking is up and mysqld can bind
> successfully as the configured IP address has now been acquired.
This explains a lot!
What can I do against that problem?
> The second issue (logging in to the database from the command line)
> seems to be due to incomplete mysql access permissions - not user
> permissions to the files on disk, but rather the user access control
> to the database. Read through:
> and update your DB as necessary for your local network,
Thanks for the link!
More information about the mythtv-users