Top Menu

Jump to content
Home
    Modules
      • Projects
      • Activity
      • Work packages
      • Gantt charts
      • Calendars
      • Team planners
      • Boards
      • News
    • Getting started
    • Introduction video
      Welcome to OpenProject Community
      Get a quick overview of project management and team collaboration with OpenProject. You can restart this video from the help menu.
    • Help and support
    • User guides
    • Videos
    • Shortcuts
    • Community forum
    • Enterprise support
    • Additional resources
    • Data privacy and security policy
    • Digital accessibility (DE)
    • OpenProject website
    • Security alerts / Newsletter
    • OpenProject blog
    • Release notes
    • Report a bug
    • Development roadmap
    • Add and edit translations
    • API documentation
  • Sign in
      Forgot your password?

      or sign in with your existing account

      Google

Side Menu

  • Overview
  • Activity
    Activity
  • Roadmap
  • Work packages
    Work packages
  • Gantt charts
    Gantt charts
  • Calendars
    Calendars
  • Team planners
    Team planners
  • Boards
    Boards
  • News
  • Forums
  • Feature tour
    Feature tour

Content

You are here:
  1. Forums
  2. Development

Connecting to mySQL

Added by Deuce Sapp almost 10 years ago

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

  • (1 - 2/2)
Loading...