Connecting to mySQL

Development

Connecting to mySQL

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?

Replies (2)

RE: Connecting to mySQL - Added by Karsten Gallinowski almost 11 years ago

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.

RE: Connecting to mySQL - Added by Gachoud Philippe almost 7 years ago

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)`

Side Menu

Content