From Maurizio Ponti, Switzerland

--0016e6dd961acb5af80496346695
Content-Type: text/plain; charset=ISO-8859-1

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

--0016e6dd961acb5af80496346695--

Re: From Maurizio Ponti, Switzerland

--001636c5b1ed07c55d049635613b
Content-Type: text/plain; charset=ISO-8859-1

Start mysqld with --skip-grant-tables option, give an update on the root
password, mentioning the new password the you want to put for your access
with root user and be happy.

Well, make some like this:

shell> mysqld --skip-grant-tables

Open another tty, terminal or prompt:

shell> mysql
mysql> update mysql.user set password = PASSWORD('12345') where user ='root'
and host = 'localhost';
mysql> \q

Stop MySQL...

# Linux or Unix
shell> /etc/init.d/mysql restart

# MS Windows
C:\> net stop MySQL
C:\> net start MySQL

And the, create a new connection with MySQL Serber using user new password.


Best regards.
--
WB

2010/11/29 Maurizio Ponti

> 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
>

--001636c5b1ed07c55d049635613b--

Re: From Maurizio Ponti, Switzerland

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 =3D PASSWORD('yourpassword') where User =3D '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
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
>



--=20
=A0- michael dykman
=A0- mdykman@gmail.com

=A0May 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=3Dgcdmg-mysql-2@m.gmane.o rg

Re: From Maurizio Ponti, Switzerland

--0016e6d625f8530099049635a839
Content-Type: text/plain; charset=ISO-8859-1

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

> 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
> 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@gmail.com
>
> 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=wagnerbianchijr@gmail.com
>
>

--0016e6d625f8530099049635a839--

Re: From Maurizio Ponti, Switzerland

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
=3D'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
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
>>
>> 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 =A0&
>>
>> 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 =3D PASSWORD('yourpassword') where User =3D 'ro=
ot';
>>
>> 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. =A0(I had to do this
>> over the weekend on a system someone else setup but failed to record
>> the credentials).
>>
>> =A0- michael dykman
>>
>> On Mon, Nov 29, 2010 at 12:28 PM, Maurizio Ponti
>> 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 ord=
er
>> > 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 disinstallin=
g
>> > 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
>> >
>>
>>
>>
>> --
>> =A0- michael dykman
>> =A0- mdykman@gmail.com
>>
>> =A0May the Source be with you.
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:
>> =A0http://lists.mysql.com/mysql?unsub=3Dwagnerbianchijr@gmai l.com
>>
>
>



--=20
=A0- michael dykman
=A0- mdykman@gmail.com

=A0May 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=3Dgcdmg-mysql-2@m.gmane.o rg