[PLUG] mysql help needed! -> trying to setup mythTV
Robert Anderson
riznob at gmail.com
Mon Feb 6 19:41:15 UTC 2006
On 2/6/06, Sean Whitney <sean.whitney at gmail.com> wrote:
>
> The Debian mythtv package came with a small mysql script
>
> 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 "<replace with your mythtv password>";
> FLUSH PRIVILEGES;
>
> that might help
>
> I also second installing phpmyadmin....
>
> Sean
>
>
> Ken Benderly wrote:
> > I'm trying to setup MythTV on a Suse 10 box, and I'm currently stuck on
> > some mysql issues. I have never used mysql before. I installed mysql
> > using Yast along with the dependencies. I think the version is 4.1.x.
> >
> > The daemon is up and running. I set the root password and created the
> > mythconverg database. After doing those two steps, I can't access mysql
> > without extra hassle:
> >
> > mythtv at linux:~> mysql -u root
> > ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
> > password: NO)
> > mythtv at linux:~>
> >
> > But if I issue the command 'mysql -u root -p', then it will prompt me
> > for a password and enter a mysql session. How do I set mysql so that
> > 'using password' is YES? Also, do I have to create a 'mythtv' (which is
> > my username) user in mysql? If so, how?
> >
> > This issue is preventing me from being able to launch 'mythtv-setup'
> > because the program can't access mysql. Any assistance would be very
> > much appreciated.
> >
> > Thanks,
> >
> > Ken
> >
> > _______________________________________________
> > PLUG mailing list
> > PLUG at lists.pdxlinux.org
> > http://lists.pdxlinux.org/mailman/listinfo/plug
>
> _______________________________________________
> PLUG mailing list
> PLUG at lists.pdxlinux.org
> http://lists.pdxlinux.org/mailman/listinfo/plug
>
Webmin has a really good mysql admin interface. The best setup guide for
MythTV is here...
http://wilsonet.com/mythtv/
I realize you are not using Fedora, but it's still worth looking at. Very
detailed step by step instructions.
--
Rob Anderson
riznob at gmail.com
More information about the PLUG
mailing list