Forgot mysql DB User Password, how to retrieve it ?

The title says all, how can retrieve it ?

Please help me soon

 

There's no way to retrieve it. You can set a new password assuming that you have administrative/other access to the database.

What sort of access to the server do you have, Root, Control Panel, etc.?

 

yes, I have access to admin panel and its cPanel...

Anyway I created a new username and got the pass back

 

Hey just u can contact
Host provider he may helps u ....

 

1. Stop the mysqld daemon process.
2. Start the mysqld daemon process with the --skip-grant-tables option.
3. Start the mysql client with the -u root option.
4. Execute the UPDATE mysql.user SET Password=PASSWORD('password') WHERE User='root';
5. Execute the FLUSH PRIVILEGES; command.