<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><div>On Dec 21, 2008, at 5:38 PM, the mad doctor kaeding wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">echo 'show databases;' | mysql --user=root --password<br>gives<br>....<br>mysql<br>mythconverg<br>.....</blockquote><div><br></div><div>So the mythtv user doesn't have access to the mythconverg database by the root user does.</div><div>Again, I point you to this page:</div><div><a href="http://www.mythtv.org/wiki/index.php/Mysql">http://www.mythtv.org/wiki/index.php/Mysql</a></div><div>With special attention to this part:</div><div><span class="Apple-style-span" style="font-family: -webkit-sans-serif; font-size: 13px; line-height: 19px; "><pre style="padding-top: 1em; padding-right: 1em; padding-bottom: 1em; padding-left: 1em; border-top-width: 1px; border-right-width: 1px; border-bottom-width: 1px; border-left-width: 1px; border-top-style: dashed; border-right-style: dashed; border-bottom-style: dashed; border-left-style: dashed; border-top-color: rgb(47, 111, 171); border-right-color: rgb(47, 111, 171); border-bottom-color: rgb(47, 111, 171); border-left-color: rgb(47, 111, 171); color: black; background-color: rgb(249, 249, 249); line-height: 1.1em; position: static; z-index: auto; "># mysql -u root -p mysql
myqsl> GRANT ALL PRIVILEGES ON *.* TO 'mythtv'@'localhost'
-> IDENTIFIED BY 'mythtv' WITH GRANT OPTION;
mysql> UPDATE user SET Password=PASSWORD('mythtv') WHERE user='mythtv';
mysql> FLUSH PRIVILEGES;
mysql> quit</pre></span></div></div><br></body></html>