AW: AW: [mythtv-users] Can't connect to database
pschormeir at iiv.de
pschormeir at iiv.de
Wed Jul 27 06:12:13 EDT 2005
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
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.
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
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
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";
GRANT CREATE TEMPORARY TABLES ON mythconverg.* TO mythtv at localhost
IDENTIFIED BY "mythtv";
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?
> 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
> 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.
> -----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
> manual to try and check if the password is OK. I am slightly wiser now
> several days ago but still not smart enough to get this problem resolved.
> this was 'w*****s'I would remove and then reinstall the Mysql application
> 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
> mythtv-users mailing list
> mythtv-users at mythtv.org
Sign-up for Ads Free at Mail.com
mythtv-users mailing list
mythtv-users at mythtv.org
More information about the mythtv-users