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
    • Upgrade to Enterprise edition
    • 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

Content

Support Installation & Updates
  1. OpenProject
  2. Forums
  3. Support Installation & Updates
  4. Set up database_access denied

Set up database_access denied

Added by julia dempewolf almost 11 years ago

Hey all,

I was very proud to have managed to follow the installation steps up to this point, but at “set up database” I ran into a wall. Since my knowledge of the inner workings of my mac (Mavericks) is very limited/close to non existing, I would appreciate advice regarding what to do next. :)

the error message that terminal gave me:

mysql> CREATE DATABASE openproject CHARACTER SET utf8;
ERROR 1044 (42000): Access denied for user ’‘'localhost' to database 'openproject' mysql> CREATE USER 'openproject'’localhost’ IDENTIFIED BY ‘my_password’;
ERROR 1227 (42000): Access denied; you need (at least one of) the CREATE USER privilege(s) for this operation
mysql> GRANT ALL PRIVILEGES ON openproject.* TO ‘openproject’'localhost'; ERROR 1044 (42000): Access denied for user ''‘localhost’ to database ‘openproject’


Replies (1)

RE: Set up database_access denied - Added by Philipp Tessenow almost 11 years ago

Hi Julia,

I’m glad to hear that you’ve progressed that far. Let’s see how we can help you to finish the installation.

I suspect that you started the mysql console with an anonymous account, which is not allowed to create new databases or users.

The mysql command on the command line gives you (administrative) access to your databases. But MySQL needs to verify that you are actually allowed to do important changes (like creating a database or a new user). MySQL has different user accounts for that (just like your Mac has different users). The MySQL administrator account is called “root”. The trick is to start mysql and tell it that you are using the root user.

mysql --user=root -p

(I think the root user starts with an empty password; You should set the root password if it is still empty: SET PASSWORD FOR ''‘localhost’ = PASSWORD ('newpassword');@)

Now that you are logged in with the root account, the MySQL commands should work.

cheers,
tessi

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