AW: [mythtv-users] Can't connect to database

[Kris Clark]

----- Original Message -----
From: pschormeir at iiv.de
To: "Discussion about mythtv" <mythtv-users at mythtv.org>
Subject: AW: [mythtv-users] Can't connect to database
Date: Tue, 26 Jul 2005 10:53:21 +0200

Fritz,
Yes, mysql is running and I can access it but I have to add -p to the end of the command line otherwise I get this error :
ERROR 1045 (28000): Access denied for user 'root at localhost' (using password NO).
If I then input my password I get access.

I have the following at /usr/share/doc/mythtv-0.18.1/database/mc.sql:

CREATE DATABASE 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;

It seems that the actual database either does not exist or is not seen by mysql? I have tried a few other suggestions that I found in various forums etc, but I still have not made any real progress. Have you any other ideas?

Thanks,
Kris.



> 
> Are you sure, your mysql service is running ?
> Can you connect to the databsae on the command prompt ?
> Open a shell and type in "mysql -u root mythconverg". After that type in
> "show tables;" If you see the list of tables, the database seems to be
> present.
> If you want to reinstall the database do the following steps :
> Open a shell and type in "mysql -u root". Then enter "drop database
> mythconverg;" (This will delete your current mythtv-database). After that
> exit mysql. Now type in "mysql -u root < /path_to_the_file/mc.sql" (will
> create a new empty database)
> 
> if you need more help, give me more details.
> 
> Regards
> 
> Fritz
> 
> -----Ursprüngliche Nachricht-----
> Von: mythtv-users-bounces at mythtv.org
> [mailto:mythtv-users-bounces at mythtv.org]Im Auftrag von Kris Clark
> Gesendet: Dienstag, 26. Juli 2005 09:23
> An: mythtv-users at mythtv.org
> Betreff: [mythtv-users] Can't connect to database
> 
> 
> I have got stuck with the database connection. When I run 'mythtvsetup' it
> can't connect. I think that I have corrupted something while following the
> setup instructions. I have spent hours going off at a tangent into the Mysql
> manual to try and check if the password is OK. I am slightly wiser now than
> several days ago but still not smart enough to get this problem resolved. If
> this was 'w*****s'I would remove and then reinstall the Mysql application to
> start over. I have not found out how to do this with Fedora. Can anyone
> suggest what would be the easiest way to solve this problem?
> 
> --
> ___________________________________________________________
> Sign-up for Ads Free at Mail.com
> http://promo.mail.com/adsfreejump.htm
> 
> 
> 
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


-- 
___________________________________________________________
Sign-up for Ads Free at Mail.com
http://promo.mail.com/adsfreejump.htm