[mythtv-users] MySQL Setup Problem
Yan-Fa Li
yanfali at best.com
Mon Oct 25 16:52:10 UTC 2004
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.
>
>
> !DSPAM:417d2728213496855450994!
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
>
> !DSPAM:417d2728213496855450994!
More information about the mythtv-users
mailing list