| View previous topic :: View next topic |
| Author |
Message |
Sarlok
Tux's lil' helper
Joined: 03 Jan 2003
Posts: 98
|
 Posted: Wed Nov 26, 2003 7:19 am Post subject: MySQL problems while setting up MythTV... |
 |
|
Hello folks.
I've been going around in circles most of the evening while trying to get my Tv Tuner working.
After blindly emerging MySQL and pretty much everything else I needed to get MythTV compiling (Oh, it needs other stuff too? sure, whatever... *3 hours, and 45 packages later...*), I wasn't surprised to see that mySQL gave me a screen full of errors right off the bat.
I think I've managed to get somethnig done since I started, but I've hit a brick wall with that database thing for MythTV (For the record, I loathe MySQL, but I like my TV Tuner, so I'm prepared to put up with it.  )
MySQL is running, using the /etc/init.d/mysql runscript.
| Code: |
FluxTux database # mysql < /usr/share/mythtv/database/mc.sql
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
|
I've found a couple of threads that cover this already, but neither have seemed to help.
One of which - a slightly different problem, but at least allowed me to log into mysql as root:
https://forums.gentoo.org/viewtopic.php?t=97203&highlight=error+1045+access+denied+user+root+localhost+using+password
I really don't care if I get this working and MySQL becomes intentionally crippled as to be useless for a webserver. I Just want to get Mysql working enough for MythTV to run.
When I try to run MythTV, I get this should anyone read this and feel inclined to ask...)
| Code: |
sarlok@FluxTux sarlok $ mythtv
Unable to connect to database!
Driver error was [1/1045]:
QMYSQL3: Unable to connect
Database error was:
Access denied for user: 'mythtv@localhost' (Using password: YES)
couldn't open db
|
Is there anything anyone could suggest? I've already gone over the MythTV install guid a few too many times, and I don't particularly feel like re-merging MySQL unless I really have to.
Edit:
Sorry if this is meant to be in multimedia, but this looked more like a MySQL problem than a MythTV one.
_________________
Four-thousand, six-hundred and ninety-one Irradiated haggis. |
|
| Back to top |
|
 |
NinerFan
n00b
Joined: 23 Jul 2003
Posts: 30
Location: California
|
| Posted: Wed Nov 26, 2003 8:04 am Post subject: Re: MySQL problems while setting up MythTV... |
|
|
| Sarlok wrote: |
| Code: |
FluxTux database # mysql < /usr/share/mythtv/database/mc.sql
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
|
|
If you setup a password on your mysql root account, add a -p so that it prompts you for the password prior to importing the sql file would be my suggestion.
Like so:
| Code: | | mysql -p < /usr/share/mythtv/database/mc.sql |
|
|
| Back to top |
|
|
Sarlok
Tux's lil' helper
Joined: 03 Jan 2003
Posts: 98
|
| Posted: Wed Nov 26, 2003 7:17 pm Post subject: |
|
|
Ah. That fixed it.
It gave me the error about missing the sock file, so I just commented that line out of the my.cnf file, but now I just can't get MythTV To work. Heh.
Thanks. 
_________________
Four-thousand, six-hundred and ninety-one Irradiated haggis. |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
Networking & Security
