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. Support Installation & Updates

Windows Install, how to run MySQL for the database part of the instructions.

Added by Adam Fogle about 10 years ago

I was able to follow everything up until the following lines:

Modify database.yml and config.yml according to instruction in the manual. (I followed the Ubuntu Steps)

Setup databases according to instruction in the manual. (I followed the Ubuntu Steps)*

Which per the Ubuntu instructions means I need to do the following:

_CREATE DATABASE openproject CHARACTER SET utf8;
CREATE USER ‘openproject’'localhost' IDENTIFIED BY 'my_password'; GRANT ALL PRIVILEGES ON openproject.* TO 'openproject'‘localhost’;_

The problem is that I’ve never used MySQL before, so I do not know what I need to run to be able to enter those commands. I searched for any mysql files that were executable, but I was unable to find anything.


Replies (2)

RE: Windows Install, how to run MySQL for the database part of the instructions. - Added by Brendan Dunn about 10 years ago

Hi Adam

here is the link to the installer
http://www.mysql.com/why-mysql/windows/

and the command line tool
http://dev.mysql.com/doc/refman/5.1/en/mysql.html
google is your friend

Personally, I have installed the free vmware player and installed the ubuntu version inside vmware, much easier imo

cheers
Brendan

RE: Windows Install, how to run MySQL for the database part of the instructions. - Added by learn mews about 10 years ago

Hi Adam,

First you need to install MySQL server (use the url provided by Brendan)

Also, note the password you set for the root user during installation of MySQL server.

Once installed, you can follow the below steps

1. open command prompt and navigate to bin folder in MySQL install directory. (in my case it was c:\program files\mysql\mysql server 5.6\bin)
2. type mysqld to start the server

Now you need to connect to the default test db as root user
3. type mysql -u root -p test

You will be prompted for password
4. Enter the root password (set during installation)

now, you should get MySQL prompt as below
5. MySQL>

Now you can enter those commands and follow along the rest of the installation tutorial.

Hope this helps.

note: I was just installing it today and had to do the above.
Regards,
Bagavathi

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