[PLUG] mysql help needed! -> trying to setup mythTV

[Sean Whitney]

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