<P>I would add a slight correction. The command,<BR> % mysql -u root mysql<BR> <BR>logs into the MySQL 'console' and selects the _database_ mysql. From there, the user table of the mysql database (mysql.user) is modified to set a root password as shown below. </P>
<P>Once the root password is set, root would log in (again to the mysql database) with something like, <BR> % mysql -p -u root mysql<BR>This forces mysql to prompt for a password. </P>
<P>From here, in order to change to the myth database,<BR> mysql> use mythconverg<BR> <BR>One could also log directly into the myth database with the following, <BR> % mysql -p -u root mythconverg</P>
<P>A helpful network debugging trick is to log in as the mythtv user,<BR> % mysql -p -u mythtv mythconverg</P>
<P>And if the backend is split from the frontend, try<BR> % mysql -p -u mythtv -h <host> mythconverg</P>
<P>And for kicks, to list all the databases within MySQL*,<BR> mysql> show databases</P>
<P>and to list all tables within one of those databases, <BR> mysql> use [database name]<BR> mysql> show tables</P>
<P>* where the database name corresponds with the directory name as defined by the "datadir" parameter in the MySQL startup script. </P>
<P>This wasn't the problem, I know, but hope that helps someone.</P>
<P>cheers,<BR>scuterky</P>
<P><BR>> <BR>> # mysql -uroot mysql<BR>> (the space between -u and root doesn't matter, but you need a space <BR>> between root and mysql [to select the mysql table that holds access <BR>> privledges])<BR>> <BR>> mysql> UPDATE user SET Password=PASSWORD('ROOT_PWD') WHERE <BR>> user='root'; <BR>> mysql> FLUSH PRIVILEGES; quit<BR>> </P>
<P> </P><p><hr SIZE=1>
Do you Yahoo!?<br>
Exclusive Video Premiere - <a href="http://launch.yahoo.com/video/?1093432&fs=1&redirectURL=http://launch.yahoo.com/promos/britneyspears/">Britney Spears</a>