[mythtv-users] noob database question

R. G. Newbury newbury at mandamus.org
Tue Apr 29 14:55:32 UTC 2008


Misty P wrote:
> ----- Original Message ----- 
> From: "Nicolas Frazier" <nickfrazier1 at gmail.com>
> To: <mythtv-users at mythtv.org>
> Sent: Monday, April 28, 2008 11:20 PM
> Subject: [mythtv-users] noob database question
> 
> 
>> As a noob to Mythtv installation, how do you complete the database
>> installation of myth in the latest ubuntu environment.  mythfilldatabase
>> cannot login.
> 
> I ran into this problem when I rebuilt my FE/BE last month on ubuntu 8 (at 
> that time, an alpha).
> 
> According to the notes I scribbled back then, I had traced the problem to a 
> problem with the Ubuntu package.  Specifically, when I did an apt-get 
> mythtv, apt fetched/installed in the order backend, then MySQL, then 
> frontend...
> 
> ...which should never work, since configuring the backend *requires* talking 
> to mysql!
> 
> 
> In my case (another rebuild), I fixed it by manually getting mysql *first*, 
> then doing an apt-get mythtv.
> 
> 
> 
> But in your case, try
> 
> sudo dpkg-reconfigure mythtv-common
> 
> which should attempt to re-set-up the mysql stuff.  Then run mythtv-setup 
> again.


Mythtv-setup probably will not work until a proper user/password has 
been specified.

Your reported error is a '1': "Operation not permitted"...your user 
cannot do what you want.

Once you have mysql installed and can log into mysql using:

mysql -u root -p (and supplying the password), then run

mysql -u root -p  < mc.sql  (and provide your root password)

where mc.sql is a text file, containing:

CREATE DATABASE if not exists mythconverg;
GRANT ALL ON mythconverg.* TO mythtv at localhost IDENTIFIED BY "mythtv";
FLUSH PRIVILEGES;
GRANT CREATE TEMPORARY TABLES ON mythconverg.* TO mythtv at localhost 
IDENTIFIED BY "mythtv";
FLUSH PRIVILEGES;
ALTER DATABASE mythconverg DEFAULT CHARACTER SET latin1;
~

This creates the mythconverg database and a mysql user called 'mythtv' 
using the password 'mythtv'. It also grants the proper privileges to the 
user.
Myth should now be able to talk to the database. Note that if the 
backend is on a different machine, you cannot use 'localhost' but must 
use the frontend machine's name.

Geoff


More information about the mythtv-users mailing list