[mythtv-users] Fresh FC2 install

[Aaron Martin]

This is probably not the best way to do it from a security point of view, but my
myth box is not networked in any way, so what I did was change that line to:

GRANT ALL ON mythconverg.* TO mythtv at localhost IDENTIFIED BY "mythtv"



> 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
> 
>