Open link in a new tab

Content

Expand project menu

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

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.

Message actions

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

Message actions

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