[mythtv-users] Fresh FC2 install

[Graham W. Mitchell]

I am running thru Jarods guide, and I have got to the part of creating
the empty database... I get the following error.... Installation is via
apt-get...

 

 

[mythtv at alice2 mythtv]$ mysql -u root -p <
/usr/share/doc/mythtv-0.16/database/mc.sql

Enter password: 

ERROR 1064 at line 4: You have an error in your SQL syntax near
'TEMPORARY TABLES ON mythconverg.* TO mythtv at localhost IDENTIFIED BY
"mythtv"' at line 1

[mythtv at alice2 mythtv]$ vi /usr/share/doc/mythtv-0.16/database/mc.sql

 

Which version of SQL should be installed? I can't seem to see anything
on the mythtv website recommending a pre-requisite version. Looking thru
my RPMs, I have the following installed...

 

[root at alice2 root]# rpm -qa | grep sql

php-mysql-4.3.8-2.1

mod_auth_mysql-20030510-4.1

mysql-3.23.58-9

mysql-server-3.23.58-9

 

 

Does anyone have any suggestions where I can look next? I've seen a
couple of messages in the archive with similar problems, but I've not
found a resolution posted for them.

 

 

Graham

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20040918/c04947b6/attachment.htm