Project

General

Profile

cannot restore database

Added by moi moi about 10 years ago

Hello,

I am using Bitnami-Redmine (Redmine 2.3.3.stable).
I want to upgrade Redmine 2.3.3 to 2.5.1, but got error message.

I tried following:
1. Installed new Bitnami-Redmine
2. move old redmine direcotry
3. dump database by mysqldump: mysqldump -u bitnami -p******** bitnami_redmine > redmine.sql
4. move new redmine directory
5. restore database: mysql -u root -p******** bitnami_redmine < redmine.sql
6. move htdocs directory
7. migrate database: ruby bin\rake db:migrate RAILES_ENV=production

Thanks in advance.

error message:

  • Invoke db:migrate (first_time)
  • Invoke environment (first_time)
  • Execute environment
    rake aborted!
    Access denied for user 'root'@'localhost' (using password: NO)
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/mysql2-0.3.11-x86-mingw32/lib/mysql2/client.rb:44:in `connect'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/mysql2-0.3.11-x86-mingw32/lib/mysql2/client.rb:44:in `initialize'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/connection_adapters/mysql2_adapter.rb:16:in `new'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/connection_adapters/mysql2_adapter.rb:16:in `mysql2_connection'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/connection_adapters/abstract/connection_pool.rb:315:in `new_connection'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/connection_adapters/abstract/connection_pool.rb:325:in `checkout_new_connection'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/connection_adapters/abstract/connection_pool.rb:247:in `block (2 levels) in checkout'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/connection_adapters/abstract/connection_pool.rb:242:in `loop'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/connection_adapters/abstract/connection_pool.rb:242:in `block in checkout'
    C:/Bitnami/redmine-2.5.1-1/ruby/lib/ruby/1.9.1/monitor.rb:211:in `mon_synchronize'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/connection_adapters/abstract/connection_pool.rb:239:in `checkout'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/connection_adapters/abstract/connection_pool.rb:102:in `block in connection'
    C:/Bitnami/redmine-2.5.1-1/ruby/lib/ruby/1.9.1/monitor.rb:211:in `mon_synchronize'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/connection_adapters/abstract/connection_pool.rb:101:in `connection'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/connection_adapters/abstract/connection_pool.rb:410:in `retrieve_connection'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/connection_adapters/abstract/connection_specification.rb:171:in `retrieve_connection'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/connection_adapters/abstract/connection_specification.rb:145:in `connection'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/model_schema.rb:224:in `table_exists?'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/attribute_methods/primary_key.rb:75:in `get_primary_key'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/attribute_methods/primary_key.rb:60:in `reset_primary_key'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/attribute_methods/primary_key.rb:49:in `primary_key'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.17/lib/active_record/attribute_assignment.rb:13:in `attributes_protected_by_default'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activemodel-3.2.17/lib/active_model/mass_assignment_security.rb:216:in `block in protected_attributes_configs'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activemodel-3.2.17/lib/active_model/mass_assignment_security.rb:188:in `yield'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activemodel-3.2.17/lib/active_model/mass_assignment_security.rb:188:in `protected_attributes'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activemodel-3.2.17/lib/active_model/mass_assignment_security.rb:118:in `block in attr_protected'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activemodel-3.2.17/lib/active_model/mass_assignment_security.rb:117:in `each'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activemodel-3.2.17/lib/active_model/mass_assignment_security.rb:117:in `attr_protected'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/app/models/issue_relation.rb:73:in `<class:IssueRelation>'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/app/models/issue_relation.rb:18:in `<top (required)>'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:469:in `load'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:469:in `block in load_file'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:639:in `new_constants_in'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:468:in `load_file'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:353:in `require_or_load'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:502:in `load_missing_constant'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:192:in `block in const_missing'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:190:in `each'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:190:in `const_missing'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:514:in `load_missing_constant'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:192:in `block in const_missing'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:190:in `each'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:190:in `const_missing'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:514:in `load_missing_constant'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:192:in `block in const_missing'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:190:in `each'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:190:in `const_missing'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:514:in `load_missing_constant'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:192:in `block in const_missing'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:190:in `each'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:190:in `const_missing'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/lib/redmine/helpers/gantt.rb:28:in `<class:Gantt>'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/lib/redmine/helpers/gantt.rb:21:in `<module:Helpers>'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/lib/redmine/helpers/gantt.rb:19:in `<module:Redmine>'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/lib/redmine/helpers/gantt.rb:18:in `<top (required)>'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:251:in `require'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:251:in `block in require'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:236:in `load_dependency'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:251:in `require'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/lib/redmine.rb:56:in `<top (required)>'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:251:in `require'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:251:in `block in require'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:236:in `load_dependency'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:251:in `require'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/config/initializers/30-redmine.rb:4:in `<top (required)>'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:245:in `load'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:245:in `block in load'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:236:in `load_dependency'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:245:in `load'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/railties-3.2.17/lib/rails/engine.rb:593:in `block (2 levels) in <class:Engine>'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/railties-3.2.17/lib/rails/engine.rb:592:in `each'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/railties-3.2.17/lib/rails/engine.rb:592:in `block in <class:Engine>'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/railties-3.2.17/lib/rails/initializable.rb:30:in `instance_exec'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/railties-3.2.17/lib/rails/initializable.rb:30:in `run'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/railties-3.2.17/lib/rails/initializable.rb:55:in `block in run_initializers'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/railties-3.2.17/lib/rails/initializable.rb:54:in `each'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/railties-3.2.17/lib/rails/initializable.rb:54:in `run_initializers'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/railties-3.2.17/lib/rails/application.rb:136:in `initialize!'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/railties-3.2.17/lib/rails/railtie/configurable.rb:30:in `method_missing'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/config/environment.rb:14:in `<top (required)>'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:251:in `require'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:251:in `block in require'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:236:in `load_dependency'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:251:in `require'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/railties-3.2.17/lib/rails/application.rb:103:in `require_environment!'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/railties-3.2.17/lib/rails/application.rb:305:in `block (2 levels) in initialize_tasks'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/rake-10.1.1/lib/rake/task.rb:236:in `call'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/rake-10.1.1/lib/rake/task.rb:236:in `block in execute'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/rake-10.1.1/lib/rake/task.rb:231:in `each'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/rake-10.1.1/lib/rake/task.rb:231:in `execute'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/rake-10.1.1/lib/rake/task.rb:175:in `block in invoke_with_call_chain'
    C:/Bitnami/redmine-2.5.1-1/ruby/lib/ruby/1.9.1/monitor.rb:211:in `mon_synchronize'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/rake-10.1.1/lib/rake/task.rb:168:in `invoke_with_call_chain'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/rake-10.1.1/lib/rake/task.rb:197:in `block in invoke_prerequisites'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/rake-10.1.1/lib/rake/task.rb:195:in `each'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/rake-10.1.1/lib/rake/task.rb:195:in `invoke_prerequisites'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/rake-10.1.1/lib/rake/task.rb:174:in `block in invoke_with_call_chain'
    C:/Bitnami/redmine-2.5.1-1/ruby/lib/ruby/1.9.1/monitor.rb:211:in `mon_synchronize'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/rake-10.1.1/lib/rake/task.rb:168:in `invoke_with_call_chain'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/rake-10.1.1/lib/rake/task.rb:161:in `invoke'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/rake-10.1.1/lib/rake/application.rb:149:in `invoke_task'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/rake-10.1.1/lib/rake/application.rb:106:in `block (2 levels) in top_level'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/rake-10.1.1/lib/rake/application.rb:106:in `each'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/rake-10.1.1/lib/rake/application.rb:106:in `block in top_level'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/rake-10.1.1/lib/rake/application.rb:115:in `run_with_threads'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/rake-10.1.1/lib/rake/application.rb:100:in `top_level'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/rake-10.1.1/lib/rake/application.rb:78:in `block in run'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/rake-10.1.1/lib/rake/application.rb:165:in `standard_exception_handling'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/rake-10.1.1/lib/rake/application.rb:75:in `run'
    C:/Bitnami/redmine-2.5.1-1/apps/redmine/htdocs/vendor/bundle/ruby/1.9.1/gems/rake-10.1.1/bin/rake:33:in `<top (required)>'
    bin/rake:16:in `load'
    bin/rake:16:in `<main>'
    Tasks: TOP => db:migrate => environment

Replies (1)

RE: cannot restore database - Added by Martin Denizet (redmine.org team member) about 10 years ago

Hi,
I think you just forgot to configure your MySQL user in config/database.yml.
In case you don't know how to create a MySQL user:

CREATE USER 'redmine'@'localhost' IDENTIFIED BY 'my_password';
GRANT ALL PRIVILEGES ON redmine.* TO 'redmine'@'localhost';
FLUSH PRIVILEGES;
EXIT;

Cheers,

    (1-1/1)