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