[ubuntu-mythtv] [Bug 133458] Re: cannot access mysql database

Mario Limonciello superm1 at ubuntu.com
Sun Aug 19 18:14:24 BST 2007


Snah Nosrovlah wrote:
> update: the success of 'dpkg-reconfigure mythtv-database' seems to
> depend on what name one uses for the backend server.
> 
> 1. it fails if I use the local network IP address '192.168.1.3'
> 2. it fails if I use the local network hostname 'dell.local'
> 3. it succeeds if I use 'localhost'
> 
This new behavior for mysql server to ask for a root password is both an
annoyance and a blessing.  It will help to improve the security of a box
immensely, while at the same time the gutsy packaging should be updated
to reflect the behavior.

The reason it doesn't work by IP address or name is because MySQL
doesn't bind to all addresses by default.  It only binds to localhost.

The most logical way to work around this problem would be to use the
debian-sys-maintainer account, but unfortunately it doesn't have the
appropriate permissions necessary to get the database initialized.

-- 
cannot access mysql database
https://bugs.launchpad.net/bugs/133458
You received this bug notification because you are a member of MythTV
Ubuntu Maintainers, which is a bug contact for mythtv in ubuntu.



More information about the Ubuntu-mythtv mailing list