asked on

restoring password

hi ,

somebody hacked into my mysql database and changed my password to the mysql admin....
is there some way to retrieve it without loosing my whole database??

i have about a gigabite of information there which is backed up but without password i can't manage it....
when trying to access threw php admin the error message is "Access denied for user: 'root@localhost' (Using password: NO)"

Thanks for a quick answer

Peter

Squeebee

"(Using password: NO)"

If you do not provide a password the NO will appear. Was you previous password no password? If not then it did not make it to MySQL.

Anyway, to change your password kill all mysql processes so the server is not running, then start the server with the --skip-grant-tables directive to disable password checking. Then switch to the mysql database and issue:

UPDATE user SET password = PASSWORD('newpassword') WHERE user = 'root';
FLUSH PRIVILEGES;

And you will have a new password for root.

funkytaz10

ASKER

thanks for the answer....

i forgot to mention that this mysql database is used for a invision power board on a windows xp computer with MINI portal from instantservers as server...

so there is the big difficulty...

sorry

Peter

Squeebee

Is MySQL in your process list?

funkytaz10

ASKER

yes... the forum is working but we can't change things any more...

Squeebee

That is not what I asked, if you go to the task manager and switch to your process list do you have a mysqld process listed?

ASKER CERTIFIED SOLUTION

heskyttberg

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.