[mythtv-users] MySQL Setup Problem

Quantum Scientific Info at quantum-sci.com
Mon Oct 25 16:10:58 UTC 2004


Well, I'm missing something. 
 
Trying to install Myth on Gentoo:  emerged mysql and initted it via emerge, as recommended. Then: 
 
Code:
# /etc/init.d/mysql start ok 
 # /usr/bin/mysqladmin -u root -h localhost password 'new-password' 
 # /usr/bin/mysqladmin -u root password 'new-password' 
 mysqladmin: connect to server at 'localhost' failed 
 error: 'Access denied for user: 'root at localhost' (Using password: YES)'

So I ran mysql> and manually set that second password. 
 
The next step is supposed to be 

Code:
# mysql < /usr/share/mythtv/database/mc.sql 
 ERROR 1045: Access denied for user: 'root at localhost' (Using password: NO) 
 
So, start over by stopping the server, deleting the databases, and mysql_install_db, etc.  Exactly the same syndrome. 
 
Isn't there any straightforward way to use Postgres with Myth?  I never have a problem with Postgres, and always do with Mysql.


More information about the mythtv-users mailing list