[mythtv-users] MySQL Setup Problem

[Yan-Fa Li]

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!