[mythtv-users] MySQL Setup Problem
Quantum Scientific
Info at Quantum-Sci.com
Mon Oct 25 17:45:07 UTC 2004
Thanks, I'll try that. But first I must re-learn how to set the second password, since using the instructions gives the same error as below.
Gee, I wish the instructions could be updated, since they don't work. So many people give up on Myth because of perplexing problems like this.
On Monday 25 October 2004 11:52, Yan-Fa Li wrote:
> Actually the next step for you would be:
>
> mysql -u root -p < mc.sql
>
> You're trying to start a mysql session without a password. It will
> prompt you for the password with a -p parameter. You can also just type
> in the password after -p but then it's recorded in the command shell
> cache so it's not recommended.
>
> Yan
>
> Quantum Scientific wrote:
> > 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