[mythtv-users] MySQL Setup Problem [SOLVED]

[Quantum Scientific]

OK, this did it, thanks.

For the benefit of future users, here is the secret procedure.  This conflicts with all written instructions in Gentoo and Myth, but it is the right way:

===============================================
# mysql_install_db
# mysqladmin -u root -h localhost password 'mypassword' 
# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5 to server version: 4.0.21

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> SELECT user, host, password FROM mysql.user;
+------+-----------+------------------+
| user | host      | password         |
+------+-----------+------------------+
| root | localhost | 5d2e19393cc5ef67 |
| root | tarbaby    |                              |
|        | localhost |                              |
|        | tarbaby    |                              |
+------+-----------+------------------+
4 rows in set (0.00 sec)

mysql> GRANT ALL PRIVILEGES ON *.* TO root@"tarbaby" IDENTIFIED by 'mypassword' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT user, host, password FROM mysql.user;
+------+-----------+------------------+
| user | host      | password         |
+------+-----------+------------------+
| root | localhost | 5d2e19393cc5ef67 |
| root | tarbaby    | 5d2e19393cc5ef67 |
|      | localhost |                  |
|      | tarbaby    |                  |
+------+-----------+------------------+
5 rows in set (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> exit
Bye
# mysql -u root -p < /usr/share/mythtv/database/mc.sql
Enter password:
#
===============================================




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