This seems like a very dumb question, but I can’t seem to find an answer. I installed OP using the package installer. I am trying to access the mySQL database and cannot sign in — I have tried

mysql —user=root -p
mysql —user=root
mysql —user=admin -p
mysql —user=openproject -p

with the the admin password I set during install. Where am I going wrong?

Hi Deuce,

maybe you are using not the password you defined during the install process? At least this could be the case so please open the file installer.dat located under /etc/openproject/. There you will find all related information including your root password for mysql.

Please let us know if this fixed your problem.

Cheers,
Karsten

ps.: mysql -u root -p is the command you want to use.

Both passwords for user openproject and root are set into /etc/openproject/installer.dat

sudo openproject configure gets them from there, so checkout the lines with mysql/root_password and mysql/db_password

I know maybe its not the particular problem but the one I got so I'm letting this answer for other people having this problem

Got `Access denied for user 'root'@'localhost' (using password: YES)`