MySQL password

[Waleed Harbi]

*Do this steps using sudo:*

   1. */etc/init.d/mysqld stop*
   2. *mysqld_safe --skip-grant-tables &*
   3. *mysql -u root*
   4.

   *USE** mysql**;*

   5.

   **

   *UPDATE** **user** **SET**
**password**=**PASSWORD**(**"my**_**password"**)** **WHERE**
**user**=**"root"**;*

   6.

   **

   *FLUSH **PRIVILEGES**;*

   7.

   **

   *EXIT*

   8.

   */etc/init.d/mysqld restart*

   9.

   *mysql -u root -p*


*
*

*Write the new password...I hope this helps *

*

--------------------------

*

Best Wishes,
Waleed Harbi

Dream | Do | Be


On Fri, Jun 18, 2010 at 12:09 AM, Mike McMullin <mmcmullin at cogeco.ca> wrote:

> 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.
>
> 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.  ;)
>
> --
> ubuntu-users mailing list
> ubuntu-users at lists.ubuntu.com
> Modify settings or unsubscribe at:
> https://lists.ubuntu.com/mailman/listinfo/ubuntu-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.ubuntu.com/archives/ubuntu-users/attachments/20100618/b4489275/attachment.html>