Arch Linux

rayjgu3

Member

From: Chicago IL usa

Registered: 2004-07-04

Posts: 695

mysql / mythtv

im not sure where the problem lies here  (more than likely PEBKAC)
i followed the directions
here
and /usr/share/mythtv/QUICKSTART.archlinux
but i cant seem to get it together

 mysql -u root -p < /usr/share/mythtv/mc.sql
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

#mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

ive googled for a few days now done alot of reading

i had this thing working before the most recent update of mysql (2006-11-12)
mythtv does not connect to the database
ive tried to remove mysql via pacman -Rd mysql then removed the pacsave stuff
removing mysql...
warning: /etc/my.cnf saved as /etc/my.cnf.pacsave
warning: /etc/conf.d/mysqld saved as /etc/conf.d/mysqld.pacsave
reinstall
pacman -S mysql
commands ive tried to gain access to mysql "root"

#mysqld_safe --skip-grant-tables &
[1] 4709
# mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
#mysqladmin -u root flush-privileges password "newpwd"
mysqladmin: unable to change password; error: 'Can't find any matching row in the user table'

theres been other stuff but i dont recall it all alot of the stuff i read seamed to say the same thing same commands same options
any ideas welcomed

TheDoctor

Member

From: Ontario, Canada

Registered: 2005-06-28

Posts: 63

Website

Re: mysql / mythtv

Did you set your root password for mysql after the install? 

# mysqladmin -u root password NEWPASSWORD

peque

Member

From: Denmark - Møn

Registered: 2005-06-26

Posts: 441

Re: mysql / mythtv

Are you sure that you have backup of your Mysql database.

Here's a link about updating MythTV and the databases??
http://www.mythtv.org/docs/mythtv-HOWTO-23.html#ss23.5

---

Just getting better .... All the time

rayjgu3

Member

From: Chicago IL usa

Registered: 2004-07-04

Posts: 695

Re: mysql / mythtv

to tell the truth i wiped it out reinstalled was able to get into mysql but couldnt get mythtv to connect to tuner ie: it did not display a picture or give sound
getting frustrated i decided to look a bit at precompiled distros found videolinux  livecd  its i686 optimized beta & runs pretty fast off the cd/ram id say bout as fast as archie got alot off good video tools
but i am unable to get it to boot off a scsi drive ive made several  new initrd for it but after fighting with this for a few days i believe im gonna put arch back on it  then install all the video tools from arch AUR or try my hand at some PKGBUILD's  that arent in the AUR but i wont get to that till earliest this weekend
thanks all