[mythtv-users] Upgraded the Ubuntu 11.10 and not Myth, can't connect to MySQL
acstadt at stadt.ca
Wed Nov 9 19:39:02 UTC 2011
On 09/11/2011 11:35 AM, Thomas Mashos wrote:
> On Tue, Nov 8, 2011 at 3:47 PM, James Linder <jam at tigger.ws
> <mailto:jam at tigger.ws>> wrote:
> On 09/11/2011, at 2:22 AM, mythtv-users-request at mythtv.org
> <mailto:mythtv-users-request at mythtv.org> wrote:
> [snip long and involved, but going nowhere]
> > Bill seems to think that the 'mysql' command is ok. Maybe that's a
> > peculiarity of a MythBuntu setup?
> > I don't think I can bring myself to wipe the OS and install
> afresh at
> > the moment. If this carries on much longer, the family is
> probably going
> > to campaign for a windows media centre replacement or some
> hardware box
> > or other. If I can't get this fixed I've not got much of an
> > Thanks for everyone's help so far.
> for me installing a complete mythbuntu system is an hours work, I
> struggle to emphasize :-)
> from localhost can you
> mysql -uroot -ppassword
> if not that is bad
> from another host can you
> mysql -hanother-host -umythtv -pmythtv mythconverg
> ubuntu makes a stupid deal of setting the password to
> somEutter2345#$%^Rubbish you must use that. At install time it
> tells you
> if not THAT is bad.
> Qt must have mysql drivers. I'd expect that this is something you
> do not need to worry about, but it is worth considering
> Error messages will be precis of "Can't Connect to database" "Strange"
> What do you see?
> mythtv-users mailing list
> mythtv-users at mythtv.org <mailto:mythtv-users at mythtv.org>
> To add, you can reset the passwords using the following instructions.
> "If you are having problems connecting to your mysql database, perform
> the following to reconfigure it:  sudo dpkg-reconfigure
> mysql-server-5.1 (pay attention to the root password you set, you will
> need it later)  sudo dpkg-reconfigure mythtv-database  sudo
> dpkg-reconfigure mythtv-common"
I can't remember - does Ubuntu do something simliar to debian: set a
scrambled password for the myth user?
More information about the mythtv-users