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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] To: "Discussion about mythtv" <mythtv-users@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 '[EMAIL PROTECTED]' (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 [EMAIL PROTECTED] IDENTIFIED BY "mythtv"; FLUSH PRIVILEGES; GRANT CREATE TEMPORARY TABLES ON mythconverg.* TO [EMAIL PROTECTED] 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: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Auftrag von Kris Clark > Gesendet: Dienstag, 26. Juli 2005 09:23 > An: mythtv-users@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@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@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users _______________________________________________ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users