Thank you so much, I really appreciate you walking me through this.<br><br>I will try it when I get home and let you know how it works out :)<br><br><br> -Tim<br><br><div class="gmail_quote">
On Tue, Oct 13, 2009 at 2:25 PM, R. G. Newbury <span dir="ltr"><<a href="mailto:newbury@mandamus.org">newbury@mandamus.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="im">Tim Urben wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
I tried it and got this<br>
<br>
[root@htpc ~]# /sbin/chkconfig mysqld on<br>
[root@htpc ~]# /sbin/service mysqld start<br>
Starting MySQL: [ OK ]<br>
[root@htpc ~]# mysql -u root mysql<br>
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)<br>
</blockquote>
<br>
<br></div>
Jarod Wilson's pages set out all the steps. Some are no longer required, as drivers have migrated into the kernel, and some are no longer as difficult for the same reason, but the main structure is the same.<br>
<br>
You have mysql installed. You apparently do not yet have a mythtv user, and are not calling mysql correctly.<br>
<br>
As ROOT, try: mysql -u root<br>
<br>
You should get a 'mysql >' prompt.<br>
<br>
Mysql installs, by default without a password for the root account. This is NOT the same as your computer user 'root' account, but more like an 'admin' for mysql.<br>
<br>
If you get the same error, there are a couple of possible reasons.<br>
<br>
1) Your /etc/my.cnf file points to the wrong place.<br>
The /etc/my.cnf file needs the following:<br>
<br>
# file: /etc/my.cnf<br>
[mysqld]<br>
… # someother settings<div class="im"><br>
socket=/var/lib/mysql/mysql.sock<br></div>
[client]<br>
… # some other settings<div class="im"><br>
socket=/var/lib/mysql/mysql.sock<br>
<br></div>
Use 'service mysqld stop', then edit the my.cnf file.<br>
<br>
2) /etc/my.cnf points to the correct place but mysql cannot read or write there.<br>
do 'service mysqld stop'<br>
'cd' to /var/lib and do 'chown -R mysql:mysql /var/lib/mysql'<br>
'service mysqld start'<br>
'mysql -u root'<br>
and see what happens.<br>
<br>
************<br>
At this point it appears that you do not have a 'mythtv' user under mysql. 'mythtv' is the user which 'talks' to the mysql database. Once you have a working mysql that the root user can use, you create the mythtv user as follows:<br>
<br>
mysql -u root < mc.sql<br>
<br>
where mc.sql is the following text file:<br>
<br>
CREATE DATABASE IF NOT EXISTS mythconverg;<br>
GRANT ALL ON mythconverg.* TO mythtv@localhost IDENTIFIED BY "mythtv";<br>
FLUSH PRIVILEGES;<br>
GRANT CREATE TEMPORARY TABLES ON mythconverg.* TO mythtv@localhost IDENTIFIED BY "mythtv";<br>
FLUSH PRIVILEGES;<br>
ALTER DATABASE mythconverg DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;<br>
<br>
Note that the 'mythtv' user and the 'mythtv' password (the 'identified by' portion) are placeholders for whatever name/password you wish to use, which can be your 'usual' user.<br>
<br>
Once you have got this far, ADD A PASSWORD FOR THE ROOT USER UNDER MYSQL!!! If your mythbox does nothing else and you have no email, or bank account information, then that does not matter much. But it does matter if your mythbox gets compromised and any of your other computers ever connect to your LAN....And there are a known group of exploits based on compromising a mysql install.<div class="im">
<br>
<br>
Geoff<br>
<br>
<br>
-- <br>
Please let me know if anything I say offends you.<br>
I may wish to offend you again in the future.<br>
<br>
Tux says: "Be regular. Eat cron flakes."<br>
<br>
_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a><br>
</div><div><div></div><div class="h5"><a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users" target="_blank">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br>
</div></div></blockquote></div><br>