<div dir="ltr">Do this steps using sudo:<div><ol><li>/etc/init.d/mysqld stop</li> <li>mysqld_safe --skip-grant-tables &</li> <li>mysql -u root</li> <li><pre class="mysql" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; background-image: none; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: initial; border-top-style: none; border-right-style: none; border-bottom-style: none; border-left-style: none; border-width: initial; border-color: initial; width: auto; clear: none; overflow-x: visible; overflow-y: visible; line-height: 1.333; display: inline !important; "> <div style="display: inline !important; ">USE mysql;</div> </pre></li><li><pre class="mysql" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; background-image: none; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: initial; border-top-style: none; border-right-style: none; border-bottom-style: none; border-left-style: none; border-width: initial; border-color: initial; width: auto; clear: none; overflow-x: visible; overflow-y: visible; line-height: 1.333; display: inline !important; "> <div style="display: inline !important; "></div> </pre><pre class="mysql" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; background-image: none; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: initial; border-top-style: none; border-right-style: none; border-bottom-style: none; border-left-style: none; border-width: initial; border-color: initial; width: auto; clear: none; overflow-x: visible; overflow-y: visible; line-height: 1.333; display: inline !important; "> <div style="display: inline !important; "><pre class="mysql" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; background-image: none; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: initial; border-top-style: none; border-right-style: none; border-bottom-style: none; border-left-style: none; border-width: initial; border-color: initial; width: auto; clear: none; overflow-x: visible; overflow-y: visible; line-height: 1.333; display: inline !important; "> UPDATE user SET password=PASSWORD("my_password") WHERE user="root";</pre> </div></pre></li><li><pre class="mysql" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; background-image: none; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: initial; border-top-style: none; border-right-style: none; border-bottom-style: none; border-left-style: none; border-width: initial; border-color: initial; width: auto; clear: none; overflow-x: visible; overflow-y: visible; line-height: 1.333; display: inline !important; "> <div style="display: inline !important; "><pre class="mysql" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; background-image: none; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: initial; border-top-style: none; border-right-style: none; border-bottom-style: none; border-left-style: none; border-width: initial; border-color: initial; width: auto; clear: none; overflow-x: visible; overflow-y: visible; line-height: 1.333; display: inline !important; "> </pre> </div></pre><pre class="mysql" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; background-image: none; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: initial; border-top-style: none; border-right-style: none; border-bottom-style: none; border-left-style: none; border-width: initial; border-color: initial; width: auto; clear: none; overflow-x: visible; overflow-y: visible; line-height: 1.333; display: inline !important; "> <div style="display: inline !important; "><pre class="mysql" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; background-image: none; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: initial; border-top-style: none; border-right-style: none; border-bottom-style: none; border-left-style: none; border-width: initial; border-color: initial; width: auto; clear: none; overflow-x: visible; overflow-y: visible; line-height: 1.333; display: inline !important; "> <pre class="mysql" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; background-image: none; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: initial; border-top-style: none; border-right-style: none; border-bottom-style: none; border-left-style: none; border-width: initial; border-color: initial; width: auto; clear: none; overflow-x: visible; overflow-y: visible; line-height: 1.333; display: inline !important; "> FLUSH PRIVILEGES;</pre> </pre></div></pre></li><li><pre class="mysql" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; background-image: none; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: initial; border-top-style: none; border-right-style: none; border-bottom-style: none; border-left-style: none; border-width: initial; border-color: initial; width: auto; clear: none; overflow-x: visible; overflow-y: visible; line-height: 1.333; display: inline !important; "> <div style="display: inline !important; "><pre class="mysql" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; background-image: none; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: initial; border-top-style: none; border-right-style: none; border-bottom-style: none; border-left-style: none; border-width: initial; border-color: initial; width: auto; clear: none; overflow-x: visible; overflow-y: visible; line-height: 1.333; display: inline !important; "> <pre class="mysql" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; background-image: none; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: initial; border-top-style: none; border-right-style: none; border-bottom-style: none; border-left-style: none; border-width: initial; border-color: initial; width: auto; clear: none; overflow-x: visible; overflow-y: visible; line-height: 1.333; display: inline !important; "> </pre> </pre></div></pre><pre class="mysql" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; background-image: none; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: initial; border-top-style: none; border-right-style: none; border-bottom-style: none; border-left-style: none; border-width: initial; border-color: initial; width: auto; clear: none; overflow-x: visible; overflow-y: visible; line-height: 1.333; display: inline !important; "> <div style="display: inline !important; "><pre class="mysql" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; background-image: none; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: initial; border-top-style: none; border-right-style: none; border-bottom-style: none; border-left-style: none; border-width: initial; border-color: initial; width: auto; clear: none; overflow-x: visible; overflow-y: visible; line-height: 1.333; display: inline !important; "> <div style="display: inline !important; "><pre class="mysql" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; background-image: none; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: initial; border-top-style: none; border-right-style: none; border-bottom-style: none; border-left-style: none; border-width: initial; border-color: initial; width: auto; clear: none; overflow-x: visible; overflow-y: visible; line-height: 1.333; display: inline !important; "> EXIT</pre></div></pre></div></pre></li><li><pre class="mysql" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; background-image: none; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: initial; border-top-style: none; border-right-style: none; border-bottom-style: none; border-left-style: none; border-width: initial; border-color: initial; width: auto; clear: none; overflow-x: visible; overflow-y: visible; line-height: 1.333; display: inline !important; "> <div style="display: inline !important; "><pre class="mysql" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; background-image: none; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: initial; border-top-style: none; border-right-style: none; border-bottom-style: none; border-left-style: none; border-width: initial; border-color: initial; width: auto; clear: none; overflow-x: visible; overflow-y: visible; line-height: 1.333; display: inline !important; "> <div style="display: inline !important; "><pre class="mysql" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; background-image: none; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: initial; border-top-style: none; border-right-style: none; border-bottom-style: none; border-left-style: none; border-width: initial; border-color: initial; width: auto; clear: none; overflow-x: visible; overflow-y: visible; line-height: 1.333; display: inline !important; "> /etc/init.d/mysqld restart</pre> </div></pre></div></pre></li><li><pre class="mysql" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; background-image: none; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: initial; border-top-style: none; border-right-style: none; border-bottom-style: none; border-left-style: none; border-width: initial; border-color: initial; width: auto; clear: none; overflow-x: visible; overflow-y: visible; line-height: 1.333; display: inline !important; "> <div style="display: inline !important; "><pre class="mysql" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; background-image: none; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: initial; border-top-style: none; border-right-style: none; border-bottom-style: none; border-left-style: none; border-width: initial; border-color: initial; width: auto; clear: none; overflow-x: visible; overflow-y: visible; line-height: 1.333; display: inline !important; "> <div style="display: inline !important; "><pre class="mysql" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; background-image: none; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: initial; border-top-style: none; border-right-style: none; border-bottom-style: none; border-left-style: none; border-width: initial; border-color: initial; width: auto; clear: none; overflow-x: visible; overflow-y: visible; line-height: 1.333; display: inline !important; "> mysql -u root -p </pre></div></pre></div></pre></li></ol><div> </div><div><pre class="mysql" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; background-image: none; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: initial; border-top-style: none; border-right-style: none; border-bottom-style: none; border-left-style: none; border-width: initial; border-color: initial; width: auto; clear: none; overflow-x: visible; overflow-y: visible; line-height: 1.333; display: inline !important; "> <div style="display: inline !important; "><pre class="mysql" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; background-image: none; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: initial; border-top-style: none; border-right-style: none; border-bottom-style: none; border-left-style: none; border-width: initial; border-color: initial; width: auto; clear: none; overflow-x: visible; overflow-y: visible; line-height: 1.333; display: inline !important; "> <div style="display: inline !important; "><pre class="mysql" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; background-image: none; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: initial; border-top-style: none; border-right-style: none; border-bottom-style: none; border-left-style: none; border-width: initial; border-color: initial; width: auto; clear: none; overflow-x: visible; overflow-y: visible; line-height: 1.333; display: inline !important; "> Write the new password...I hope this helps </pre> </div></pre></div></pre></div><pre class="mysql" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; background-image: none; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: initial; border-top-style: none; border-right-style: none; border-bottom-style: none; border-left-style: none; border-width: initial; border-color: initial; width: auto; clear: none; overflow-x: visible; overflow-y: visible; font-size: 12px; line-height: 1.333; font-family: monospace; display: inline !important; "> <pre class="mysql" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; background-image: none; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: initial; border-top-style: none; border-right-style: none; border-bottom-style: none; border-left-style: none; border-width: initial; border-color: initial; width: auto; clear: none; overflow-x: visible; overflow-y: visible; font-size: 12px; line-height: 1.333; font-family: monospace; display: inline !important; "> <div style="display: inline !important; "><pre class="mysql" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; background-image: none; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: initial; border-top-width: 1px; border-right-width: 1px; border-bottom-width: 1px; border-left-width: 1px; border-top-style: none; border-right-style: none; border-bottom-style: none; border-left-style: none; border-top-color: rgb(204, 204, 204); border-right-color: rgb(204, 204, 204); border-bottom-color: rgb(204, 204, 204); border-left-color: rgb(204, 204, 204); border-width: initial; border-color: initial; width: auto; clear: none; overflow-x: visible; overflow-y: visible; font-size: 12px; line-height: 1.333; font-family: monospace; background-position: initial initial; background-repeat: initial initial; "> <div><pre class="mysql" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; background-image: none; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: initial; border-top-width: 1px; border-right-width: 1px; border-bottom-width: 1px; border-left-width: 1px; border-top-style: none; border-right-style: none; border-bottom-style: none; border-left-style: none; border-top-color: rgb(204, 204, 204); border-right-color: rgb(204, 204, 204); border-bottom-color: rgb(204, 204, 204); border-left-color: rgb(204, 204, 204); border-width: initial; border-color: initial; width: auto; clear: none; overflow-x: visible; overflow-y: visible; font-size: 12px; line-height: 1.333; font-family: monospace; background-position: initial initial; background-repeat: initial initial; "> --------------------------</pre></div> </pre></div></pre></pre>Best Wishes, Waleed Harbi Dream | Do | Be <div class="gmail_quote">On Fri, Jun 18, 2010 at 12:09 AM, Mike McMullin <<a href="mailto:mmcmullin@cogeco.ca">mmcmullin@cogeco.ca</a>> wrote: <blockquote class="gmail_quote" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0.8ex; border-left-width: 1px; border-left-color: rgb(204, 204, 204); border-left-style: solid; padding-left: 1ex; "> <div class="im">On June 17, 2010 08:43:42 am R Kimber wrote: > On Wed, 16 Jun 2010 13:54:31 -0400 > > Hal Burgiss wrote: > > > /usr/sbin/mysqld is running > > > When I try /usr/bin/mysqladmin -u root password > > > newpassword-that-isn't-NO I get:- > > > /usr/bin/mysqladmin: connect to server at 'localhost' failed > > > error: 'Access denied for user 'root'@'localhost' (using password: NO)' > > > > > > I'd be grateful for advice. > > > > I would try a sudo with that. Which seems to work on 9.10. > > Thanks, but I did try sudo. I also tried becoming root and doing it as > root (without the sudo), with the same result. </div>Simple answer is that you are giving it the wrong password, which leads me to ask (no I didn't follow the thread) what are you trying to accomplish? I've gone around and around on this getting myth-tv setup. BTW, it is bad security, but writing these pass words down someplace is a great help, one that you learn the hard way. ;) <div><div></div><div class="h5"> -- ubuntu-users mailing list <a href="mailto:ubuntu-users@lists.ubuntu.com">ubuntu-users@lists.ubuntu.com</a> Modify settings or unsubscribe at: <a href="https://lists.ubuntu.com/mailman/listinfo/ubuntu-users" target="_blank">https://lists.ubuntu.com/mailman/listinfo/ubuntu-users</a> </div></div></blockquote></div> </div></div>