List:General Discussion« Previous MessageNext Message »
From:Michael Dykman Date:November 29 2010 7:45pm
Subject:Re: From Maurizio Ponti, Switzerland
View as plain text  
It will affect all users named root.  If you need to limit it on a
per-host basis, first SELECT User, Host from mysql.user where User
='root' and qualify with the update with the Host names you find
there.

 - md

On Mon, Nov 29, 2010 at 1:58 PM, Wagner Bianchi
<wagnerbianchijr@stripped> wrote:
> Hi Michael,
>
> I am not sure whether your UPDATE statement will affect all "root" users
> password or only which one that will access from a localhost.
>
> Best regards.
> --
> WB
>
> 2010/11/29 Michael Dykman <mdykman@stripped>
>>
>> as root, stop your mysql server in the normal way
>> ie :$ service mysqld stop
>>
>> run mysql explicitly to skipp credentials
>>
>> ie. (run it in the back ground)
>>
>> $ /usr/libexec/mysqld --skip-grant-tables  &
>>
>> once the server starts, you should be able to:
>> $ mysql -u root
>>
>> assming you get in (no reason you shouldn't if you got this far), you
>> can use SQL statements to manipulate user data; you can't use GRANT or
>> SET PASSWORD so
>>
>> use mysql;
>>
>> update user set Password = PASSWORD('yourpassword') where User = 'root';
>>
>> exit your session and kill your mysqld process. (get the pid via ps
>> -aux, then kill that)
>>
>> restart mysql normally, and you should be good.  (I had to do this
>> over the weekend on a system someone else setup but failed to record
>> the credentials).
>>
>>  - michael dykman
>>
>> On Mon, Nov 29, 2010 at 12:28 PM, Maurizio Ponti
>> <maurizio.ponti@stripped> wrote:
>> > Dear Sirs, I would like to post the list:
>> >
>> > Topic: mysql server installation, password problems
>> >
>> > Dear Sirs, I downloaded the last MySQL server version some weeks ago,
>> > then I forgot the root password. I disinstalled everything and
>> > reinstalled from new, but I'm always asked for the old password in order
>> > to define a new one. It seems that an old file related to the password
>> > is still there in my computer and I could not erase it by disinstalling
>> > the server. Could you tell me which is the file and how could I delete
>> > it? Or what should I do in order to solve the problem? Thank you very
>> > much. Maurizio
>> >
>>
>>
>>
>> --
>>  - michael dykman
>>  - mdykman@stripped
>>
>>  May the Source be with you.
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:
>>  http://lists.mysql.com/mysql?unsub=1
>>
>
>



-- 
 - michael dykman
 - mdykman@stripped

 May the Source be with you.
Thread
From Maurizio Ponti, SwitzerlandMaurizio Ponti29 Nov
  • Re: From Maurizio Ponti, SwitzerlandWagner Bianchi29 Nov
  • Re: From Maurizio Ponti, SwitzerlandMichael Dykman29 Nov
    • Re: From Maurizio Ponti, SwitzerlandWagner Bianchi29 Nov
      • Re: From Maurizio Ponti, SwitzerlandMichael Dykman29 Nov