List:General Discussion« Previous MessageNext Message »
From:Wagner Bianchi Date:November 29 2010 6:38pm
Subject:Re: From Maurizio Ponti, Switzerland
View as plain text  
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 <maurizio.ponti@stripped>

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

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