I posted this today"well i'm sorry for double posting but i end up waiting too long for a response. yes i have the lastest version of mythtv. yes i have done this:
Setup mysql database mythconverg
Set the root password for the mysql database. (replace mysqlpassword with your own)
Open a Terminal window
> mysql -u root password mysqlpassword
Setup the initial database. Note - the mc.sql file should have been installed along with the mythtv documentation onto your system. The default location for this file is shown below, however it may have been relocated elsewhere according to your distribution's documentation rules, so you may have to use a search (find, locate, etc) tool to reveal its whereabouts. (The following command will prompt for password)
> mysql -u root -p < /usr/share/mythtv/sql/mc.sql
How to Reset the Root Password (Slackware):
Login as a root
> su -
Stop the database
> /etc/rc.d/rc.mysqld stop
Set the initial file for a new root database password
> echo "SET PASSWORD FOR 'root'@'localhost' = PASSWORD('new_password');" > /var/lib/mysql/mysql-init
Change the user and group ownership
> chown mysql.mysql /var/lib/mysql/mysql-init
Start a database manually
> /usr/bin/mysqld_safe --init-file=/var/lib/mysql/mysql-init &
Login to the database as a root with a new password
> mysql -u root -p new_password
and i edited /etc/mythtv/mysql.txt.
the backend is running and it still cannot connect to the database.
i still get this: 2008-04-20 15:41:21.161 Using runtime prefix = /usr, libdir = /usr/lib
2008-04-20 15:41:21.370 Empty LocalHostName.
2008-04-20 15:41:21.481 Using localhost value of Bmans PS3
2008-04-20 15:41:22.022 New DB connection, total: 1
2008-04-20 15:52:03.321 Using runtime prefix = /usr, libdir = /usr/lib
2008-04-20 15:52:03.597 Empty LocalHostName.
2008-04-20 15:52:03.605 Using localhost value of Bmans PS3
2008-04-20 15:52:04.668 New DB connection, total: 1
2008-04-20 15:55:14.574 Unable to connect to database!
2008-04-20 15:55:14.603 Driver error was [1/2003]:
QMYSQL3: Unable to connect
Database error was:Can't connect to MySQL server on '192.168.1.135' (110) only i changed it to 192.168.1.148.
there is also a host authentication failure message.
Never have i been so frustated by the lack of support and lack of users in the forums. if linux is to succeed, then users should try posting in one centralized location http://www.thelinuxvault.net/wiki/Main_Page.they should know that not everyone is smart and/or intelligent enough to use linux. I am not one of those people, but that does not mean I don't struggle with things.I can understand that double posting clogs forums, but old threads don't often get answered.There should be a unified notifier of already posted threads or a search engine where you type a question, a description and its topic with advance feature to reduce forum clutter and to help more people faster. So would it hurt you to check more often to prevent forum clutter? I will try to not double post.Seriously though what is being done is ridiculous.
I will make the last time i double post, So help me Dao."Within this quote is my idea.
