[mythtv-users] MySQL Setup Problem
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:
# /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
# 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