Reset the root password on mantis

[krekon]

Hi

I have problem with the password of mantis. I don't know exactly what the mantis do but I know that it has something to do with mysql and it is an important application because every time I want to add a package on my debian the mantis pops-up and ask me for the password of root of the database. I have lost the password and since then everything I install ends with an error code (1) and some other errors that it has to do with the dpkg. It happens at every installation.

I have discovered that there is a relationship between mantis and mysql and I tried to use some tricks to get a new password.One of them is here , but I saw that there is nothing at the directory /usr/local/mysql/bin/safe_mysqld. Actually I can go only at the /usr/local/. The other directories does not exist.

I have installed mysql-client and not mysql-server. What is exactly the difference. At the short description of packages it isn't described clearly.

Nevertheless I don't know what exactly causes the error code at installation but I think that is the password of mantis.

If you know what causes the problem at installation or if you know how could I reset my password on mantis please tell me. Any futher information is acceptable

[Juan Pablo]

Have you tried this ?

I have discovered that there is a relationship between mantis and mysql

Mantis is a bug tracker written on PHP, it uses MySQL to store data. More info here

I have installed mysql-client and not mysql-server. What is exactly the difference. At the short description of packages it isn't described clearly.

I'm not an expert on databases but I know a thing or two, MySQL Client is used to connect to MySQL servers and check databases stored on MySQL servers