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

[pschormeir at iiv.de]

Kris,

if you can connect to mythconverg and see the tables with "show tables;",
the database is up and running.
You can also check the presence of the database by typing mysqlshow in a
shell.

Can you connect to the mythconverg database from a shell as user mythtv
instead of root? (password for user mythtv should be mythtv)
If you try to start mythtv-setup from a shell, can you post what you see in
the shell (error messages) ?

Have you dropped the database and recreated it with the mc.sql file ? Just
to be sure that there are no wrong permissions on the database.

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: Mittwoch, 27. Juli 2005 09:12
An: Discussion about mythtv
Betreff: Re: AW: [mythtv-users] Can't connect to database



----- 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

_______________________________________________
mythtv-users mailing list
mythtv-users at mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users