Please help as I am pulling my hair out once again after trying for over 15 months off and on to get a tv tuner working under linux. I have just received my new tuner card which I thought was supposed to be easy to run, a HVR-950Q, no luck yet.
But first I am trying to use something called mysql (new to me), for mythtv and * keep getting
mysqladmin -u root password ma
mysqladmin: connect to server at ‘localhost’ failed
error: ‘Access denied for user ‘root’@‘localhost’ (using password: NO)’
and to make things worse, and while trying an alternative (Kaffeine in gnome), it gives me this error when I run it, and I don’t see a simple solution for it!!!
VampirD
No in elenath hîlar nan hâd gîn
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.12 (GNU/Linux)
Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org/
ok this is a new learning curve for sure, nothing makes sense at this point so I am sure I am making a lot of silly mistakes, here is what I get when i use the above method
linux-26yx:~ # mysqladmin -u root -pma
mysqladmin Ver 8.42 Distrib 5.1.36, for suse-linux-gnu on x86_64
Copyright 2000-2008 MySQL AB, 2008 Sun Microsystems, Inc.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
… and a lot of help suggestions
and when I try to setup the backend of mythtv, it says cannot connect to the data base and I have tried
Hostname -localhost
Database name - mythconverg
user/password - root/ma, and tried mythtv/mythtv, and tried ack/ma
and always unable to connect to database
I am sure it is not set up right!
Have you created the database for mythtv and given it a user and password to access it? Where do your instructions come from? Your starting point may depend on whether you have already set a root password for mysql (the root in mysql, or in fact any mysql accounts, is not the same as root in Linux and has a separate password).
Thanks tha make sthings clearer and I like how you are assuming I know nothing (It is quite true about this anyway). So when trying to setup mythtv backend should I be using
1/ my own user name/password, ex ack@localhost/psswrd, or
2/ mythtv/mythtv, or
3/ root/psswrd,
and how do I set them up without getting the help menu(that is all I get from…#mysqladmin -u root -p, or #mysqladmin -u root -p’topsecret’
and for anything that tries to connect I get for example
linux-26yx:~ # mysql -u root mythconverg
ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: NO)
I will try to uninstall mysql and start from scratch
If you don’t have any recollection of setting up a mysql root password, then there is none. You should be able to get a mysql prompt by
mysql -u root
And exit with quit or ctrl-d.
If that is the case, here’s how you create a database for mythtv and account to access it. The mysql> is the prompt you see, not for you to type in.
mysql> create database mythtv;
mysql> grant all on mythtv.* to mythtv@localhost identified by 'mythtv';
The first mythtv is the database name, the second the account name, and the third the password. This is in case you want to use other values.
You can then exit mysql as root and login as mythtv to test:
mysql -u mysql -p mythtv
Password:
mysql>
The first mythtv is the account name, the second the database to use.
Then you can proceed with the mythtv setup.
If you did set up a root password for mysql (would not be the same as your Linux root password), then I hope you remember it. The only difference would be adding -p to the command line when connecting as root in the first invocation:
OK just a quick note to say that after a reinstall and getting nowhere again (stumbling badly) your last comments got me right on track and I am able to get to the setup page for mythtv … which I am about to do …fingers crossed!
ken, thank you so much for the detailed and considerate explanations
OK My brain and luck seem to be running out haha!!
I set up the backend successfully though without any successful channel scan, and more seriously the front end continually complains that it can’t connect to the backend server… hmmmmmm
I am totally fambouzzeled and need to take a break (24 hours straight arghhhhh) so if this seems a little confusing , it probably is, well tomorrow is a new day, any troubleshooting tips would be appreciated for the morning or in a few hours after a flick if i can still hold my eyes open.
That sounds like a mythtv problem. I don’t have any experience with mythtv. One of those things I was getting a round tuit. You might want to start a new thread with mythtv in the title or the people who might help won’t see it.