[mythtv-users] Upgraded the Ubuntu 11.10 and not Myth, can't connect to MySQL

[Thomas Mashos]

On Tue, Nov 8, 2011 at 3:47 PM, James Linder <jam at tigger.ws> wrote:

>
> On 09/11/2011, at 2:22 AM, 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 argument!
> >
> > Thanks for everyone's help so far.
>
> Damian
> 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?
> James
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://www.mythtv.org/mailman/listinfo/mythtv-users
>

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: [1] sudo dpkg-reconfigure mysql-server-5.1
(pay attention to the root password you set, you will need it later)  [2]
sudo dpkg-reconfigure mythtv-database [3] sudo dpkg-reconfigure
mythtv-common"

-- 
Thomas Mashos
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.mythtv.org/pipermail/mythtv-users/attachments/20111109/f975fa13/attachment.html