<div dir="ltr"><div class="gmail_extra"><div class="gmail_quote">On Fri, Oct 4, 2013 at 5:10 PM, Craig Huff <span dir="ltr"><<a href="mailto:huffcslists@gmail.com" target="_blank">huffcslists@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div><div><div><div><div>I am in the process of (finally) upgrading from MythBuntu 10.04 to MythBuntu 12.04 so I'll be ready (readier?) for the next LTS release.<br>
<br></div>I am building the new system on a separate disk, so I can switch back and forth with a reboot.<br>
</div>I have the mysql dump from the 10.04 system and have replaced the default mythconverg database with the backup, but...<br><br></div>I want to change the passwords in the user table for {user=mythtv, host=localhost} to be the one listed in the new system's /etc/mythtv/config.xml rather than the one from the old system. I am getting nowhere and getting there really fast.<br>
<br></div>Apparently, the following is not the right way to get this done. Any advice would be appreciated.<br><br></div><div>Attempted Procedure:<br></div><div>1) Obtain mysql administrator username and password from /etc/mysql/debian.cnf and substitute their values for "admin" and "admin_pwd" in the following commands.<br>
</div><div>2) Obtain the mythtv user's mysql password for the mythconverg database from /etc/mythtv/config.xml and substitute its value for "mythtv_pwd" in the following commands.<br></div><div>3) Do the following:<br>
</div><div>$mysql -u admin -padmin_pwd<br></div><div>> USE mysql;<br></div><div>> SELECT host, user, password FROM user;<br></div><div>> UPDATE user SET password=password('mythtv_pwd') WHERE user='mythtv' AND host='localhost';<br>
<br></div><div>The response I get is:<br></div><div>Query OK; 0 rows affected ...<br></div><div>Rows matched: 1 Changed: 0 Warnings: 0<br><br></div><div>How should I do this, since my SQL syntax knowledge won't fill a thimble?<br>
<br></div><div>TIA,<br></div><div>Craig.<br></div></div>
<br></blockquote><div><br>I think you want:<br>SET PASSWORD FOR 'mythtv'@'localhost' = PASSWORD('mythtv_pwd');<br></div><div>FLUSH PRIVILEGES;<br></div><div><br>The flush privileges may not be required but it can't hurt. Here's the source: <a href="http://dev.mysql.com/doc/refman/5.0/en/set-password.html">http://dev.mysql.com/doc/refman/5.0/en/set-password.html</a><br>
<br></div></div>Karl<br></div></div>